Auto Filter

Only what you want

Excel has a tool to sort lists with a number of criteria.

Select a single cell in the table and go to Data>Filter AutoFilter.
Click on the down arrow next to the field name and choose Custom.

The illustration shows how to set up a filter that displays data between two dates.



Contextures.com:
AutoFilter Tips

"Some tips and techniques for working with AutoFilters, and some workarounds for problems you may encounter."

Microsoft Assistance:
All about AutoFilters Video


Jay Walkenbach:
Displaying AutoFilter criteria



"The Display Filter Criteria doesn't work well. It only works when after set the filter, the cell with the formula is selected. Then press F2 after that push the Enter key. Then it works. but the cell with the formula isn't updated automatically..."

# posted by W. van Dam : 7/06/2005



See all Topics