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

Hi,

Try using Advance Filter.

See attached for instructions

http://www.contextures.com/xladvfilter01.html


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561697

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

Dave Peterson wrote:
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

Thank you that is what I wanted