Goal: Understand copying formulas.
Relative (A1): The reference moves with the formula.
Absolute ($A$1): The reference is anchored and stays put.
Ready...
💻 Formula Structure
=A1
- Behavior: "Look 1 cell up/left relative to me."
- Result: If moved to B2, it looks at B1.
=$A$1
- Behavior: "Look exactly at cell A1, always."
- Symbol: The
$ acts as an anchor for the Column and/or Row.
-- Copying Formula...
Start: A2 Formula: =A1
End: C2 Formula: =C1
⚠️ Shortcut Tip
⌨️ F4 Key
Highlight a reference in the formula bar and press F4 to toggle between Relative A1, Absolute $A$1, and Mixed A$1 / $A1 modes.