Enter a name, for example choices, and press enter.

How to add data to drop down list in excel. In source, type =my list name. Web select this range, then click in the name box on the left hand side of the formula bar. Web select a cell in which you want the dropdown to appear (d3 in our case).

Web click data > data validation (drop down) > data validation… the data validation dialog box opens. On the second sheet, create the following named ranges. On the settings tab, select list from the allow box, and enter.

Select data validation to open the data validation dialog box. On the data tab, in the data tools group, click data validation. The steps slightly vary depending on whether the source items are in a regular range,.

The data validation window will appear. Web with the two named formulas in place, you set up data validation in the usual way ( data tab > data validation ). In the source box, add new list.

Select a cell, then select data > data validation. Select cell b3 to make it the active cell. Now, i can either type the name or i can choose the name.

For example, if you have. Let's say that the cell. Select the data tools group from the data tab.