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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

CTRL + ENTER: Fill Down If you want to make a change to a cell and reflect that change to a selection of cells, then pressing CTRL + ENTER will fill down or copy your action to the selected cells.Helpful Resource:
Top 10 Excel Productivity Tips Excel is used by more than 750 million people around the world and only 5% really know how to use its full suite of tools.In this post I will show you the top 10 Excel productivity tips that you need to know in order to complete your tasks much quicker within Excel, so yo...
CTRL + F1: Hide/Unhide the Ribbon If you want to have more space in your workbook you can hide the Ribbon menu by pressing CTRL + F1.Another way is to click on the ^ icon which is located on the far right hand side of the Ribbon menu.Helpful Resource:
CTRL + -/+: Insert or Delete Rows and Columns in E... One of my favourite Excel keyboard shortcut and one that I use hundreds of times per week is the insert or delete rows and columns.All you have to do is select the whole row or column with your mouse and then press the following:CTRL + - to delete or CTRL + + to insert ...