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

Auto-Generated Transcript

  • Learn Excel from MrExcel Podcast
  • episode 2139 turning on the filter
  • drop-down alright if you have a large
  • data set you want to apply a filter
  • control shift l adds the filter
  • drop-down so now this is beautiful here
  • in office 365 Excel 2016 the active cell
  • did not change at all but in even it
  • 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
  • all right the XSL stayed exactly the
  • right spot but you get to see to the
  • edge so ctrl backspace talked about that
  • a few episodes ago
  • we'll bring you back so ctrl shift L
  • possibly followed by ctrl backspace okay
  • I want to thank you for stopping by was
  • you next time for another net cast 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.