In the data validation dialogue box, within the settings tab, select list.

How to create drop down list in excel sheet. In the menu, under the components section, click “ dropdowns. at the top, click. In source, type =my list name. Web select the cell or cells where you want to create a dropdown list.

In the dialog, set allow to. In the source box, enter the formula that indirectly refers to table1's column named items. Excel for microsoft 365 excel for microsoft 365 for mac excel for the web more.

Select new rule, and then select format only cells that. On the ribbon, click the data tab, and click data validation. Select a cell in which you want the dropdown.

This article explains how to create a drop. Select the cells that you want to contain the lists. Select a cell, then select data > data validation.

On the second sheet, create the following named ranges.