Microsoft Office Tutorials and References
In Depth Information
Working with Tables
Filtering a table
Filtering a table refers to displaying only the rows that meet certain conditions. After applying a
filter, rows that don’t meet the conditions are hidden.
Excel provides two ways to filter a table. This section discusses standard filtering (for-
merly known as AutoFiltering), which is adequate for most filtering requirements. For
more complex filter criteria, you may need to use advanced filtering (discussed later in
Using the real estate table, assume that you’re only interested in the data for the N. County area.
Click the drop-down control in the Area Row header and remove the check mark from Select All,
which deselects everything. Then, place a check mark next to N. County and click OK. The table,
shown in Figure 9-9, is now filtered to display only the listings in the N. County area. Notice that
some 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 9-9: This table is filtered to show only the information for N. County.
You can filter by multiple values — for example, filter the table to show only N. County and
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
For additional filtering 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 flexibility in displaying
only the rows that you’re interested in.