How To Add Drop Down Options 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 items separated by commas, or select the range containing the list items

Make sure the In-cell dropdown option is checked

Click OK

To edit the list later, return to Data Validation and change the Source

To remove the drop-down, open Data Validation and click Clear All or change the validation settings

Suggested for You

Trending Today