Select cell b3 to make it the active cell.
How to add to drop down list in excel cell. Web to insert a drop down list in excel, you use the data validation feature. Select data validation to open the data validation dialog box. For this, press ctrl + f3 to open the new name dialog box.
Web the thing with this table is that on the drop down menu i can see the names, but if i choose a name instead of show the name on that cell n2 it shows the. Enter a name, for example choices, and press enter. Optionally, you can check the box to.
In source, type =my list name. The steps slightly vary depending on whether the source items are in a regular range,. On the data tab, in the data tools group, click data validation.
Web select a cell in which you want the dropdown to appear (d3 in our case). Select the range of cells, click copy to another. Web on the data tab, in the sort & filter group, click advanced.
On the first sheet, select cell b1. In the resulting dialog, make sure the my table has headers option is selected, and click ok. Let's say that the cell.
Web type the items for the drop down menu in separate cells. Web simply click any cell in the list and press ctrl + t. In the data validation dialog.