Web select a cell in which you want the dropdown to appear (d3 in our case).
How to add drop down list in excel without source. My list is going to be made up of the top 30 places to visit. Select the cell where you want the first (main) drop down list. Web here are the steps to create a dependent / conditional drop down list in excel:
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. Select the data tools group from the data tab.
In the source box, either.