Select the cells where you want the drop-down list
Go to the Data tab
Click Data Validation
In the Allow box, choose List
In the Source box, type the values separated by commas
Or select a range of cells that contains the list values
Make sure the In-cell dropdown option is checked
Click OK
Use the drop-down arrow in the selected cells to choose a value
