-
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.
Create a simple drop-down list
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
