• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. Using Range Names > Editing a Range Name's Coordinates

Editing a Range Name's Coordinates

If you want an existing name to refer to a different set of range coordinates, Excel offers a couple of ways to edit the name:

  • Move the range. When you do this, Excel moves the range name right along with it.

  • If you want to adjust the existing coordinates or associate the name with a completely different range, choose Insert, Name, Define to display the Define Name dialog box. In the Names in Workbook list, click the name you want to change, and then edit the range coordinates using the Refers To text box.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint