How To Create A Dropdown List In Excel?

Select the cell or range where you want the dropdown list

Go to the Data tab

Click Data Validation

In the Settings tab, choose List from the Allow dropdown

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

Make sure the In-cell dropdown box is checked

Click OK

Click the dropdown arrow in the cell to use the list

Suggested for You

Trending Today