How To Insert Dropdown In Excel?

Select the cells where you want the dropdown

Go to the Data tab

Click Data Validation

In the Allow box, choose List

In the Source box, enter the items separated by commas or select the range containing the list

Make sure In-cell dropdown is checked

Click OK

Suggested for You

Trending Today