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

Chapter 10. Constructing Excel Formulas > Writing Multiple Copies of a Formula

Writing Multiple Copies of a Formula

Suppose you have a table similar to the one shown in Figure 10.8, 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 into several more cells. Another method creates multiple copies when you enter the formula.

Copying Formulas with AutoFill

When you copy a formula using AutoFill, 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 10.8), each copy of the formula will sum the values in the four cells to its left. This works because the formula uses relative references (page 270).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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