1-866-245-5224 sales@keystonelearning.com

Excel 2007: Advanced Filter Using Multiple Criteria

Excel 2007: Advanced Filter Using Multiple Criteria

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.  
  3. Click anywhere inside your list
     
  4.  
  5. Click the Advanced command in the Sort & Filter group on the Data tab
     
  6.  
  7. Choose to Filter the list, in-place or Copy to another location
     
  8.  
  9. Verify the List range
     
  10.  
  11. Enter the Criteria range
     
  12.  
  13. If you are copying the data to another location, enter the starting cell of the copied list location
     
  14.  
  15. Click OK
     

Clearing Filter Criteria

     
  1. Click anywhere inside a filtered list
     
  2.  
  3. 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.  
  3. Click the Filter command in the Sort & Filter group on the Data tab