Hi Anthony

If you have applied Autofilter to your header row, there will be a
dropdown button on each cell in your header.
Make the selection on the first dropdown you wish to use, and the symbol
down arrow will change from black to blue.
Now use any other dropdown to further filter that filtered list. There
is no need to remove Autofilter first.

To show all data, choose DataFilterShow All which will remove all
filters, and show all data whilst retaining the Filter dropdowns.
--
Regards

Roger Govier


"anthony" wrote in message
...

i sometimes filter a column of data then when i want to filter
additional
columns of data i have to remove the filter then apply auto filter
again to
all the selected columns. is there a quick way of filtering additional
columns to an already filtered worksheet???