| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down options
i want to have two drop down lists in my spreadsheet.
When i select an option on the first drop down list i want the second drop down list options to change accordingly. e.g. if i choose breakfast on the first drop down i want "cereal", "toast" etc to appear as options on the second drop down list, but if i select "dinner" on the first i want the second to offer "steak", "salad" etc. How do i do this? thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down options
There are instructions here for creating dependent data validation lists:
http://www.contextures.com/xlDataVal02.html mt wrote: i want to have two drop down lists in my spreadsheet. When i select an option on the first drop down list i want the second drop down list options to change accordingly. e.g. if i choose breakfast on the first drop down i want "cereal", "toast" etc to appear as options on the second drop down list, but if i select "dinner" on the first i want the second to offer "steak", "salad" etc. How do i do this? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Drop-down options | Excel Discussion (Misc queries) | |||
| how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
| Modifying drop-down box options and formats | Excel Discussion (Misc queries) | |||
| Drop-down menu options | Excel Discussion (Misc queries) | |||
| How do I set up a drop down box in Excel with a list of options f. | Excel Discussion (Misc queries) | |||
Linear Mode
