Create Multilevel Dropdown List in Excel
How to make Multilevel Dropdown List in Excel very easy and these dependent dropdown lists in excel can be created in under 3 minutes.
In this example, I have created a 3 level dependent dropdown list for Country, State, City. Level 1 is selecting a COUNTRY from the Dropdown list
Level 2 is selecting the STATE based on the COUNTRY
Level 3 is selecting the CITY based on the STATE
I have used Dropdown list Function in Excel with the INDIRECT to achieve this.
I have also used NAMED RANGES in Excel to make it really simple to Create dependent drop down lists in Excel to select items based on another list selection.
The shortcuts that I have used in this video are
1 Create a Dropdown list – ALT+D+L
2 Use Named Ranges – F3
3 Create many Named Ranges at once – CTRL+SHIFT+F3
You may also want to see
How to Create Searchable Dropdown List in Excel – https://www.youtube.com/watch?v=Jr34riKGveg
To watch more videos and download the files visit http://www.myelesson.org
To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788
Connect with us on Facebook – https://www.facebook.com/excelmadeasy/
Connect with us on Twitter – https://twitter.com/Excelmadeasy