multiple item entries from drop-down list

[sgoldstand]

How set up a drop-down list where multiple items can be selected

 

[Ardus Petus]

Insert a ListBox

HTH

 

[Miguel Zapico]

One way is using Data->Validation, and selecting list in the "Allow" field.
You have to choose the source of the data, that can be a range of cells or
whatever you type on the source textbox. Finally, ensure that "in-cell
dropdown" is checked.

Hope this helps,
Miguel.

 

[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 'Select Multiple Items from Dropdown List'