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

Chapter 2. Using Range Names > Using Names with the Range Operator

Using Names with the Range Operator

When using the range operator (:), you normally surround it with cell addresses. However, you also can use a range name on either side of the colon. In this case, the named range becomes a corner for the larger range. For example, Figure 2.12 shows a worksheet with the named range Rent that refers to B7:D7. Table 2.1 shows some sample ranges you can create with Rent as one corner.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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