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

Chapter 3. Editing Worksheets > Relative vs. Absolute Cell References

Relative vs. Absolute Cell References

There are two primary types of cell references:

  • A relative cell reference is the address of a cell relative to the cell the reference is in. For example, a reference to cell B1 in cell B3, tells Excel to look at the cell two cells above B3. Most of the references you use in Excel are relative references.

  • An absolute cell reference is the exact location of a cell. To indicate an absolute reference, enter a dollar sign ($) in front of the column letter(s) and row number of the reference. An absolute reference to cell B1, for example, would be written $B$1.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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