Multiple Column Filter

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top