Create a drop down list in MS Excel cell

Select the cells or Column where you want to add the drop down list.

 Go to Data tab and click on Data Validation.

 

In dialog set List in Allow field. Now in Source field select the excel sheet and then cells (using cursor select the cell range) which have the drop down values.

Click OK. Now check the cell. It will have the drop down arrow and on clicking it will display the values.