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
6 Use the check boxes to include or exclude specific values.
7 Click OK.
Search JabSto ::

Custom Search