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

Using Ranges

One way you can organize and work with Excel data is to use ranges. A range is a rectangular group of related cells (or even a single cell) that you can connect in a column, a row, a combination of columns and rows, or even an entire worksheet.

You can use ranges for a variety of worksheet tasks. You can select a range and use it to format a group of cells with one simple step. You can also use a range to print only a selected group of cells. Ranges are particularly handy when you use them with formulas. Instead of referring to each cell reference that you want to include in a formula, you can specify a range of cells. Cell ranges also can be given distinct names to help you identify their contents.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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