How to Sort Columns in Excel 2007

1. Open your spreadsheet file in Microsoft Excel.
2. Press 'Ctrl' and 'A' to select all the columns in your spreadsheet.
3. Click 'Sort Filter' near the right side of the ribbon.
4. Choose 'Custom Sort.'
5. Select the first column you want to sort on, such as Column A, in the first drop-down box.
6. Select the criterion on which you want to sort this column, such as the value of the cell or the cell color, in the second drop-down box.
7. Select your desired sort order, such as A-to-Z or smallest-to-largest, in the third drop-down box.
8. Click the 'Add Level' button if you want to sort by additional criteria.
9. Check 'My Data Has Headers' if your spreadsheet has a header row. If you check this box, Excel will leave the header row as the very top row. Otherwise it would sort your column headings as though they were data.
10. Click 'OK.' Your Excel spreadsheet is now sorted by columns according to the criteria you set.