📊 Excel Basics #3 – Cell References (Relative, Absolute & Mixed References)

Cell references tell Excel which cell to use in a formula. Understanding them is essential when copying formulas.

📌 1. Relative Reference (A1)

• This is the default reference in Excel.

• It changes automatically when you copy the formula to another cell.

Example:

• In C2: =A2+B2

• Copy it to C3 → It becomes =A3+B3

Use relative references when the formula should adjust automatically.

📌 2. Absolute Reference ($A$1)

• The row and column are locked.

• The reference does not change when copied.

Example:

• Tax Rate in cell E1 = 18%

• Formula: =B2*$E$1

When copied down, Excel always refers to E1.

Use absolute references for fixed values like tax rates, exchange rates, discounts, or constants.

📌 3. Mixed Reference ($A1 or A$1)

• Locks either the column or the row, but not both.

$A1

• Column A is fixed.

• Row changes when copied.

A$1

• Row 1 is fixed.

• Column changes when copied.

Mixed references are useful when creating multiplication tables, pricing matrices, or budget templates.

💡 Shortcut:

While editing a cell reference in a formula, press F4 to cycle through:

• A1

• $A$1

• A$1

• $A1

✅ Quick Tip:

• Use A1 → When references should change.

• Use $A$1 → When references should stay fixed.

• Use $A1 or A$1 → When only one part should stay fixed.

Double Tap ❤️ For More