Dave,

Thanks for the input. I guess this can't be done the way I was hoping. I
was hoping to be able to filter multiple times in the same worksheet in
different columns.

"Dave Peterson" wrote:

You get one range to filter per worksheet.

But that range can have multiple columns.

Turn of the autofilter (to start fresh)

Select your range to filter--(say A1:X9999)

Then apply data|Filter|autofilter.

You'll see dropdown arrows in the top row of that selected area of each cell.

Hickeym wrote:

Nick,

Maybe it is the version I am using, Excel 202 SP3, but I can only filter all
columns or none. It does not allow me to filter each column individually.
Any suggestions?

"Nick Hodge" wrote:

Just highlight the top row of the data and go to DataFilterAutofilter and
then filter each column you need using the drop down arrows at the top

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Hickeym" wrote in message
...
G'day,

I have been told that you can filter multiple columns. For example, if in
column A I have facilities listed, and in column B days are listed, you
can
filter seprately. Meaning that I should not have to list each facility
for
each day when I filter. I would like to have up to 15 different filters
in
the same worksheet if possible.

My questions is, "How do you do this...?"

Thanks




--

Dave Peterson