 Three, Excel secrets you need to know. Select your desired range, hold down the Alt button and also press the Equals button to get an automatic total of your desired range. If you want to move a column to a new location, all you need to do is select the range, hold down Shift while hovering at the side of the range selected, and then you can click and drag the row or column to a desired location. When you select the column or row, Excel will automatically give you this information. If you require one of these values, all you need to do is select it and it's now been copied through your clipboard for you to paste wherever you require that value. If you enjoyed these three secrets, please don't forget to like the video and also subscribe to our channel for even more great content.