» Quick Filtering Using the AutoFilter Icon

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