Chapter 4: Working with Excel Ranges and Tables
4
from Select All, which deselects everything. Then place a check mark next to Downtown
and click OK. The table, shown in Figure 4.24, is now filtered to display only the listings in
the Downtown area. Notice that some of the row numbers are missing. These rows are hid-
den and contain data that does not meet the specified criteria.
FIGURE 4.24
This table is filtered to show the information for only one area.
Also notice that the Filter Button in the Area column now shows a different graphic—an
icon that indicates the column is filtered.
You can filter by multiple values in a column using multiple check marks. For example, to
filter the table to show only Downtown and Central, place a check mark next to both values
in the drop-down list in the Area row header.
You can filter a table using any number of columns. For example, you may want to see only
the Downtown listings in which the Type is Condo. Just repeat the operation using the Type
column. The table then displays only the rows in which the Area is Downtown and the Type
is Condo.
For additional filtering options, select Text Filters (or Number Filters, if the column con-
tains values). The options are fairly self-explanatory, and you have a great deal of flex-
ibility in displaying only the rows in which you’re interested. For example, you can display
rows in which the List Price is greater than or equal to $200,000 and less than $300,000
(see Figure 4.25).