Excel > Excel 2007 Intermediate > Named Ranges

Managing Range Names

You can change the name of a range and the range that it references. Named ranges can also be deleted if no longer needed.

To edit a named range:

  1. Click the Formulas tab on the Ribbon
  2. Click the Name Manager button in the Defined Names group
  3. The Name Manager dialogue box appears

    Edit range names

  4. Select the named range and click the Edit button
  5. The Edit Name dialogue box appears

    Edit Name dialogue box

  6. Rename the range by editing the Name field or update the cell range in the Refers to field.
  7. Click Ok
  8. Close the Name Manager
  9. The named range is updated with your changes.

Click the Delete button in the Name Manager to remove an unwanted named range.

Follow us on

Facebook  Twitter  You Tube