How to create a dropdown box?

bartendr · 06-30-2009, 01:21 PM

As the title says, how do I create a dropdown box in Excel?

**Glaswegian** · 06-30-2009, 02:02 PM

Hi

There are several ways, so a bit more info about what you are trying to achieve would help.

You can use the Control Toolbar, the Forms Toolbar or Data Validation....

bartendr · 07-01-2009, 01:12 AM

I am writing a liquor costing spreadsheet and would like a dropdown box to select between 3 sizes of liquor bottles(.750ml, 1.14L or 1.75L) to decide what to divide by(26, 40 or 60)in the breakdown of the bottle in oz.

bartendr · 07-01-2009, 01:52 AM

Ideally, the box will display the 3 three values and the in my last cell the value decides what to divide by.

Hope that this make sense, and Thank You for your help in advance.

**Glaswegian** · 07-01-2009, 02:35 PM

Hi again

See if the attached helps. I've used Data Validation for the drop down, with values taken from a Named range.

Then there is a formula in the breakdown cell. Note that you have to show values like 1.14L as 1140 to allow the formula to work.

Hopefully that will give you an a good idea and a start.

06-30-2009, 01:21 PM	#1 (permalink)
bartendr Registered User Join Date: Jun 2009 Posts: 7 OS: XP Pro, Vista Home Premium, Windows 7 RC	How to create a dropdown box? As the title says, how do I create a dropdown box in Excel?

06-30-2009, 02:02 PM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,382 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: How to create a dropdown box? Hi There are several ways, so a bit more info about what you are trying to achieve would help. You can use the Control Toolbar, the Forms Toolbar or Data Validation.... __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

07-01-2009, 01:12 AM	#3 (permalink)
bartendr Registered User Join Date: Jun 2009 Posts: 7 OS: XP Pro, Vista Home Premium, Windows 7 RC	Re: How to create a dropdown box? I am writing a liquor costing spreadsheet and would like a dropdown box to select between 3 sizes of liquor bottles(.750ml, 1.14L or 1.75L) to decide what to divide by(26, 40 or 60)in the breakdown of the bottle in oz.

07-01-2009, 01:52 AM	#4 (permalink)
bartendr Registered User Join Date: Jun 2009 Posts: 7 OS: XP Pro, Vista Home Premium, Windows 7 RC	Re: How to create a dropdown box? Ideally, the box will display the 3 three values and the in my last cell the value decides what to divide by. Hope that this make sense, and Thank You for your help in advance.