Filter Shortcut in Excel

Excel Filter Keyboard Shortcut

In Excel, sorting and filtering data is a very important and common task. With the use of this, we can see the data category wise. For example, if you want to see the data/record of a class subject wise or sales data from the dozen of stores that you need to keep track of, you will be able to find the data quickly that you need.

With filtering data quickly, you can easily navigate through menus or clicking through a mouse in less time. In this article, we discuss keyboard excel shortcutsKeyboard Excel ShortcutsAn Excel shortcut is a technique of performing a manual task in a quicker more used for the filter.

How to Use Keyboard Shortcut For Filter in Excel?

Let us understand Filter Shortcut in Excel with the below examples.

You can download this Filter Shortcut Excel Template here – Filter Shortcut Excel Template

Example #1 – Turn Filters ON or OFF in Excel

We have given below sales data region wise.

Filter shortcut Example 1

For this, follow the below steps:

  1. First, select a cell in your data range if the data range contains any blank columns or rows, then better to select the entire range of cells.

    Filter shortcut Example 1-1

  2. Go to the DATA tab; then, click on the Filter option under the Sort Filter section. Refer to the below screenshot.

    Filter shortcut Example 1-2

    We also can use the Keyboard Shortcut CTRL+SHIFT+L for turning On/Off the filters.

    Filter Shortcut key

  3. Once applying the filter, the drop-down filter menus will appear in the header row of your data. Refer to the below screenshot.

    Filter shortcut Example 1-3

Example #2 – Opening the Drop-down Filter Menu in Excel

Once the filter has enabled on your data, you can use the drop-down menus on each of the column headers. Follow the below steps for doing this:

  • Select a cell in the header row. As we can see that every cell contains drop down an icon like the image then, Press the ALT + down arrow key on the keyboard to open the filter menu like the below screenshot.
Filter shortcut Example 1-4
  • As we can see in the above image, there are a lot of keyboard shortcuts available in the filter menu.

Example #3 – Select Menu Items Using Arrow keys

Once the excel filter is enabled, we can use arrow keys to navigate the filter menu. Use Enter and Spacebar key to select and apply to filter. Remember the below points:

  • Press the Up and Down arrow keys to select a command.
  • Press Enter Key to apply the command.
  • Press the Spacebar Key to check and uncheck the checkbox.

Example #4 – Drop Down Menu Keyboard Shortcut for Filter in Excel

You must first press the ALT+ Down Arrow key to display the drop-down menu. With this, you can one of the following:

Example #5 – Clear All Filters in the Current Filtered Range in Excel

Press shortcut key ALT+Down Arrow+C to clear all the filters in the current filtered range. It will clear all the filters in all the columns. After that, all rows of your data will be displayed.

Filter shortcut Example 2

For this, you also can use the Excel ribbonExcel RibbonThe ribbon is an element of the UI (User Interface) which is seen as a strip that consists of buttons or tabs; it is available at the top of the excel sheet. This option was first introduced in the Microsoft Excel more option.

Example #6 – Clear Filter in a Column

To clear filter in a column, follow below steps:

  • Select a cell in the header row and press Alt+Down Arrow to display the filter menu for the column.
Filter shortcut Example 2-1
  • Press the letter “C” to clear the filter.
Filter shortcut Example 2-2

Example #7 – Display the Custom Filter Dialog Box

When you want to filter the data by using custom criteria, you can use a custom filter box. For this, follow the below steps:

  • Select a cell in the header row.
  • Press the ALT+Down Arrow key to display the filter menu for the column.
  • Type the letter “F.”
  • Type the letter ”E.”
  • Then a custom dialog box will appear, which sets the comparison operator to equal. See the below screenshot.
Filter shortcut Example 3
  • Select the option from the list (such as not equal, etc.) and enter the criteria.
Filter shortcut Example 3-1
  • Select And or Or then Press OK to apply the filter.
Filter shortcut Example 3-2

It Displays Filtered Data.

Filter shortcut Example 3-3

Things to Remember About Filter Shortcut in Excel

Recommended Articles

This has been a guide to Filter Shortcut in Excel. Here we discuss how to use keyboard shortcuts for a filter in excel in different ways along with practical examples and downloadable excel templates. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *