MS-Excel / Functions and Formula

Editing Ranges Names

Editing names in Excel 2007 is simple with the new Name Manager. You can modify the name, scope, comment, or reference. Follow these steps to edit a name in the workbook:

  1. Click the Formulas tab on the Ribbon and then click the Name Manager button. Excel displays the Name Manager dialog box.
  2. In the list, select the name you want to change and then click the Edit button. Excel displays the Edit Name dialog box.
  3. Enter a new name, comment, reference, or scope for the name and then click OK.
  4. Select another name to edit or click Close to exit the dialog box.
[Previous] [Contents] [Next]

In this tutorial:


  1. Using Ranges names for formulas
  2. Advantages to Naming Cells and Ranges
  3. Introducing Ranges Names
  4. Defining Range Name
  5. Editing Ranges Names
  6. Managing Range Names
  7. Creating a Name from a Selection
  8. Creating a Dynamic Range
  9. Working with Range and Cell Names
  10. Using Names in Formulas
  11. Intersection Operators with Names
  12. Applying Names to Existing Formula
  13. Naming Constants and Formulas
  14. Excel Maintains Cell and Range Names