anything in Excel...

It's Excel-o-lozy...

Shortcut - Quickly apply or remove filter. - Smart Shortcut to apply / remove Auto Filter is as follows:
  • Select the range or first row on the range (Header or Title row)
  • Press "Ctrl + Shift + L"

Note : "Alt D F F" is also an alternative shortcut but I think it's Long-cut not shortcut.

Shortcut to clear filter criteria from all columns, where two or more columns are filtered, will be explained soon.

Anything in Excel, be an Excelolozian...
for best MS Excel Tips visit
gotta query??? drop a mail at