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