How do I make drop down lists in Excel?

jdfloriano · Mar 8th, 2002, 04:29 PM

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 · Mar 8th, 2002, 05:09 PM

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.

Mar 8th, 2002, 05:09 PM	#2
gplhl Board Regular Join Date: Feb 2002 Location: Chippenham, UK Posts: 136	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. __________________ Regards, Gary Hewitt-Long

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 04:29 PM	#1
jdfloriano New Member Join Date: Mar 2002 Location: California Posts: 1	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 ]