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 named range-
Step 1: Select the cell with the desired dropdown
Select the cell with the drop-down that you want to edit.
Step 2: Choose the name manager option
Go over to the Formulas tab and click on the Name Manager option from the Defined Names drop-down.
Step 3: Select the desired named range
In the dialog box that opens, you will see the list of all name ranges. Select the named range you wish to edit.
In other words, you have to select the named range that forms the dropdown that you wish to edit.
Step 4: Make changes
A new dialog box appears. Add or remove the cells as needed in the ‘Refers to’ box.
Step 5: Save the changes
Click ok followed by the close option to save the changes.
Step 6: Click on the Close Tab
Note that the changes made will be reflected in all the drop-downs that are based on a given named range.
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.
Contact Us