PDA

View Full Version : Solved: How to create a drop down list?



mike31z
04-22-2007, 02:32 PM
I done this before (2-3 Years ago) but I forgot how today.

I want to create a drop down list in cell A5 thru A50 that will allow me to choose from a list of approx 75 name whose names are located in cell A128 thru A211.
On the right end of the active cell there is a down arrow and if clicked the list appears below to allow the use to select any name.
I hope the info I provided is enough.
I am using Excell 2000 9.0 xxxxx
Mike in Wisconsin

johnske
04-22-2007, 02:59 PM
http://www.contextures.com/xlDataVal01.html

mike31z
04-22-2007, 03:06 PM
Thank You If I didn't it today to move on with my little project I would have kept looking for a couple of days.

Thanks Much I will Post an answer when I review the training link you provided.

mike31z
04-22-2007, 03:34 PM
Here is what I relearned.
Step 1. Highlight the cell you want the Drop Down list in.
Step 2. Click on DATA then Valadation
Step 3. In the Popup window titled "DATA VALADATION"
Step 4. Under the "allow" option change the value to List.
Step 5. A new option appears titled Source click on the icon in the right side of that block.
Step 6. Highlight the list that is located on this worksheet. then your list works.

Ther are other thing you can do with Data Valadition If you need addition instruction view this web sit brovided by "johnske" above.

http://www.contextures.com/xlDataVal01.html#Name

Thank you all very much

mike in wisconsin