autofilter on many columns
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
|