How do I make drop down lists in Excel?

[jdfloriano]

I am trying to make a drop down list in excell so that I can use it to accumulate data for end results. How do I create the drop down list?
This message was edited by jdfloriano on 2002-03-08 15:29

 

[gplhl]

list the data somwhere on the sheet that you want to use in the dropdown box

Goto Menu:

Data > Validation

Select Allow: List

choose your range or use a named range if you want the list on a different sheet.