Microsoft Excel X for Mac OS X: Visual QuickStart Guide

Sorting

You can sort lists by any column(s). Excel will quickly put database information in the order you specify.

To sort a list

1.	Select any cell in the list.
2.	Choose Data > Sort (Figure 9) to display the Sort dialog (Figure 41). Figure 41. The Sort dialog, with a primary and secondary sort set up.
3.	Choose a primary sort field from the Sort by pop-up menu (Figure 42). Figure 42. The Sort by (or Then by) pop-up menu lists all database fields.
4.	Select a sort order radio button: Ascending is lowest to highest. Descending is highest to lowest. ...