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

Hi

I have a number of Excel worksheets with Autofilters on each column.

Once you've extracted the informaiton you need, it's a pain having to go to
each columna nd check that you've reverted to "ALL" in each column.

Is there an easy way to achieve this, such as with one click to revert every
column simultaneously?