You can add a button to your favorite toolbar.

Tools|customize|commands tab|Data category
Look for "Show All"

And drag it to the toolbar.

This button will be available for every worksheet.

You may want to drag the autofilter button to that same toolbar. Just select
your range and click that button to do the same as Data|filter|autofilter.

Cheese wrote:

I recently saw a spreadsheet (don't have the file) that used an Autofilter
for the column titles on a freezed pane. Very standard set-up that most of
you are well aware of. The big difference is that a Form-type button coupled
with a macro was set-up to reset all Autofilters in use. All you did was
press the button, named "Reset Filters" and voila - every user-defined
Autofilter was reset back to the "All" setting.

How can I replicate the same thing?

--

Dave Peterson