Reverting all autofilter columns to "ALL".

[Guest]

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?

 

[Guest]

Try

Data - Filter - Show all

Does that help?

Mike

 

[Guest]

Duh, thanks Mike. Now I feel really stupid!

I can see I'll have to find far more complex problems next time!

 

[Guest]

Hi,

You can select the complete row, where the Autofilter command has been given
and then on the Data menu, point to Filter, and then click AutoFilter.

Challa Prabhu

 

[Dave Peterson]

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???).