Microsoft Office Tutorials and References
In Depth Information
Sorting and filtering a table
sort, ﬁ rst sort by the List Price column, then sort by the Area column, and then sort by the
Agent column. Figure 19.8 shows the table sorted in this manner.
A table, after performing a three-column sort
When a column is sorted, the Filter button in the header row displays a different graphic to remind you that the table
is sorted by that column.
Another way of performing a multiple-column sort is to use the Sort dialog box (choose
Home ➪ Editing ➪ Sort & Filter ➪ Custom Sort). Or right-click any cell in the table and choose
Custom Sort from the shortcut menu.
In the Sort dialog box, use the drop-down lists to specify the sort speciﬁ cations. In this
example, you start with Agent. Then click the Add Level button to insert another set of
search controls. In this new set of controls, specify the sort speciﬁ cations for the Area
column. Then add another level and enter the speciﬁ cations for the List Price column. Click
OK to apply the sort. This technique produces exactly the same sort as described in the
Filtering a table
Filtering a table refers to displaying only the rows that meet certain conditions. The other
rows are hidden. Note that the entire rows are hidden. Therefore, if you have other data
to the left or right of your table, that information will also be hidden. If you plan to ﬁ filter
your list, don’t include any other data to the left or right of your table.
Using the example real estate table we’ve been discussing, assume that you’re only
interested in the data for the N. County area. Click the Filter Button in the Area Row