Microsoft Office Tutorials and References
In Depth Information
Sorting and filtering a table
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 19.9, is
now ﬁ filtered to display only the listings in the N. County area. Notice that some of the
row numbers are missing. These rows are hidden and contain data that does not meet the
speciﬁ ed criteria.
This table is ﬁ filtered to show only the information for N. County.
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 N. County 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 N. County listings in which the Type is Single Family. Just repeat the operation
using the Type column. All tables then display only the rows in which the Area is N. County
and the Type is Single Family.
For additional ﬁ ltering options, select Text Filters (or Number Filters, if the column
contains values). The options are fairly self-explanatory, and you have a great deal of
ﬂ exibility in displaying only the rows that you’re interested in. For example, you can
display rows in which the List Price is greater than or equal to $200,000, but less than
$300,000 (see Figure 19.10). Click OK to apply the ﬁ filter and close the Custom AutoFilter