Apply-Remove Filter In Excel (Shortcut)

Excel provides a filter option that allows users to temporarily hide rows that they don’t want to see. This can be helpful when you’re working with a large spreadsheet and only need to view certain data.

And if you know how to apply filters in Excel with a keyboard shortcut, it can help you speed up your work.

In this tutorial, I will give you the keyboard shortcut to apply Filter In Excel (as well as how to remove these)

Shortcut to Apply and Remove Filter In Excel

Below is the keyboard shortcut to Apply Filters In Excel:

Control + Shift + L

How to Use the Shortcut to Apply Filter In Excel

Below are the steps to use this keyboard shortcut to apply filters to a dataset in Excel:

  1. Select any cell in the dataset in which you want to apply the filters
  2. Hold the Control key and the Shift key
  3. With the Control and the Shift key pressed, also press the L key

This shortcut works as a toggle, which means that if you do not already have filters applied to your data set, using the above keyboard shortcut would apply the filters in the column headers.

And if you already have the filters applied, using the same keyboard shortcut would remove the filters.

Another keyboard shortcut that you can use to apply or remove filters is ALT + A + T. To use this shortcut, press these keys one after the other.

Alternative Ways to Apply Filters to Columns in Excel

While using the keyboard shortcut to apply or remove the filter is the fastest way to do this, there are other ways too.

Using the Filter Option in the Ribbon

Below is an alternate method you can use to apply filters (or remove filters) in a data set in Excel:

  1. Select any cell in the data set
  2. Click the Data tab
  3. Click on the Filter icon

Converting Data into an Excel Table

When you convert your tabular data into an excel table, filters are automatically applied to the column headers.

In most cases, it is recommended to convert your data into an Excel table, as it allows a lot more functionality (along with adding filters to the data).

To convert a regular tabular table into an Excel table, follow the below steps:

  1. Select any cell in the data
  2. Hold the Control key and then press the T key
  3. Confirm the range that needs to be converted into an Excel table in the dialog box that opens up
  4. Click the OK button

So these are some of the keyboard shortcuts you can use to quickly apply filters or remove filters in Excel.

Other Excel shortcuts you may also like:

Other Excel articles you may also like:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.