You can do this with programming. There's a sample file here that lets
you select multiple items from a data validation list:

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

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

WIDBIS wrote:
I want to have the ability to select multiple entries from a Valid List of
predefined entries. I would like each data item on a separate line within
the cell (much like doing an alt-Return.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html