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 🙂
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.
