Freedom | Excel Boss

One of the biggest mindset shifts in Excel is understanding "Cell References" Most people learn formulas like: =SUM(B2:B10) …but don’t really understand *why* formulas behave differently when copied across rows and columns. That’s where Cell References come in. There are 3 major types: 📌 Relative Reference → `A1` 📌 Absolute Reference → `$A$1` 📌 Mixed Reference → `A$1` or `$A1` And understanding when to use each one changes everything. Relative Reference (`A1`) This changes automatically when copied. Example: If you copy: ```excel =A1+B1 ``` down one row, it becomes: ```excel =A2+B2 ``` Excel assumes you want the formula to move with the data. Best used for: ✔ Row-by-row calculations ✔ Totals ✔ Repetitive calculations across datasets Absolute Reference (`$A$1`) This locks both the row and the column. No matter where the formula is copied, the reference stays fixed. Example: ```excel =A2*$F$1 ``` If `$F$1` contains a tax rate or exchange rate, every calculation will always reference that exact cell. Best used for: ✔ Fixed rates ✔ Constants ✔ Parameters ✔ Tax/discount calculations Mixed Reference (`A$1` or `$A1`) This locks either: * the row or * the column but not both. Example: `A$1` → Row is locked → Column can change `$A1` → Column is locked → Row can change This becomes extremely useful in: ✔ Dynamic tables ✔ Matrix calculations ✔ Forecast models ✔ Advanced reporting structures The interesting thing is this: Most Excel mistakes are not formula mistakes. They’re reference mistakes. People think Excel is “calculating wrong” when in reality the formula is pointing to the wrong cells after being copied. That’s why understanding references is such a major turning point. Once you understand how Excel thinks about references, formulas stop feeling random and start becoming predictable.

How much was your first ever Tech salary?