You can add an icon to your favorite toolbar (xl2003 and below):

Tools|Customize|Commands tab|Data category

Drag the "show all" button to your favorite toolbar (and the autofilter button,
too???).

bollard wrote:

Hi

We have a number of Excel spreadsheets with Autofilters on all columns.

Once you've slected the information you want, it's a total pain to have to
go through every coulmn reverting each Autofilter to "ALL".

Is there an easy way to make all columns revert to "ALL" after you'ved used
the feature?

--

Dave Peterson