Excel Drop down

[M8KWR]

How to you do a drop down/combo box in an excel cell?

I've seen this done, but do not know how to do it!!

Many thanks in advance

 

[gizmo1973]

Select range for drop down, Data, Validation, Pick from list (create a list first)
voila!

Regards, Phil.

M.U.F.C. Show your true support here, it's still not too late:

http://shareholdersunited.org/join.php?ref=125059000

"Shares not Shirts

 

[AnotherHiggins]

For a dropdown box in the spreadsheet, have a look at Data > Validation. The trick that Excel's help doesn't mention is how to have the custom list appear on a different sheet. To accomplish this, used a Named Range.

Example:
On Sheet2, write several names or whatever an A1:A10. Select Column A, go to Insert > Names > Define Give the list a name, let's say MyNames, then click OK. Now on Sheet1, select the range where you want dropdowns, go to Data > Validation, change the Allow box to List, then type in MyNames.

That's it. Hope that helps.

[tt]_____
[blue]-John[/blue]
[/tt][red]"I'm against picketing, but I don't know how to show it."[/red]
-Mitch Hedberg

Help us help you. Please read FAQ181-2886 before posting.

 

[M8KWR]

Unsure if i'm missing the point, or if i did not explain myself.

If i had a list of suppliers on sheet2, then on sheet1 i have a column for Suppliers, then each time you enter the supplier coloumn under the header you have a drop down list that looks at sheet2.

I am also using Excel 97....

many thanks

 

[gizmo1973]

On sheet 1 for the supplier slect the range that you want the drop dwon in, then click
Data
then
Validaiton
then
Change the selction criteria from Allow: Any Value to list
then click on the blue and red button and go to your sheet one list of suppliers and selct the range of suppliers.
Then click OK

Regards, Phil.

M.U.F.C. Show your true support here, it's still not too late:

http://shareholdersunited.org/join.php?ref=125059000

"Shares not Shirts

 

[gizmo1973]

Sorry forget to say I'm on XL 2000 but I think 97 was the same

Regards, Phil.

M.U.F.C. Show your true support here, it's still not too late:

http://shareholdersunited.org/join.php?ref=125059000

"Shares not Shirts

 

[xlbo]

yup - it is available in '97

Rgds, Geoff

Well, he's kind of had it in for DPlank ever since he accidentally ran over his dog. Actually, replace "accidentally" with "repeatedly," and replace "dog" with "son."

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

If your LIST is on another sheet from the Validation, the ONLY way that you can reference that list is to NAME the list and use the NAME as the reference.

How can I rename a table as it changes size faq68-1331

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[M8KWR]

brill thanks eveyone