Add a Dropdown Menu to an Excel Worksheet

First select the cell were you want to place the drop-down list. Then select the Validation command under the Data menu.

Validation

 

When the Data Validation window opens, select List from the Allow drop-down menu

Data Validation

 

In the Source field type a list of words separated with commas. (ex. Yes,No) Then click on OK.

Words

 

A drop-down menu will appear in the selected cell.

Drop-down Cell

 

back to top