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

Excel 2003: AutoFilter

Excel 2003: 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 6. Unfiltered List

Figure 7. 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. Choose Data: Filter: AutoFilter from the Menu bar
     
  4.  
  5. Use the drop-down arrows to designate your filter criteria
     

Clearing Filter Criteria

     
  1. Click anywhere inside a filtered list
     
  2.  
  3. Choose Data: Filter: Show All from the Menu bar
     

Turning Off the AutoFilter

     
  1. Click anywhere inside a filtered list
     
  2.  
  3. Choose Data: Filter: AutoFilter from the Menu bar