A more recent version of the Excel course is available here: Excel Course

Excel Course: Drop-Down List (Data Validation)

Select the cells in which you would like to put the drop-down list, then click on "Data Validation" on the "Data" tab.

select cells excel dropdown lists validation

In the first tab, choose "List" and select the data source (in this case, the list of cities).

data validation excel dropdown lists

When you click on any of the cells that were selected in the last step, the drop-down list will appear:

display dropdown lists excel validation