Microsoft Office Tutorials and References
In Depth Information
Filtering data with a search filter
Filtering data with a search filter
Collections of data often have strings of characters that occur
in multiple values. For example, if you maintain a list of sales
by region, you might have regions named North Central,
Northwest, and Northeast. If you want to display values from
the northern regions, you can create a search filter based on the
term north .
Create a search filter
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
search filter.
5 In the Search box, type the character string for which you want to
search.
6 Use the check boxes to include or exclude specific values.
7 Click OK.
1
4
3
2
5
6
7
Search JabSto ::




Custom Search