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

Hour 7. Restructuring and Editing Excel ... > Working with Worksheet Ranges

Working with Worksheet Ranges

A range is a group of cells. A selected group of cells composes a range. A range is always rectangular, and it might be a single cell, a row, a column, or several adjacent rows and columns. The cells within a range are always contiguous, but you can select multiple ranges at the same time. You can perform various operations on ranges, such as moving and copying. If, for example, you want to format a row of totals in some way, you first select the range that includes the totals and then apply the format to that range.

Figure 7.3 shows three ranges on a worksheet. You can describe a range by the cell reference of the upper-left cell of the range (the anchor point) and the cell reference of the lower-right cell of the range. As you can see from Figure 7.3, multiple-celled ranges are designated by listing the anchor point, followed by a colon (:), followed by the range's lower-right cell reference. Therefore, the range that begins at B3 and ends at F4 has the range of B3:F4. To select more than one range, in case you want to apply formatting to different areas of your worksheet at once, hold Ctrl while selecting the ranges.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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