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 🙂


728x90

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn