Web to create a drop down list in excel, you just need a series of options to choose from.

How to add drop down list in excel without source. Select the cell where you want the first (main) drop down list. On the data tab, in the data tools group, click data validation. Select the data you want to use and type a name for it in the name.

In the data validation dialog. Select the data tools group from the data tab. Web select a cell in which you want the dropdown to appear (d3 in our case).

In the source box, either.