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

Copying Formulas

When you copy a formula, the formula is adjusted to fit the location of the cell to which it is copied. For example, if you copy the formula =C2+C3 from cell C4 to cell D4, the formula is adjusted for column D: it becomes =D2+D3. This allows you to copy similar formulas (such as the totals for a range of sales items) into a range of cells.

You can copy formulas using the Copy and Paste buttons (see Lesson 6), but there's a faster way.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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