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.



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.



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

Drop-down Cell


back to top