View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default autofilter on many columns

Remove the filter arrows (data|filter|autofilter)

Then select the whole range--last header row to the bottom row and include all
the columns you want filtered.

Then do data|Filter|autofilter.

inquirer wrote:

I have been given a spreadsheet which has autofilter on many columns. I
can only manage to put it on one column at a time.
Could someone tell me how to autofilter more than one column at a time.
Thanks
Chris


--

Dave Peterson