Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

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: https://www.excelcampus.com/tables/filters-training-part-2/

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.

https://www.excelcampus.com/keyboard-shortcuts/filter-dropdown-menu-shortcuts/

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.

https://www.excelcampus.com/keyboard-shortcuts/best-keyboards-for-excel-keyboard-shortcuts/

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. https://www.excelcampus.com/filter-mate/

Please leave a comment on the following page with your favorite keyboard shortcut for filters. https://www.excelcampus.com/tables/filters-training-part-2/

Video #1: https://www.youtube.com/watch?v=cB5koQvGwsA
Video #3: https://www.youtube.com/watch?v=rgATdkyLey8
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