Search Contextures Sites
Custom Search

 

More Excel Videos

Excel Videos - Index

Macros

Mouse Shortcuts

Pivot Table Tips

Names

Paste Special

Create UserForms

Copy VBA

 

 

 

 

 

Excel Videos -- AutoFilter

Filter with secret toolbar buttons, what to do when the Status Bars shows Filter mode, and quickly find items in an Excel 2010 AutoFilter list.

AutoFilter by Selection With Secret Toolbar Buttons

Excel AutoFilter Status Bar Shows Filter Mode

Quickly Find Items in Excel 2010 AutoFilter List

AutoFilter by Selection With Secret Toolbar Buttons

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

Excel AutoFilter Status Bar Shows Filter Mode

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

Quickly Find Items in Excel 2010 AutoFilter List

Use the new Search box feature in the Excel 2010 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

More Video Tutorials

Excel Videos - Index

Macros

Mouse Shortcuts

Pivot Table Tips

Names

Paste Special

Create UserForms

Copy VBA

Get All the Excel News

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.

 

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.

 

Last updated: May 30, 2016 10:17 AM