Excel 2010 Bible

Part I: Getting Started with Excel

112

FIGURE 5.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. County area.

Click the drop-down arrow in the Area Row Header and remove the check mark from Select All,

which unselects everything. Then, place a check mark next to N. County and click OK. The table,

shown in Figure 5.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 5.12

This table is filtered to show only the information for N. County.