Selecting Cell Data from a drop down list without creating one

While working with large data sheet sometimes we need to update some column providing status of completion or some other value which has to be chosen from a limited set of values. Though Excel provides the auto fill functionality as we type in the cell however sometimes when we have values with slight differences and starting with many same initial characters it becomes annoying to types the whole text. Also sometimes we make typing errors as well in this process in terms of spellings or case of the letters.

I just discovered that Excel provides you drop down functionality to update the cell content with even creating a drop down list. This is how it works:

Sample Problem: I want to assign a city to every member in my sales staff. As the list go long I don't want to type same city names again and again, instead I would like to have a drop down from which I can pick a city name.


Solution:
STEP 1: Create a table with some sales people names in one column and start providing city names in next column.
STEP 2: After providing some names, now you want a drop down option to chose from. In the next cell where you need to provide a city name, just right click on the cell. Select the option 'Pick from Drop Down List'



STEP 3: A drop down list containing already populated city names will be shown. Select the desired option from the list.