MUILT LEVEL DATA VALIDATION
Excel Video: How to create a multi-level dependent drop down list
In Excel, you may create a dependent drop down list quickly and easily, but, have you ever tried to create multi-level dependent drop down list as following video shown?
This post, I will talk about how to create a multi-level dependent drop down list in Excel.
To create a multi-level dependent drop down list, please do with the following steps:
Firstly, create the data for the multi-level dependent drop down list.
1. First, create the first, second and third drop down list
Secondly, create range names for each drop down list values.
2. Then, select the first drop down list values (excluding the header cell), and then give a range name for them in the Name box which besides the formula bar
3. And then, select the second drop down list data and then click Formulas, Create from Selection
Click OK, And the range names have been created for each second drop down data at once, then, you should create range names for the third drop down list values, go on clicking Formulas, Create from Selection, in the Create Names from Selection dialog box, check only Top row option
4. Then, click OK button, the third level drop down list values have been defined range names.
Thirdly, create Data Validation drop down list.
5. And then, click a cell where you want to put the first dependent drop down list, for example, I will select cell A3, then, click Data - Data Validation - Data Validation
Watch the video to learn more...
Do you want to learn Data Analytics using Excel, Power BI and SQL?
Join our October Cohort. It is 5 weeks program (Weekend classes)
The training starts on Saturday 1st of October, 2022
Call us on 08062468296 to register
Choose Lead-Leap Data Analytics School
Watch video MUILT LEVEL DATA VALIDATION online without registration, duration hours minute second in high quality. This video was added by user Akerele Oluwasogo (Mr Excel) 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 92 once and liked it 0 people.