Cell referencing types
Good question
👍
Let’s go step by step.
Cell referencing in MS Excel (or other spreadsheet software) means how a cell reference behaves
when you copy or move a formula to another location. There are two main types: absolute and
relative, and also a mixed reference.
1. Relative Cell Referencing
Definition: A relative reference changes automatically when you copy the formula to another cell.
Format: Example → =A1 + B1
Behavior:
If this formula is in cell C1 and you copy it to C2, it becomes =A2 + B2.
It adjusts row and column references relative to where the formula is moved.
✅
Used when you want the formula to change dynamically for each row/column.
2. Absolute Cell Referencing
Definition: An absolute reference does not change when copied to another location.
Format: Use $ sign → =$A$1 + $B$1
Behavior:
If this formula is in C1 and copied to C2, it still remains =$A$1 + $B$1.
Both row and column are fixed.
✅
Used when you want to always refer to a specific cell (e.g., a fixed tax rate, interest rate, or
constant value).
3. Mixed Cell Referencing
Definition: Only the row or the column is fixed, not both.
Formats:
=$A1 → Column A fixed, row changes when copied.
=A$1 → Row 1 fixed, column changes when copied.
✅
Used in formulas where either rows or columns must stay constant (e.g., multiplication tables).
Shortcut to Switch Between References
Select the cell reference in the formula bar and press F4.
Printed using ChatGPT to PDF, powered by PDFCrowd HTML to PDF API. 1/2
