Database Reference
In-Depth Information
Suppose we want to display the records for customers living in Washington (WA) at
the top of the list. Let's reverse the sort order by using a different method.
4
On the
Home
tab, in the
Sort & Filter
group, click the
Descending
button.
In both sorts, the region was sorted alphabetically, but the City field was left in a
seemingly random order. Let's sort the City field and then the Region field to display
the records arranged by city within each region..
5
Click the arrow to the right of the
City
field name, and then click
Sort A to Z
to sort
the records alphabetically by city.
6
To finish the process, right-click anywhere in the
Region
column, and then click
Sort
A to Z
.
Both the City and Region field names have upward-pointing arrows, indicating that the records
have been sorted on both fields.
Now let's sort both fields at the same time. First we have to revert to the previously
saved sort order.
7
On the
Home
tab, in the
Sort & Filter
group, click the
Remove Sort
button to clear
the sort from both fields.