There are times when you do not want the cell reference to change when you copy or move cells to a new location. In such a case, you would need to enter the cell reference as an Absolute Reference. An absolute reference does not change when it is copied or moved to a new location – it always refers to the same cell address. Absolute cell references are preceded by a $ (dollar sign) in front of both the column reference and the cell reference.
As an example, suppose we have the following formula in cell D3:
=B3 * $C$3
If you copy this formula down to cell D4, you would have:
=B4 * $C$3
The first part of this formula (B4) is a relative cell reference, which automatically adjusted to its new location. The second part of the formula ($C$3) or the absolute cell reference did not change after being copied — it still refers to the original cell location of C3.
Similar Posts:
- None Found
