Duh, thanks Mike. Now I feel really stupid!

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

"Mike" wrote:

Try

Data - Filter - Show all

Does that help?

Mike

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