How To Edit Drop Down List In Excel?

Select the cell or cells with the drop-down list

Go to the Data tab

Click Data Validation

In the Settings tab, check the Source box

Edit the list items directly if they are typed in the Source field

If the Source points to a range, edit the values in that source range

If the Source uses a named range, update the named range in Name Manager

Click OK to save the changes

Copy the updated validation to other cells if needed

Remove and recreate the drop-down if the source cannot be edited directly

Suggested for You

Trending Today