Select all other cells where you want the dependent list to appear (c4:c12) and press.

How to create nested drop-down list in excel. Web here are the steps to do this: Web how to create nested dropdown list with indirect excel function. Select the cell where you want the first (main) drop down list.

Web it’s easy and we’ll show you how. Simply click the arrow and select an option. Using some creative ways to configure data.

In the dialog, set allow to list. In addition to using the if function like the first way, we can also use excel's indirect function to create a. Web here are the steps to create a dependent drop down list in excel:

Select the cells that you want to contain the lists. Then, go to the data tab and click “data validation” in the data tools section of the ribbon. On the ribbon, click the data tab, and click data validation.