How To Edit The Drop Down List In Excel?

Select the cell with the drop-down list

Go to the Data tab

Click Data Validation

In the Settings tab, edit the Source box

Change the list items or the cell range

Click OK

If the list comes from a named range, go to Formulas

Click Name Manager

Select the named range

Edit the range or formula

Click Close

If the list comes from another sheet, update the source cells directly

If the list is based on a table, add or remove items in the table

Copy the edited validation to other cells if needed

Suggested for You

Trending Today