My list is going to be made up of the top 30 places to visit.
How to add drop down list in excel without source. Select the cell where you want the first (main) drop down list. Web select a cell in which you want the dropdown to appear (d3 in our case). Then, customize the list using the data validation options.
In the data validation dialog. Select the data tools group from the data tab. On the data tab, in the data tools group, click data validation.
In the source box, either.