Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

Multiple Column Filter

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tom Moffatt - 30 May 2008 20:57 GMT
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 - 31 May 2008 01:01 GMT
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

>How do you autofilter multiple columns so that the unique names in each
>column all appear in the filter dialouge(drop down) box?
[quoted text clipped - 6 lines]
>C
>D
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.