How To Change Drop Down List In Excel?

Select the cell (or cells) containing the drop-down list

Go to the Data tab

Click Data Validation

In the Settings tab, under Allow, confirm it is set to List

Edit the list in one of these ways:

Type new values in the Source box (comma-separated)

Select a different range by clicking the Select Range icon and choosing the new cells

If using a named range, update the named range to point to the new data

Click OK

Suggested for You

Trending Today