Microsoft Office Tutorials and References
In Depth Information
Sorting worksheet data
To open the Sort dialog box, click Custom Sort in the Sort & Filter list.
If your data has a header row, select the My Data Has Headers check box so the column
headers will appear in the Sort By list. After you identify the column by which you want
to sort, you can use the options in the Sort On list to select whether you want to sort by a
cell’s value (the default), a cell’s fill color, a cell’s font color, or an icon displayed in the cell.
SEE ALSO For more information about creating conditional formats that change a cell’s
formatting or display an icon to reflect the cell’s value, see “Changing the appearance of
data based on its value” in Chapter 4, “Changing workbook appearance.”
Finally, from the Order list, you can select how you want Excel to sort the column values. As
with the Sort & Filter button’s list, the exact values that appear in the Order list change to
reflect the data to be sorted.
Adding, moving, copying, and deleting sorting levels are a matter of clicking the
appropriate button in the Sort dialog box. To add a second level to your sort, click the Add Level
TIP In Excel 2003 and earlier versions of the program, you could define a maximum of
three sorting levels. Beginning with Excel 2007, you can create up to 64 sorting levels.