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

Chapter 2. Using Range Names > Changing a Range Name

Changing a Range Name

If you need to change the name of one or more ranges, you can use one of two methods:

  • If you've changed some row or column labels, just redefine the range names based on the new text, and delete the old names (as described in the next section).

  • Choose Insert, Name, Define. Click the name you want to change in the Names in Workbook list, make your changes in the Refers To text box, and click Add.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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