autofilter on many columns

[inquirer]

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

[VBA Noob]

Hi,

Try using Advance Filter.

See attached for instructions

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

[Dave Peterson]

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

[inquirer]

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