The filtering on column A hides the rows in B also so no can do as you wish.

If using 2003 or newer you could turn column A and column B into two
distinct "lists" unser DataListCreate List.

These can be filtered independently.


Gord Dibben MS Excel MVP

On Wed, 24 Sep 2008 07:55:02 -0700, Youssef B. <Youssef
wrote:

Hi,
I was wondering if anyone had any advice on filtering columns independently.
I have the following data:

A B

1 3
2 8
3 8
4 6
5 9

Basically, I would like to filter column A independently of column B.
I'd like to to filter column A to show only A4 (for example) and still be
able to filter column B by any criteria I like. Normally, If I filter column
A by A4, Excel only shows the value from B4 in the B column.
Any suggestions would be appreciated.