Microsoft Office Tutorials and References
In Depth Information
Working with the Sort Command
When you need to go beyond a single
field sort, the Sort command (also found on the
Data tab) is your ticket to multiple-field sorting.
It’s also a great way to lay the groundwork for a
Subtotal report, which you’ll read about in the
last section of this chapter.
Using Sort to Create Groups
What do I mean about the Sort command
creating groups? Well, if you sort the cities
list by state, because there are multiple
cities in individual states, each state becomes
a group—Arizona, then California, then
Colorado, and so on. Each state’s cities can
then be placed in order within the state-based
groups—to provide an even more useful,
So why would you want to sort by more than
one field? Well, sticking with the list of cities,
imagine that you wanted to sort them by state
and by city, so that all the cities are in state
order, and within each group of states that that
sort creates, the cities would be in alphabetical
order. Figure 7-3 shows that sort in place.
To use the Sort dialog box, shown in Figure 7-4,
simply click the Sort button and begin choosing
the fields by which you want to sort, in the order
you want to sort by them. The dialog box gives
you the opportunity to choose the fields to sort
by, as well as to set each one to its own sort
You can sort by more than one field to put
your list in a more usable order.
Use the Sort dialog box to set multiple-field sorts.