Click the Close button to close the Name Manager dialog box.Change the reference in the Refers to box and click OK.In the Name Manager dialog box, select the named range you want to update and click Edit.Or click the Formulas tab > Name Manager. Open the Name Manager dialog window by press the Ctrl + F3 keys together.Change the reference to the named range.Remember to arrange the items in the order you want them to appear in your drop-down list.

In the worksheet containing your named range, add or delete items.If you add or remove items, then you will also need to update the range reference in the Name Manager. If your picklist is based on a named range, the changes you make to the existing items will be reflected in all drop-down boxes based on this named range automatically. Click OK to save the changes and close the window.Ĭhange drop down list based on a named range.You can either edit the reference manually or select an appropriate range using the mouse. In the Data Validation window, change the range reference in the Source box.On the Data tab, click Data Validation.Select the cells containing your drop-down list.On your worksheet, modify the source list of items the way you want - change the items, add new or remove the existing ones.If you have created a drop-down list from a range of cells, you can edit it in this way:

Edit drop down menu based on a range of cells If you want to apply the changes to all the cells containing this particular dropdown, select the Apply these changes to all other cells with the same settings option.

Delete from all cells in the current sheet.

Quick way to add or remove drop down list items.

Modify a comma separated drop-down list.

By changing dropdown lists, you can ensure that your data is accurate, consistent, and up-to-date, making it easier to manage and analyze. For example, you may want to update the list with new options, insert the same picklist in other cells, or remove it from the sheet entirely. Once a drop-down list is created, you may need to change it for a variety of reasons. In a series of articles, we looked at different ways to create a drop-down menu in Excel to make data entry easier, faster and less prone to errors. We'll provide step-by-step instructions and screenshots to guide you through the process, whether you're a beginner or an experienced Excel user. In this article, we'll explore how to modify, copy and delete drop-down lists in Excel.

How do you create an excel table