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

Chapter 3. Editing Worksheets > Copying Formulas

Copying Formulas

You copy a cell containing a formula the same way you copy any other cell in Excel: with the Copy and Paste commands, with the fill handle, or with the Fill command. These methods are discussed earlier in this chapter.

Generally speaking, Excel does not make an exact copy of a formula. Instead, it copies the formula based on the kinds of references used within it. If relative references are used, Excel changes them based on the location of the destination cell in relation to the source cell. You can see an example of this in Figures 43 and 44.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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