I've got two shortcuts for you if you'd like to filter data faster.
Video TutorialWatch on YouTube & Subscribe to our ChannelDownloads Filter By Cell Value.xlsxDownload Shortcut #1: Open Filter Drop-Down Using Alt + ↓With a cell in the header row selected (as long as you have filters applied), when you use Alt + ↓ , it will open up the filter drop-down menu.
To navigate the menu using the keyboard instead of the mouse, you can use the up and down arrows or type the underlined letter to select the option you wish to use. For example, typing the letter O in the menu below will sort the column in reverse alphabetical order.
Shortcut #2: Jump to Search Using EYou can also speed up your filtering by using the search box in the drop-down menu. The keyboard shortcut to jump to the search box is the letter E.
From there, you can type whatever you are searching for and hit Enter to apply your search.
Bonus Tip: Open the Filter Drop-Down from within an Excel Table Using Shift +Alt + ↓I mentioned above that to use the Alt + ↓ shortcut, you need to start with your header cell selected. However, if you are using Excel Tables, you can actually open the filter drop-down menu from within the table by using Shift +Alt + ↓. Your filtering will apply to the column you have selected within the table.
Check out these posts for more information about Excel filters and Excel Tables:
Share your filtering tips or ask a question in the comments below!
Link to post: Filter by Cell Value