Page 149 - Excel 2007 Bible

10_044039 ch06.qxp 11/21/06 10:57 AM Page 106
Part I
Getting Started with Excel
the sort specifications for the Area column. Then, add another level and enter the specifications for the List
Price column. Figure 6.11 shows the dialog box after entering the specifications for the three-column sort.
This technique produces exactly the same sort as described in the previous paragraph.
FIGURE 6.11
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.)
Using the real estate table, assume that you’re only interested in the data for the N. Country area. Click the
drop-down in the Area Row Header and remove the check mark from Select All, which unselects every-
thing. Then, place a check mark next to N. County and click OK. The table, shown in Figure 6.12, is now
filtered to display only the listings in the N. County area. Notice that some of the row numbers are missing;
these rows contain the filtered (hidden) data.
Also notice that the drop-down arrow in the Area column now shows a different graphic — an icon that
indicates the column is filtered.
FIGURE 6.12
This table is filtered to show only the information for N. County.

106