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:
- Select any cell in the dataset in which you want to apply the filters
- Hold the Control key and the Shift key
- 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:
- Select any cell in the data set
- Click the Data tab
- 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:
- Select any cell in the data
- Hold the Control key and then press the T key
- Confirm the range that needs to be converted into an Excel table in the dialog box that opens up
- 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:
- Excel Keyboard Shortcuts
- SAVE AS in Excel
- Switch Between Tabs/Worksheets in Excel
- Zoom-In and Zoom-Out in Excel
- Group Rows or Columns
- Insert Hyperlink in Excel
- Merge or Unmerge Cells in Excel
- Freeze Pane in Excel (Shortcut)
Other Excel articles you may also like:
- How to Clear Filter in Excel? Shortcut!
- VBA Macros to Filter Data In Excel
- How to Paste in a Filtered Column Skipping the Hidden Cells
- How to Delete Filtered Rows in Excel (with and without VBA)
- How to Filter as You Type in Excel (With and Without VBA)
- How to Filter by Color in Excel?
- How to Filter Cells with Notes in Excel?