Part I: Getting Started with Excel
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 Sort ➪ Custom Sort from the shortcut menu.
In the Sort dialog box, use the drop-down lists to specify the sort specifications. 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 specifications for the Area col-
umn. Then add another level and enter the specifications for the List Price column. Figure
4.23 shows the dialog box after entering the specifications for the three-column sort. This
technique produces the same sort as described previously in this section.
FIGURE 4.23
Using the Sort dialog box to specify a three-column sort
Filtering a table
Filtering a table refers to displaying only the rows that meet certain conditions. (The other
rows are hidden.)
Note that entire worksheet rows are hidden. Therefore, if you have other data to the left or
right of your table, that information may also be hidden when you filter the table. If you
plan to filter your list, don’t include any other data to the left or right of your table.
Using the real estate table, assume that you’re interested only in the data for the
Downtown area. Click the Filter Button in the Area row header and remove the check mark
