The data validation window will appear.

How to add data to drop down list in excel. Select cell b3 to make it the active cell. Select data validation to open the data validation dialog box. Web select a cell in which you want the dropdown to appear (d3 in our case).

Select the data tools group from the data tab. Web select this range, then click in the name box on the left hand side of the formula bar. On the settings tab, select list from the allow box, and enter.

On the second sheet, create the following named ranges. I'll click in the source. In the data validation dialog.

Enter a name, for example choices, and press enter. In the source box, add new list. Now, i can either type the name or i can choose the name.

Web i'll go to the settings tab, i'll hit the drop down by allow, and i'll choose list. On the first sheet, select cell b1. Web click data > data validation (drop down) > data validation… the data validation dialog box opens.

The steps slightly vary depending on whether the source items are in a regular range,. Let's say that the cell. Web to insert a drop down list in excel, you use the data validation feature.