Sort your month and day names chronologically — not alphabetically (Excel 2003/2007)

If you sort data based on a column of month or weekday names, Excel sorts the data alphabetically. Chances are you'd rather sort the information in chronological order. Fortunately, it's easy to do so.

To change your sort to a chronological order:

1. Select any cell in the column of month or weekday data.
2. Choose Data | Sort from the menu bar to display the Sort window.
3. Click the Options button. (In 2007, choose Custom List from the Order dropdown list.)
4. Select the appropriate custom list using the First Key Sort Order dropdown list.
5. Click OK twice to dismiss the open dialog boxes and apply the sort order.