Click any cell inside your data and press Ctrl + Shift + L. Excel adds filter arrows to the header row of the whole block of data around that cell. Press Ctrl + Shift + L again to remove them.
To open one column’s filter menu from the keyboard, select its header cell and press Alt + Down Arrow.
Two other key sequences do the same on/off toggle, pressed one key after another: the ribbon key tips Alt, A, T (Data → Filter) and the old Excel 2003 menu keys Alt, D, F, F. Excel for Mac uses a different shortcut.
Turning the filter off with Ctrl + Shift + L also discards every criterion you set. To show all rows again but keep the arrows in place, use Data → Clear (Alt, A, C).
If the arrows stop short of some columns, or rows at the bottom are never filtered, a completely blank column or row has split your data. Select the whole range, headers included, before you press the shortcut, or remove the blank row or column.
Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)
To apply a filter on a data column, you need to use the keyboard shortcut Ctrl + Shift + L. When you press this keyboard shortcut, Excel applies the data filters to the current column and to all the adjacent columns where you have data.
Shortcut to Apply and Remove Filter
Ctrl + Shift + L
Apart from that, there’s one more shortcut key that you can use to apply data filters to the column, and that’s:
Alt > D > F > F.
This keyboard shortcut works the same as the earlier one, and you can use the same shortcut key to remove the filter as well. It’s an old menu shortcut from Excel 2003 that still works; the ribbon version is Alt > A > T (Data ➜ Filter).
Shortcuts to Use the Filter
Once the filter buttons are there, you can work with them without the mouse:
- Alt + Down Arrow: select a header cell and press it to open the filter drop-down of that column. Then use the arrow keys and Spacebar to tick or untick items, and press Enter.
- Alt > A > C: clears all the filters on the sheet but keeps the filter buttons (Data ➜ Clear).
- Ctrl + Alt + L: reapplies the filter after you change the data.
- Mac: use Command + Shift + F to turn the filter on or off.
Frequently Asked Questions
Why does the filter not cover all my data?
Ctrl + Shift + L applies the filter to the current region, which stops at the first completely blank row or column. Select the whole range first and then press the shortcut, or convert the data into a table with Ctrl + T.
What is the difference between removing and clearing a filter?
Clearing a filter shows all the rows again but keeps the filter buttons. Removing the filter (Ctrl + Shift + L again) takes the buttons away and shows all the rows.
Can I filter more than one column at a time?
Yes. Each column has its own filter, and Excel only shows the rows that meet all the filters together.