You cannot filter just within a column.
Rows are contiguous and if a column is filtered, then all data in the
row selected is either displayed or hidden dependent upon your
criterion, not just the individual cells within the column upon which
you have placed the filter.

--
Regards

Roger Govier


"TJ" wrote in message
...
I don't think I'm asking my question correctly. I only want certain
columns
filtered, not all. And these columns are not consecutive, they are
random in
order. I'm not even sure this is possible.
--
TJ


"Roger Govier" wrote:

Hi

Mark the complete range of data.
DataFilterAutofilter
You will have dropdowns on all columns (including any blank columns)
Select the first column you wish to filter by, chose what you want
via
the dropdown. You will now have a filtered list.
Select any OTHER dropdown, and make a further selection. and the list
will be further filtered.

repeat as many times as you wish.

--
Regards

Roger Govier


"TJ" wrote in message
...
I tried that, but the second column I pick, auto-filter just toggles
the
filter off for the first column.
--
TJ


"CLR" wrote:

Using AutoFilter......just filter on the columns one at a
time.......

Vaya con Dios,
Chuck, CABGx3



"TJ" wrote:

I am helping a friend with this and I believe he is using Excel
2000.

I need to filter on multiple, non-concurrent columns. When I
select the
multiple columns I am told it has to be in a range. Is there
any
way around
this?

--
TJ