MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcut - Add Filter Dropdowns

August 25, 2017 - by Bill Jelen

Excel Shortcut - Add Filter Dropdowns

Excel keyboard shortcut for turning on the filter dropdowns in Excel.

Toggle the filters on or off with Ctrl + Shift + L. Or, press and release Alt +  A + T.

Thanks to David Hager, Andew Walker.

Watch Video

Video Transcript

Learn Excel From MrExcel, Podcast Episode 2139: Turning On The Filter Dropdowns.

Alright. If you have a large data set and you want to apply a filter, CONTROL+SHIFT+L adds the filter dropdowns.

Now, this is beautiful here in Office 365 Excel 2016. The active cell did not change at all, but even just as recently in Excel 2013, when you press CONTROL+SHIFT+L, it's going to select all the way out to the edge of the data like that, alright? The active cell stayed exactly in the right spot but you get to see to the edge. So, CONTROL+BACKSPACE -- talked about that a few episodes ago -- will bring you back; so, CONTROL+SHIFT+L, possibly followed by CONTROL+BACKSPACE.

Well, hey. I want to thank you for stopping by. We’ll see you next time for another netcast from MrExcel.

Title Photo: yusufk53 / pixabay

Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.