To insert a filter in Excel using a keyboard shortcut you need to click in a column heading and press CTRL+SHIFT+L
To un-filter, you need to press this shortcut again. I use this shortcut all the time 🙂
CTRL + SHIFT + L: Insert a Filter in Excel
About The Author
want to learn all formulas and functions in excel with shortcuts
-
Hey Ankita,
Here is the link to learn Formulas: https://www.myexcelonline.com/category/formulas/
Cheers,
John
Hi John,
This shortcut is not working for me, in both a normal range and a table, selecting a header cell then ctrl + shift + L doesn’t toggle the filter, it simply moves the header cell selection across 1 column to the right (Excel 2013). Am I missing something?
Dave.
-
Dave,
It may be that you already have a filter in your worksheet, that´s why it is not working.
Copy and paste your data into a new worksheet and then apply the shortcut. Lte me know how you get on.
Thanks,
John
