Sign up for our Excel webinar, times added weekly: [ Ссылка ]

This 2nd video in the series is all about Keyboard Shortcuts for the Filter Drop-down menus. These shortcuts will save you a lot of time when applying filters to ranges or Tables in Excel.

Click here to download the file used in the video: [ Ссылка ]

Learning keyboard shortcuts can really help us work more efficiently with Filters. There are a lot of features and options within the filter menus that can take extra time to navigate to with the mouse.

Keyboard shortcuts make this process much faster. In the video I explain some common filtering tasks like filtering for zeros, errors, blanks, custom search criteria, and more.

I also have an article that explains these shortcuts and tips in written form.

[ Ссылка ]

I recommend getting a good keyboard that works well for Excel and keyboard shortcuts. Here is an article where I explain what to look for when buying a keyboard, and I also share some of my favorite keyboards.

[ Ссылка ]

Throughout the video series I will also be sharing an Excel Add-in I developed called Filter Mate. Filter Mate is a productivity add-in that will help save you time when working with filters.

Filter Mate & the Filters 101 Course are now available. Click here to learn more. [ Ссылка ]

Please leave a comment on the following page with your favorite keyboard shortcut for filters. [ Ссылка ]

Video #1: [ Ссылка ]
Video #3: [ Ссылка ]
00:00 Introduction
00:31 Filter Dropdown Menu
06:49 Filtering for Blanks Zeros Errors
10:00 Filtering for Selected Cells Values
11:37 Filtering for Columns

свернуть