Multiple Column Filter

[Tom Moffatt]

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

 

[Gord Dibben]

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