How do you autofilter multiple columns so that the unique names in each
column all appear in the filter dialouge(drop down) box?

I would perfer not to make a whole bunch of rows for one customer.

Customer Computer Interfaces (Merged title cell. 3 columns)
A EXTRON | CAL | RGB
B
C
D

You don't.

Each column has its own set of data values that will show in the AF list.

BTW.............your merged cells will give you lots of grief.

Use center across selection as an alternative.


Gord Dibben MS Excel MVP

On Fri, 30 May 2008 12:57:12 -0700, Tom Moffatt
wrote:

How do you autofilter multiple columns so that the unique names in each
column all appear in the filter dialouge(drop down) box?

I would perfer not to make a whole bunch of rows for one customer.

Customer Computer Interfaces (Merged title cell. 3 columns)
A EXTRON | CAL | RGB
B
C
D