» Quick Filtering Using the AutoFilter Icon
CATEGORY - Excel Filter
VERSION - All Microsoft Excel Versions
To quickly filter a List, add the AutoFilter and Show All icons to the Standard toolbar:1. Place the mouse arrow on one of the toolbars, right-click, and select Customize from the shortcut menu.
2. In the Customize dialog box, select the Commands tab.
3. From Categories, select Data, and from the Commands box, drag the AutoFilter and Show All icons to the Standard toolbar.
4. Click Close.
Using keyboard shortcuts
After the Show All icon has been added, press Alt+S to show all items after filtering.
Note: The total number of unique items available for filtering is limited to 999.
Book Store:
Recommended Books:
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- The Analysis and Use of Financial Statements
- Microsoft Windows XP Registry Guide
- The Guide to Understanding Financial Statements
- Understanding Financial Statements
No comments have been submitted.
