Multiple Dependent Drop Down List Excel. In data validation window select list and in source enter below formula and click ok. To create a multi level dependent drop down list please do with the following steps.
First create the first second and third drop down list data as below screenshot shown. However if you have many entries you may need to break the list into multiple dependent drop down lists. With dependent drop downs select an item from one excel drop down list and the next drop down only show the related items.
To add the dropdown list go to data data validation.
How to create a multiple dependent dropdown in excel making a dependent drop down lists in excel is easy. Do a direct cell reference to the column headers a 4 c 4 as the source. To copy the dependent drop down list let s do a regular copy pasting. First create the first second and third drop down list data as below screenshot shown.
