Microsoft Office Tutorials and References
In Depth Information
Sorting by More than One Field
The On top/bottom options are the color-ordering equivalents of A-Z and Z-A. There’s no inherent
ascending or descending color order, after all.
The same idea applies to Cell Icon—if you’ve conditionally formatted certain values to exhibit this
or that icon, they can be sorted first. In our case, though, we’re sorting on values.
Order refers to the direction of the sort—A-Z or Z-A. But there’s another option there, too— Custom
List… . If you have a field whose data consists of days of the week, for example, clicking Custom List and
then clicking the built-in days of the week Custom List (remember that?) lets you work with a sort order
in which Monday can be sorted before Friday, even though the latter comes first alphabetically (and
remember: you can compose your own custom lists, and sort by any of these, too, Figure 6–10).
Figure 6–10. Where to initiate a custom sort
So now we’re ready to sort the database by Last Name—but because we have duplicates in that field,
we want to sort by First Name, too. As a result, we need to click the Add Level button, and select First
Name on the new drop-down arrow alongside that field (Figure 6–11):
Figure 6–11. Sorting by two fields…