Reverting all autofilter columns to "ALL".

B

bollard

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?
 
B

bollard

Duh, thanks Mike. Now I feel really stupid!

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

challa prabhu

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
 
D

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