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

Excel 2007: Advanced Filter Using Single Criteria

Excel 2007: Advanced Filter Using Single Criteria

Although the AutoFilter is nice, you are limited to filtering your list in place. However, Excel’s Advanced filter feature gives you the option of filtering your existing list in place or copying the data that matches your set criteria to another location in the existing worksheet or in another worksheet altogether.

However, with the Advanced Filter, you have to actually type in your criteria (instead of being able to select it from drop-down list). Which, once you understand how the criteria needs to look, it really isn’t all that big of a deal.

Figure 22. Advanced Filter Dialog Box

Using the Advanced Filter with Single 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