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

Chapter 6. Automating Calculations with ... > Copying and Pasting Formulas

Copying and Pasting Formulas

You can copy and paste formulas just as easily as you copy and paste data entries. When you paste a formula, however, Excel adjusts the cell references in the formula to reflect their new positions in the worksheet. Figure 6.3 illustrates how Excel treats cell references when you paste a formula. Cell B8 contains the formula =B4+B5+B6+B7, which determines the total sales revenue for the Northern District. If you copy that formula to cell C8 (to determine the total sales revenue for the Southern District), Excel automatically changes the formula to =C4+C5+C6+C7. This is usually what you want Excel to do when you copy or move formulas.

Figure 6.3. Excel adjusts cell references when you copy formulas.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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