Google Sheets Drop Down From Another Sheet - 3) in the dialog box, click the grid image in the criteria input box. Web click on the data menu and select data validation. 2) right click on the cell and select data validation. In the “list of items” field, enter the range of cells that contains the items you want to appear in the dropdown list. Web in google sheets, open a spreadsheet. In the criteria section, select “list from a range” from the dropdown menu. 1) select the cell you want the dropdown in. Web to specifically add cells from another sheet to a dropdown: For example, if your list is in cells a1, you would enter “a1” in this field. If a selected cell includes an existing dropdown, other cell values are appended to.
In the criteria section, select “list from a range” from the dropdown menu. 2) right click on the cell and select data validation. Select the cell or cells with existing data. Web in google sheets, open a spreadsheet. For example, if your list is in cells a1, you would enter “a1” in this field. If a selected cell includes an existing dropdown, other cell values are appended to. In the “list of items” field, enter the range of cells that contains the items you want to appear in the dropdown list. Web to specifically add cells from another sheet to a dropdown: 3) in the dialog box, click the grid image in the criteria input box. Web click on the data menu and select data validation. 1) select the cell you want the dropdown in.