I'll click in the source.

How to add data to drop down list in excel. In the source box, add new list. Select cell b3 to make it the active cell. Select data validation to open the data validation dialog box.

Select the data tools group from the data tab. On the settings tab, select list from the allow box, and enter. For example, if you have.

Web click data > data validation (drop down) > data validation… the data validation dialog box opens. This article explains how to create a drop. On the second sheet, create the following named ranges.

Web to insert a drop down list in excel, you use the data validation feature. In source, type =my list name. Let's say that the cell.

Web select a cell in which you want the dropdown to appear (d3 in our case). In the data validation dialog. Web with the two named formulas in place, you set up data validation in the usual way ( data tab > data validation ).

The data validation window will appear. Enter a name, for example choices, and press enter. Now, i can either type the name or i can choose the name.