Web selected cells to add to drop down list.
How to add drop down list in excel spreadsheet. On the data tab, in the data tools group, click data validation. Change to the workbook that is to contain the dropdown and select the new worksheet (list) select the. The cleanest way to set something like this up is to create a new tab in excel where you can configure all of.
=unique (a2:a21) optionally, you can sort. Select the cell or cells where you want to create a dropdown list. In the source box, add new list.
Web you aim to add a dropdown list where each item appears just once. Web select a cell in which you want the dropdown to appear (d3 in our case). Web to insert a drop down list in excel, you use the data validation feature.
A data validation popup will appear after you click on data validation. Go to data and select. Web select and copy the source list range in the source workbook.
In the data validation dialog. Select the data you want to use and type a name for it in the name.