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

Chapter 6. Function Fundamentals > Writing Multiple Copies of a Formula

Writing Multiple Copies of a Formula

Suppose you have a table similar to the one shown in Figure 6.12 (shown in the following section), and you need to add identical formulas at the end of each row. Instead of entering each formula individually, there are a couple of ways to create copies of your formula quickly. One method uses AutoFill to copy a formula to several more cells. Another method creates multiple copies when you enter the formula.

Copying Formulas with AutoFill

When you copy a formula, each formula adjusts its references automatically so that the calculation is correct. For example, when you write a formula that sums the values in the four cells to the left (like the formula in Figure 6.12), each copy of the formula will sum the values in the four cells to its left. This works because the formula uses relative references.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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