I'd start by trying Data|Validation.

Debra Dalgleish has some nice notes at:
http://www.contextures.com/xlDataVal01.html

Cindy wrote:

How do I create a drop down list in Excel that allows the user to choice
multiple choices from the list in the drop down box?

Any help would be appreciated - Cindy

--

Dave Peterson