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

Copying Formulas

Copying labels and values in Excel is no big deal. You can use the Copy and Paste commands (discussed in Lesson 8, "Editing Worksheets") or you can use some of the Fill features discussed in Lesson 2, "Entering Data into the Worksheet." Copying or moving formulas, however, is a little trickier.

Suppose that you create the formula =D7*E7 and place it into cell F7, as shown in Figure 4.1. You have designed the formula to reference cells D7 and E7. However, Excel looks at these cell references a little differently. Excel sees cell D7 as the entry that is located two cells to the left of F7 (where the formula has been placed, in this example). It sees cell E7 as being the location that is one cell to the left of F7.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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