Microsoft Office Tutorials and References
In Depth Information
Managing Large Amounts of Data
Performing a Secondary Filter
Secondary filters are used when you want to be
even more specific than with a single filter. With a
single filter, you pick, for example, the city of
Miami. The secondary filter comes into play when
you want to see only the people in Miami with a
last name of Schwartz. Here’s how you perform a
secondary filter selection:
Each additional filter is based on the current
filter and further reduces the subset of data.
5. Select the field by which you want to perform
the second filter. In Figure 11-32, the primary
option was to filter by House type of Condo.
In Figure 11-33, the data is additionally
filtered to show only the By Owner agent.
Make sure the AutoFilter option is on and
your database columns contain filter arrows.
2. Click the column arrow by which you want
to filter data first.
3. Choose the data you want to filter. In Figure
11-32, you see only selections that display
only the Condos in the House Type column.
Note, however, that there are different
Agents involved in the Condos.
Data filtered twice.
6. Repeat Steps 4 and 5 to further filter by as
many fields as necessary.
When you're finished working with your
filtered data, choose one of these options:
To return to the first filter only, click the
second filter column arrow and choose
Clear Filter from “field name.”
To return to viewing all records, choose
Data>Sort & Filter>Clear.
Data filtered using the AutoFilter.
Don’t Mix Data Types
When working with filters, it’s best not to mix
text, number, and date formats in the same
column because only one type of filter
command is available for each column. If a mix of
formats occurs, the command displayed has
the format that is used most frequently.
4. To further isolate specific items, click the
filter arrow at the top of another column, in
this example, Agent.