| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I set up a drop down menu within a drop down menu?
I'm trying to set up a drop down list that once a major chategory is
selected, another drop down list is displayed with more detailed information. This is similar to the normal menus we see, i.e. clicking on "file" and then "new" displays another drop down menu with "Window Ctrl+N" and other options Thanks. |
|
#2
|
|||
|
|||
|
You can use Data Validation with dependent lists.
See Debra Dalgleish's site for method. http://www.contextures.on.ca/xlDataVal02.html Gord Dibben Excel MVP On Tue, 12 Apr 2005 09:51:04 -0700, Rob wrote: I'm trying to set up a drop down list that once a major chategory is selected, another drop down list is displayed with more detailed information. This is similar to the normal menus we see, i.e. clicking on "file" and then "new" displays another drop down menu with "Window Ctrl+N" and other options Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down menu | Excel Discussion (Misc queries) | |||
| help with drop down menu data | Excel Discussion (Misc queries) | |||
| add option to drop down menu | Excel Discussion (Misc queries) | |||
| Applying a formula to a drop menu choice | Excel Discussion (Misc queries) | |||
| How do I set up a drop down menu for a validation list? | Excel Worksheet Functions | |||
Hybrid Mode
