shortcut to remove all filters
easy shortcut to remove all the filters on tables in a worksheet.
I work in finance and always filtering and unfiltering multiple columns, it would be fantastic and save so much time to have this shortcut.
Stephanie Hawley commented
Macro, clear all filters with a shortcut in the quick access. use it all the time.
'This macro removes any filtering in order to display all of the data but it does not remove the filter arrows
If (ActiveSheet.AutoFilterMode And ActiveSheet.FilterMode) Or ActiveSheet.FilterMode Then
Michael Daughety commented
From the "Home" tab, click on the "Sort & Filter" dropdown. Click on "Clear". This will remove all filters on the worksheet.
Jerry Norbury commented
@sylvie from France
Exactly I've got that in the FIRST position - ALT+1
Sylvie from France commented
Add the button "clear all" to the quick access toolbar. It will save you lost of time!