Bottom line: In this 2nd video of the series on Excel Filters I explain all of my favorite keyboard shortcuts for filtering. These will save you a ton of time!
Skill level: Beginner
Video #2: Keyboard Shortcuts for the Filter Drop-down Menus
In this second video I explain how to use keyboard shortcuts for the filter drop-down menus. This will save lots of time with common filtering tasks like filtering for blanks, zeros, errors, custom searches, and much more.
Double-click video to view full screen HD.
Download the file I used in the video to follow along. This file also contains instructions on each shortcut, and can be used as a guide to learn the shortcuts.
Become a Keyboard Shortcut Ninja!
Learning keyboard shortcuts in Excel can really save us a lot of time, especially with filters. The filter menus have a ton of features and options for us to choose from, and this usually means navigating menus and sub-menus with the mouse.
Fortunately, almost every command in the filter menus is accessible with a keyboard shortcut. Some of these keyboard shortcuts can get long, but I recommend learning the ones you will use the most.
I have another popular article on 7 Keyboard Shortcuts for the Filter Drop-down menus that contains guides for some of the shortcuts in this video.
I also recommend getting a good keyboard that is conducive for Excel keyboard shortcuts. Checkout my article on the best keyboards for Excel keyboard shortcuts for more on that. I prefer to use keyboards that have a menu key and function keys that are not shared.
Click here to learn more about what makes a good keyboard for Excel keyboard shortcuts, and see which keyboard I use.
Filter Mate's Find Feature
At the end of the video I share a tip on how to use the Excel's Find window to find a column you want to apply a filter to. This tip can save us time and prevent some horizontally scrolling, but it does require us to know the exact name of the column header we are looking for.
The Filter Mate Add-in has it's own Find feature that allows you to see a list of all the column names in the filtered range or table, and quickly filter down the list by typing a search. Once you find the column you are looking for, simply press Enter to select that column and set focus to Excel. You can then press the Alt+Down Arrow shortcut to open the filter drop-down menu.
The entire column is selected so you can also use this feature to tie out numbers. If the column contains numbers then you can quickly see the metrics for Sum, Count, Average, etc. in the status bar in the bottom right corner of the application window.
The Filter Mate Add-in will be available soon. You can signup here to get notified when Filter Mate is available.
What's Your Favorite Filtering Tip?
I shared quite a few tips for working with filters in this first video. I'm curious to know if you have a favorite tip or shortcut that you use.
Please leave a comment below with your favorite tip. You can also leave a question with a tip or technique that you would like to learn.
I'll be back next week with video #3 of the series. Thank you!