Excel drop down lists

swampydrill · 05-23-2009, 01:59 PM

I have been doing spreadsheets a little while now, i manage to do simple things like having drop down boxes from a list formed under the data/validation section, problem with this is that the drop down function is highlighted only when the mouse is over the cell. I have some spreadsheets that i have picked up around the place and they have drop down boxes shown all the time, these seem to reference information on another worksheet, when data is selected from the list it automatically puts data specific into another cell, ie if your list shows car manufacturers then once you select ford the next cell would have all the ford cards, i imagine that cell is formulated under the IF function, i'm not sure how to do this and would like some help, basic stuff like hyperlinking between worksheets is fine, just not sure how to get these drop down boxes as shown

**Glaswegian** · 05-24-2009, 10:43 AM

Hi

When using validation for a simple list like this, I usually colour the cell, just to highlight it.

The other item you are talking about is cascading comboboxes. There is an excellent discussion of this technique here

http://www.mrexcel.com/forum/showthread.php?p=126

05-23-2009, 01:59 PM	#1 (permalink)
swampydrill Registered User Join Date: May 2007 Posts: 44 OS: xp	Excel drop down lists I have been doing spreadsheets a little while now, i manage to do simple things like having drop down boxes from a list formed under the data/validation section, problem with this is that the drop down function is highlighted only when the mouse is over the cell. I have some spreadsheets that i have picked up around the place and they have drop down boxes shown all the time, these seem to reference information on another worksheet, when data is selected from the list it automatically puts data specific into another cell, ie if your list shows car manufacturers then once you select ford the next cell would have all the ford cards, i imagine that cell is formulated under the IF function, i'm not sure how to do this and would like some help, basic stuff like hyperlinking between worksheets is fine, just not sure how to get these drop down boxes as shown

05-24-2009, 10:43 AM	#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,482 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: Excel drop down lists Hi When using validation for a simple list like this, I usually colour the cell, just to highlight it. The other item you are talking about is cascading comboboxes. There is an excellent discussion of this technique here http://www.mrexcel.com/forum/showthread.php?p=126 __________________ 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