|
» Quick Filtering Using the AutoFilter Icon
CATEGORY: Excel Filter |
VERSIONS: 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. |
| Screenshot // Quick Filtering Using the AutoFilter Icon |
  |
|
RATING:
3.25
VIEWS: 33448 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
