Contextures

Excel Dependent Drop Down Videos

Make a drop down list that shows list of items, based on selection in another cell. Choose from first cell drop down, then choose from dependent drop down

These two videos show the steps for making a dependent drop down list in an Excel worksheet cell.

test the dependent drop down list

Dependent Drop Down Lists

In this short video, you'll see how to set up a main drop down list, with a dependent drop down list in the next column. The written steps are on the Dependent Data Validation page

Country and City Drop Downs

In this Dependent Drop Down video, you can see how to set up the lists for the data validation.

Then, see how to use the INDIRECT function in the data validation rule, to show the correct city list, depending on the selected country.

For written steps on setting up dependent drop down lists, go to the Dependent Data Validation page

More Video Training

Drop Down List (Basic) Videos

Data Entry Videos

VLOOKUP Videos

Pivot Table Videos

 

Last updated: July 5, 2022 3:09 PM