• 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 Intersection Operator

Using Names with the Intersection Operator

If you've named the ranges on your worksheet, the intersection operator can make things much easier to read because you can refer to individual cells by using the names of the cell's row and column. For example, in Figure 2.13, the range B5:B12 is named January and the range B7:D7 is named Rent. This means that you can refer to cell B7 as January Rent (see cell H11).

Figure 2.13. After you name ranges, you can combine row and column headings to create intersecting names for individual cells.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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