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

Excel 2007: AutoFilter

Excel 2007: AutoFilter

I know I’ve probably said this before, but AutoFilter is one of my favorite Excel features. But, only because it makes my job so much easier. There are many times when you’re dealing with a large amount of data and you only need a small portion of it for a meeting.

Figure 20. Unfiltered List

Figure 21. Filtered List

In the example above, you can see the original list with all entries was quickly pared down to just a list of three by using the AutoFilter feature. A filtered list is easy to recognize by looking at the row numbers. A filtered list’s row numbers will skip consecutive numbers and the number will be displayed in blue.

Turning On the AutoFilter

     
  1. Click anywhere inside an existing list
     
  2.  
  3.  Click the Filter command in the Sort & Filter group on the Data tab
     
  4.  
  5. Use the drop-down arrows to designate your filter criteria
     

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 AutoFilter

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