-
Select the cells that should have a drop-down list.
-
Validate data (Data tab > Data Validation)
-
On the Settings tab, under Allow, select List.
-
In the Source box, type the drop-down choices you want, and separate each with a comma. For example:
-
Click OK. Then select one of the cells. A drop-down arrow will appear with your choices.