How to Edit Drop-Down Menu Based on a Range of Cells

How to Modify a Comma-Separated Drop-Down List

How to Change Drop-Down List Based on a Named Range

Follow these steps to edit a drop-down list that is based on a cell range-

Step 1: Select the cells with the desired drop-down list

Select the cells containing the drop-down list. In order to select multiple cells, use the Ctrl key(On Windows) or Cmd key(On Mac) while making a selection.

select the cell with a dropdown

Step 2: Select the data validation option

Go over to the Data tab and select the Data Validation option from the Data Tools tab.

select data validation

Step 3: Make changes in the source box

In the dialog box that opens, change the range in the source box. You can now exclude or include the desired items.

edit the list

Step 4: Save changes

Click ok to save the changes.

click ok

How to Edit, Copy and Delete Drop Down List in Excel

A drop-down list allows us to make our Excel sheet more dynamic and intelligent by allowing the users to choose from a list of predefined options. Not only does this make data entry fast but it also helps in restricting the data that can be added to some cells.

Naturally, once you have created a drop-down list, you might also need to edit, copy, or delete it at some point in time. And this is exactly what we are going to learn about in this article. So let us look at the different ways in which you can edit, copy, and delete a drop-down list in Excel but first, check out how to create a dropdown in Excel if you don’t already know.