Learn to AutoFilter a data list

In this lesson you will learn how to use Excel’s AutoFilter to reveal select data records that match your filter criteria.

Here are the steps to follow in this lesson:

1) Organize your list into Columns / Fields that contain a single type of data e.g. Territory

2) Apply a different format to identify the Top Row of your list as the Column Headers

3) Select one cell in the list then choose DATA – FILTER – AUTOFILTER

4) Use the “drop-down” arrow for a field to select your filter

5) The Top 10 Filter is a generic term. e.g. You can filter to Bottom 15items / percent

6) Custom filters allow you to see records that are <, <=, etc.

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Videos

Related Video Lessons

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn


  1. Hello there, You have performed a great job. I’ll certainly digg it and personally suggest to my friends. I am confident they’ll be benefited from this website.


  1. […] preparing for today’s video lessonĀ on my MS Excel blog, I wrote out my script. I read the script aloud several times and revised it. […]

Speak Your Mind