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
For regular Excel news, tips, videos, and special offers, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.
Last updated: January 1, 2017 12:49 PM
Contextures RSS Feed