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

 

728x90

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Related Excel Tutorials