FAQ - Excel: What are Absolute and Relative Cell References?

Problem:

Microsoft Excel: What are Absolute and Relative Cell References?

Solution:

Absolute means that the reference in a formula will always look for the value in a specific cell, even if you copy the cell to a different location. The format for an absolute reference is $A$1 (referring to cell A1).

Relative references are in the format A1 and if copied to a different cell the cell reference changes relative to the new location. For example, if the formula specifies A1 and is copied to a new location two rows down the new formula would specify A3.

Did this document solve or help you with your problem?

Yes   No  

Category: Software     Platform: All Windows
Document #: 410     Author: Elizabeth Golden    
Last Modified by: Cynthia Senicka on 03/05/2008