drop down list
 

How do you create a simple drop down list that has 5 or 6 choices?

drop down list
 

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?

drop down list
 

Check out this site of Debra Dalgleish.

Scroll down to the "D's", and review all the pages regarding "Data
Validation".

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Harry K" <Harry wrote in message
...
How do you create a simple drop down list that has 5 or 6 choices?

drop down list
 

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?