Type into the cell A1, =Column(). Then press Enter. You will notice that the cell will return the cell number of the cell that contains the formula. Type into any of the cells in your spreadsheet ...

One of the most common functions in an Excel spreadsheet is sorting ... repopulate your columns in alphabetical order (or backwards, if you choose). 3. You will be asked if you want to sort ...

3. Right-click anywhere in the column ... a feature especially helpful if you've hidden multiple columns throughout a large spreadsheet.