Microsoft Office Tutorials and References
In Depth Information
Filtering data quickly with AutoFilter
Create a filtering rule
1 Click any cell in the list that you want to filter.
2 Click the Data tab.
3 If necessary, click Filter to display the filter arrows.
4 Click the filter arrow of the column for which you want to create a
5 Point to Text Filters.
6 Click Custom Filter.
7 Click the Comparison Operator down arrow.
8 Click the comparison that you want to use.
9 Type the value with which you want to compare the values in the
10 Click OK.
TIP When a column is filtered, the filter arrow that appears to
the right of the filtered list header is replaced by a filter icon.