Filter with secret toolbar buttons, what to do when the Status Bars shows Filter mode, and quickly find items in an Excel AutoFilter list
Add special buttons to the toolbar, to make filtering even easier. For written instructions, read the article on the Contextures blog: AutoFilter By Selection In Excel
Sometimes when you apply an Excel AutoFilter, the Status Bar shows "Filter Mode" instead of showing the record count for the filtered data. This video explains why this occurs, and shows a couple of workaround solutions.
For written details, see Count of Filtered Records in Status Bar
Use the Search box feature (Excel 2010 and later) in the AutoFilter drop down, to quickly filter items in a long list.
For written instructions, see the Contextures Blog article: New Search Feature in Excel 2010 AutoFilter
Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.
Last updated: October 31, 2018 11:06 AM
Contextures RSS Feed