View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bollard bollard is offline
external usenet poster
 
Posts: 65
Default Reverting all autofilter columns to "ALL".

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?