Blog

Filtering your list with multiple criteria really isn’t a whole lot different from using single criteria.
Here’s what you need to remember:

- To create an AND criteria, put your criteria on the SAME row

- To create an OR criteria, put your criteria on SEPARATE rows

Using the Advanced Filter with Multiple Criteria
1. Create your criteria field in an area well to the right of or below your existing list
2. Click anywhere inside your list
3. Click the Advanced command in the Sort & Filter group on the Data tab
4. Choose to Filter the list, in-place or Copy to another location
5. Verify the List range
6. Enter the Criteria range
7. If you are copying the data to another location, enter the starting cell of the copied list location
8. Click OK

Clearing Filter Criteria
1. Click anywhere inside a filtered list
2. Click the Clear command in the Sort & Filter group on the Data tab

Turning Off the Advanced Filter
1. Click anywhere inside a filtered list
2. Click the Filter command in the Sort & Filter group on the Data tab

Subscribe to the Keystone OnDemand blog to be the first to learn about future Microsoft Office 2010 and SharePoint Training news and special subscriber offers.