Select the source for the list from the allow option, select the list.

How to create a drop down list in excel based on another cell. Web in google sheets, open a spreadsheet. Select a cell, then select data > data validation. Open data validation dialogue box.

Click on the data validation. Web this will create the drop down 1. Web we need two excel drop down lists.

In source, type =my list name. Select the cell or cells where you want to create a dropdown list. Web i have three adjacent cells each has a drop down list, i want the second and third cells to pick a certain choice from their own drop down lists based on the choice made in the.

Select the entire data set (a1:b6 in this example). In the menu, under the components section, click “. Add code to remove and restore protection before the following.

The second excel drop down list will display the. In the source box, type:. Web select the topmost cell in which you want the primary dropdown list to appear (b3 in our case).

Create a data validation list go to the data. Web then, go to the data tab and click “data validation” in the data tools section of the ribbon. Select one or more cells where you want the picklist to appear.