Forum Discussion
How To Create Multi Level Dependent Drop Down List In Excel?
Hello Excel Community,
I am looking to create a multi level drop down menu.
Below is an example of what i am looking to create.
https://www.extendoffice.com/documents/excel/5852-excel-multiple-level-drop-down-list.html used a custom add-in. I would like to see if this can be done natively.
In addition to what is shown below, i am also interested in having the lower tier drop down to have default value selected.
e.g. If the top tier is selected, then the lower tiers would auto populate with default values.
Attached excel file is just an example list of choices for a drop down menu
Thank you,
3 Replies
- Thanks! The link was very helpful.
Is there a way to make lower tier drop down menus with a first value of the options?
In my GIF example, if America is selected from the continents, then Canada would be auto-populated.That would require VBA. Would that be acceptable?
