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.
July 13th, 2008 at 4:06 PM
[...] 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. [...]
July 13th, 2008 at 7:01 PM
[...] Original post by Danny [...]
August 3rd, 2008 at 1:36 PM
[...] Learn to AutoFilter a data list [...]
December 31st, 2009 at 8:23 AM
[...] Learn to AutoFilter a data list in Excel [...]
December 31st, 2009 at 8:24 AM
[...] Learn to AutoFilter a data list [...]
March 11th, 2012 at 7:17 AM
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.