Multiple Dependent Drop Down List Excel. Under allow select list. To copy the dependent drop down list let s do a regular copy pasting.
To copy the primary drop down list select the cell containing it b3 and drag the fill handle a small square at the lower right hand corner of the cell through as many cells as needed. In the data validation window define both validation criteria. Select the cell where you want to add size drop down list.
This method works with all versions of excel 2019 2016 2013 2010 and earlier.
For example choose canada in column c and only see canadian provinces in column d s drop down. The main dropdown list is created with exact the same steps as in the previous example please see steps 1 and 2 above. Under allow select list. The only difference is the spill range reference you enter in the source box.
