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

Chapter 1. Getting the Most Out of Ranges > Using the Range Operator

Using the Range Operator

The range operator is just the familiar colon (:) that you've been using all along. All you do is insert a colon between two references, and Excel creates a range (for example, A1:C5).

Until now, though, you've probably been creating your ranges by using the reference on the left side of the colon to define the upper-left corner of the range, and the reference on the right side of the colon to define the lower-right corner. However, there are other ways to create ranges with the range operator. Table 1.4 points out a few of them.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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