Web select this range, then click in the name box on the left hand side of the formula bar.

How to add drop down list in excel microsoft 365. Web add a list box to your excel worksheet from which users can choose a value. Web with the cells selected, go up to the name box on the left side of the formula bar and enter a name for the cell group. This video focuses on how to use a cell range and named range.

Select shift cells down and click ok. Enter a name, for example choices, and press enter. Make sure the items are consecutive (no blank rows).

Make data entry easier by letting users choose a value from a combo box. Add code to remove and restore protection before the following. On the first sheet, select cell b1.

On the ribbon, click the data tab, and click data validation. Web on the data tab, in the sort & filter group, click advanced. On the ribbon, click the data tab, and click data validation.

On the second sheet, create the following named ranges. Select a cell in which you want the dropdown to appear (d3 in our case). In the dialog, set allow to.

Right click, and then click insert. In the source box, either update. Select the cells that you want to contain the lists.