Now when you select a genre, the drop down list for the title selection will change depending on the genre.
On the Excel Ribbon, click the Data tab Click the Data Validation command From the Allow drop down, select List Click in the Source box, and press the F3 key, to see a list of the names in the workbook Click on the PrimaryList name, and click OK. This means the drop down list will depend on some other value in the workbook and the available values in the drop down menu will change depending on this value. Next, select the cell(s) where you want the drop down list to appear. You will get the dialogue box which will show validation criteria.
In this post we’re going to learn how to create a conditional drop down list in a cell. Excel Drop Down List Example 1 Go to the Data tab.