Relative vs Absolute vs Mixed References in Excel Explained!
Confused why Excel formulas change when you drag them? 🤯 Dragging formulas also shouldn't mess your data — but it often does 😬 Understand why Excel changes your Formula and how to control it.
In this video, I explain Relative, Absolute ($), and Mixed references using a simple sales dataset that actually makes sense.
✔ Relative references
✔ Absolute references ($A$1)
✔ Mixed references (A$1 / $A1)
A cell reference (combination of column letter and row number) in Excel is basically the cell address that identifies a cell in Excel. References are used in formulas to do calculations.
A cell's reference is locked by placing a dollar sign ($) before both the column letter and row number in the cell reference (e.g., $A$1).
You'll learn:
• What happens when you copy formulas
• When to use $ and why it matters
• Real-world examples (tax, commission, totals)
• The F4 key trick to switch references instantly