Multiple Column Filter

  • Thread starter Thread starter Tom Moffatt
  • Start date Start date
T

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
 
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
 
Back
Top