How to Modify a Comma-Separated Drop-Down List
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.
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.
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.
Step 5: Save changes
Click on ok to save the changes. You can see that now the drop-down list has 3 items.
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.