I may have the terms wrong, but I require to build a series of drop down lists in various columns so each new cell presents me with a series of pre entered text only options to add into that cell. To complicate matters, the cell may require multiple entries, comma separated from the drop down list.

EG. a list containing 20 different entries, may require 4 of them in the one cell.

I have seen this functionality, but know not how to establish it in Excel 2008 for MAC. Can anyone assist please? Thank you!

Trebora