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

Chapter 4. Manipulating Formulas and Und... > Using Relative and Absolute Cell Add...

Using Relative and Absolute Cell Addresses

As mentioned at the beginning of this lesson, when you copy a formula from one place in the worksheet to another, Excel adjusts the cell references in the formulas relative to their new positions in the worksheet. There might be occasions when you don't want Excel to change the reference related to a particular cell that appears in a formula (or in an Excel function, which is discussed in Lesson 5, “Performing Calculations with Functions”).

Absolute Versus Relative An absolute reference is a cell reference in a formula that does not change when copied to a new location; you designate it as absolute. A relative reference is a cell reference in a formula that is adjusted when the formula is copied.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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