Not sure is possible -but need a drop down box

I'd like to have a drop down box in a cell in excel - so you would click on the drop down arrow and choose a name from the drop down. This name would then be displayed in that cell. The idea being that you can only chose a name from the list, and type nothing else in there.

Is this possible (without vba)?

Tks in advance
Caroline

Check here

http://www.contextures.com/xlDataVal01.html#DataVal01