On the first sheet, select cell b1.

How to create drop down list in excel sheet. You can add or delete items from your drop. In the data validation dialogue box, within the settings tab, select list. Web select a cell where you want to create the drop down list.

This article explains how to create a drop. Web select the cell or cells where you want to create a dropdown list. Select the cells that you want to contain the lists.

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

In the menu, under the components section, click “ dropdowns. at the top, click. In source, type =my list name. Select a cell in which you want the dropdown.

On the ribbon, click the data tab, and click data validation.