How to Edit Defined Names in Excel: 2 Methods

Step 1 – Opening the Name Manager Window in Excel

  • Go to the Formulas tab.
  • Click on Name Manager from the Defined Names group.
  • The Name Manager window will open up.

Open Name Manager

Step 2 – Selecting the Defined Names That You Want to Edit in Excel

In the Name Manager window, all the defined names from any worksheet will be visible to us. Select a named range and move to edit the name, formula or range location.

  • Since we want to edit the defined name with the title “Nam”, choose the corresponding row in the following window.

Edit Name in Name Manager

Step 3 – Editing the Defined Names and Getting the Final Result

  • Click the Edit button.
  • A pop-up window will appear.

how to edit defined names in excel

  • Edit the defined name.

Edit Defined Name in Name Manager

  • Click the OK button.
  • The defined name will be changed.

Edit Defined Name in Name Manager

After closing the window, you’ll find the selected name replaced by the one newly defined.

Final Output

Download the Practice Workbook

Related Articles

<< Go Back to Name Manager | Excel Formulas | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sabrina Ayon
Sabrina Ayon

Sabrina Ayon, a Computer Science and Engineering graduate from United International University, has been an integral part of the ExcelDemy project for two years. She authored 150+ articles, excelling in instructing through visually engaging Excel tutorials. With a passion for teaching, Sabrina conducted sessions on Excel VBA, sharing her knowledge and insights with others. Currently holding the position of Project Manager for the ExcelDemy Visual Development Project, she oversees various aspects of the project, ensuring its smooth operation... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF