Excel Shortcut to Filter by Selection

Add an Auto Filter command to the QAT (Quick Access Toolbar). Here is how you do that:

1) Click the down arrow at the end of the QAT and choose “More Commands”
2) Select All Commands
3) Scroll down to Auto Filter
4) Click Add
5) Click OK

Source: How To Filter By Selection With Keyboard Shortcuts In Excel

Advertisements