Multiple Dependent Drop Down List Excel. To copy the dependent drop down list let s do a regular copy pasting. In the data validation window define both validation criteria.
To make a multiple dependent drop down list in excel this is what you need to do. The only difference is the spill range reference you enter in the source box. The data validation tool in excel can be used to easily create lists.
There are three column headers that we want to use as the first drop down list.
To make a multiple dependent drop down list in excel this is what you need to do. This method works with all versions of excel 2019 2016 2013 2010 and earlier. Do a direct cell reference to the column headers a 4 c 4 as the source. Multiple dependent drop downs.
