There are two main ways to create a dropdown in Microsoft Excel. One is not good for a list of data, the other is quick, easy and will allow you to have several in one spread sheet. An entire column can be converted to be a dropdown.

This is called Data Validation. Within Data Validation are several options the one that creates a dropdown is called List. To create this list you will need the data that populates the list, so somewhere on the spread sheet you might have a few cells with the options for the dropdown, if they are not on the same sheet you will need to name the range otherwise they have to be on the same sheet as the data validation is used.

The dropdown will only appear when the cell is selected, you can change the setting on the third tab for data validation. There are three options and they set how restrictive the dropdown will be, for example if you select Stop you will not be able to select anything except what is in the list.

If you want to be able to type in other values then you can change the setting from Stop to Information.