First create a list of selections somewhere in the worksheet.
then select the cell you wish to have the drop down list.
then go to Data tab, Data Validation, select List
then click on the red arrow below the word 'source' and select your list
created previously. and click OK. you r done
