Microsoft Office Tutorials and References
In Depth Information
The Sort Smallest To Largest and Sort Largest To Smallest options enable you to sort
rows in a worksheet quickly, but you can use them only to sort the worksheet based on
the contents of one column, even though you might want to sort by two columns. For
example, you might want to order the worksheet rows by service category and then by
total so that you can see the customers that use each service category most frequently.
You can sort rows in a worksheet by the contents of more than one column by using the
Sort dialog box, in which you can pick any number of columns to use as sort criteria and
choose whether to sort the rows in ascending or descending order.
To display 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, the Sort On list enables you to select whether you want to sort by a cell’s value (the
default), a cell’s ill 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 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 you want to sort.
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. You can create up to 64 sorting levels in Excel 2010.