Creating Complex Formulas
In earlier lessons, we saw how cell references in formulas automatically adjust to new locations when the formula is pasted into different cells.
Sometimes when you copy and paste a formula, you don't want one or more cell references to change. Absolute references solve this problem. Absolute cell references in a formula always refer to the same cell or cell range in a formula. If a formula is copied to a different location, the absolute reference remains the same.
An absolute reference is designated in the formula by the addition of a dollar sign ($). It can precede the column reference, the row reference, or both. Examples of absolute referencing include:
|$A$2||The column and the row do not change when copied.|
|A$2||The row does not change when copied.|
|$A2||The column does not change when copied.|