Microsoft Office Tutorials and References
In Depth Information
column. Then, add another level and enter the specifications for the List Price column. Figure 9-8 shows the
dialog box after entering the specifications for the three-column sort. This technique produces exactly the same
sort as described previously.
Figure 9-8: 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. After applying a filter, rows that
don't meet the conditions are hidden. Filtering a table lets you focus on a subset of interest.
Excel provides two ways to filter a table. This section discusses standard filtering,
which is adequate for most filtering requirements. For more complex filter criteria, you
may need to use advanced filtering (discussed later in this chapter).
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 (see Figure 9-9). Click OK, and the table will be filtered to display
only the listings in the N. County area. Rows for other areas are hidden.
You can filter by multiple values — for example, filter the table to show only N. County and Central.
You can filter a table using any number of columns. For example, you may want to see only the N. County list-
ings 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 filtering options, select Text Filters (or Number Filters, if the column contains values). The op-
tions are fairly self-explanatory, and you have a great deal of flexibility in displaying only the rows that you're