• 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. This is called relative addressing, because the addresses of the cells in the original formula are adjusted to reflect their new column or row. For example, if you copy the formula =C2+C3 from cell C4 to cell D4 (a different column), the formula is adjusted to column D: it becomes =D2+D3. This allows you to copy a formula (such as one that totals monthly expenses for January) to a range of cells (such as the February, March, and April columns).

You can copy formulas using the Copy and Paste buttons (see Lesson 12), 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