Clear all filters

Is there a way to clear all filters within a sheet (keep filters there, but press some magical button to reset all of them)?

Originally Posted by Ron Coderre

Perhaps this keyboard shortcut

Type: [ALT]
Then type: DFS

That will clear all autofilter settings, but leave the autofilter engaged.

Note: Those are the underlined letters in the Excel Menus

Does that help?

Thanks a lot!

Originally Posted by Ron Coderre

Perhaps this keyboard shortcut

Type: [ALT]
Then type: DFS

That will clear all autofilter settings, but leave the autofilter engaged.

Note: Those are the underlined letters in the Excel Menus

Does that help?

Exactly what I needed, Ron. Thanks for the help. (This will save me a ridiculous amount of time everyday!!)

thanks you very much