How to Modify a Comma-Separated Drop-Down List

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

If you simply want to add or remove the list items of a drop-down, then follow these steps-

Step 1: Select the cell with the desired drop-down

Select the cell where the desired dropdown is present.

Select the desired cell

Note that if you wish to select multiple cells with the same drop-down, then use the Ctrl key(On Windows) or Cmd key(On Mac) while making a selection.

Or,

You can select a single drop-down and use the checkbox option to apply the changes to all the drop-downs with the same content. You will see this later in this section.

Step 2: Go to the Data tab and Select the Data Validation option

Go over to the data tab and select the data validation option from the data tools group.

select the data validation option

Step 3: Add or Remove the list items in the source box

In the dialog box that opens, you will see a box titled source. You can remove or add the list items in this box as desired.

Note that you can manually type new values as well as select the values from the spreadsheet. Also, in this section, we are adding a new item but you can delete any value present in the source box as desired.

Step 4: Tick the checkbox to apply changes to all similar drop-downs

Check the ‘apply these changes to all other cells with the same settings’ box in order to reflect the changes in the list items of all such dropdowns.

check the box

Step 5: Save changes

Click on ok to save the changes. You can see that now the drop-down list has 3 items.

result

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.