How to Edit Defined Names in Excel (Step-by-Step Guideline)

In Microsoft Excel, a defined name is a name that can be a single cell, range of cells, constant value, or formula. You can easily edit defined names by following the simple way below.


Download Practice Workbook

You can download the workbook and practice with it.


Steps to Edit Defined Names in Excel

Dataset Introduction

In the following picture, there are 3 separate columns with some random names, their genders, and ages. All of the sections have been defined with different names that can be found in the Name Box or Name Manager. Let’s say we want to edit the name of a cell range that contains all the names only.

Dataset Introduction


Step 1: Launch the Name Manager Window in Excel

The Name Manager tool is generally used to define, find, edit or delete a named range. Let’s see how we can use this tremendous tool to edit a defined name for a range.

  • First, go to the Formulas tab.
  • Next click on Name Manager from the Defined Names group.

The Name Manager window will open up.

Launch the Name Manager Window in Excel

Related Content: How to Delete Named Range Excel (3 Methods)


Step 2: Select 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. From this section, we have to 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.

Select the Defined Names That You Want to Edit in Excel

Related Content: How to Name a Range in Excel (5 Easy Tricks)


Step 3: Edit the Defined Names

  • Now click on the Edit button. This will open a pop-up window.

Edit the Defined Names

  • Then, Edit the defined name.

Edit the Defined Names

  • Click on the OK button. This will change the defined name.

Related Content: How to Edit Named Range in Excel


Final Output

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

Final Output


Conclusion

By following the steps, you can easily edit the defined names in your Excel workbook. Hope this will help you! If you have any questions, suggestions or feedback please let us know in the comment section. Or you can have a glance at our other articles in the ExcelDemy.com blog!


Related Articles

Sabrina Ayon

Sabrina Ayon

Hi there! This is Sabrina Ayon. I'm really excited to welcome you to my profile. Currently, I'm working in SOFTEKO as a Excel and VBA Content Developer. I'm a student of United International University and my program is Computer Science and Engineering. I love working with computers and solving problems. I’ve always been interested in research and development. So, here I will be posting articles related to Microsoft Excel. Hoped this may help you. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo