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.
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.