How to Edit Excel Drop Down List?

Select the cell with the drop-down list

Go to the Data tab

Click Data Validation

In the Settings tab, check the Source field

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

If the Source refers to a range, update the cells in that range

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

Click OK to save changes

Copy the updated drop-down to other cells if needed

Suggested for You

Trending Today