How do I enable multiple selection dropdowns?

[Kimberly]

I am creating dropdowns from lists and would like to enable multiple
selections from a list for a cell. Is that possible?

 

[Chip Pearson]

You can't do it with a drop down. You might be able to get by with a
ListBox, which does support multiple selections.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Debra Dalgleish]

You can do this with data validation and programming. There's a sample
file here:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0017 - Select Multiple Items from
Dropdown List'