drop down form

[grizzly6969]

How do you create a drop down form in an excel worksheet

 

[John]

Hi
One easy way is : Data>Validation, if you already have a list, click in one cell
and goto
Data>Validation select List, highlight your list and you got a dropdown list '
HTH
John

 

[Chip Pearson]

Put the items that should appear in the list in some range on the
worksheet, say A1:A10. Then select the cell where you want the drop
down to appear. Go to the Data menu and choose Validation. There,
select "List" in the Allow list and enter =A1:A10 as the source.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[grizzly6969]

Thanks John
--
grizz

Hi
One easy way is : Data>Validation, if you already have a list, click in one cell
and goto
Data>Validation select List, highlight your list and you got a dropdown list '
HTH
John

 

[L. Howard Kittle]

You have three solutions, but you can also just put your list in the Data
Val wizard Source box, red,blue,green etc.(separated with a coma) With
large lists selection of the list range is pretty easy and painless.

You may run into a case where your huge list is on another worksheet. If
this is the case, go to that sheet select the list and in the name box name
it something appropriate to the list, MyList, AllGoodFoods, StateCapitals or
such. Now in the Source box type in =MyList, or whichever list you named,
hit OK.

HTH
Regards,
Howard