Microsoft Office Tutorials and References
In Depth Information
Creating an AutoFilter
To apply a filter to your data, follow these steps.
The AutoFilter’s drop-down menu will
show up to 10,000 unique data points,
such as product numbers. You may need
to use additional criteria to filter some
of your tables.
1. Remove the check mark from the Select All
option. The check marks are automatically
removed from the rest of the unique entries.
2. Click the filtering option you want to see on
your worksheet and click OK to apply the
filter. In Figure 8-3, selecting the F option from
the Gender column will filter out any records
with an M in that column.
The correct filtered data is displayed in the
worksheet and the filter arrow has changed
(see Figure 8-4). Once a filter is applied, the
image next to the column title changes to look
like a funnel to indicate that a filter is in use.
The arrow on the column header becomes
a funnel once a filter has been applied.
To remove the filters from the worksheet and
return to the full unfiltered list of data, choose
one of the following options:
Click the filter button next to the column
header and choose Clear Filter (see Figure
Click the Select All option and then click
Choose Data > Filter from the Ribbon.
Number of Records Displayed
Whenever a ﬁlter is applied to your data,
the number of records displayed appears in
Excel’s status bar. In Figure 8-6, Excel found
that 28 of the 59 records in the worksheet
database ﬁt the ﬁlter.
Select only those values you want to see
in your filtered worksheet data.