Or if you already have a list on the spreadsheet then use the range selector
to select it rather than type all the entries in.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Biff" wrote in message
...
Select the cell where you want the list to appear.
Goto the menu DataValidation
Allow: List
Source: type your selections here separated by a comma

Red,Green,Blue,Black,White

OK out

Biff

"Harry K" <Harry wrote in message
...
How do you create a simple drop down list that has 5 or 6 choices?