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

Copying Formulas

Now that you’ve created a formula, there’s no reason to type it repeatedly for subsequent cells. Let Excel copy the formula for you! When you copy a formula, the formula changes depending on where you put it. It is said, therefore, to be relative—relative to the position of the original formula.

Copying Using the Fill Feature

If you’re going to copy a formula to a surrounding cell, you can use the Fill method. You first learned about the Fill command in Chapter 3, “Editing a Worksheet.”


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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