Excel > Excel 2003 Intermediate > Named Ranges

Managing Range Names

You can change the name of a range and the range referenced by a named range if a mistake has been made, or it needs updating. Named ranges can also be deleted if no longer needed.

  1. Click Insert > Name > Define
  2. The Defined Names dialogue box appears

    Opening Defined Names dialogue box
  3. Select the named range
  4. Update its cell range in the Refers to field
  5. Manage range names

  6. Click Ok

Click the Delete button to remove an unwanted named range

Follow us on

Facebook  Twitter  You Tube