How to Add Drop Down Values in Excel?

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

Suggested for You

Trending Today