Absolute Reference in Microsoft Excel

What is an Absolute Reference?

An Absolute Reference is a cell reference that does not change when a formula is copied or moved to another cell.

In an Absolute Reference, both the column and row are fixed using the $ (dollar) symbol.

Basic Example

$A$1

Here:

• $A → Column A is fixed

• $1 → Row 1 is fixed

Therefore, $A$1 will remain the same even when the formula is copied to another cell.

Why is Absolute Reference Used?

Absolute Reference is useful when a formula needs to use the same fixed cell or value repeatedly.

For example, suppose cell E1 contains a fixed tax rate:

E1 = 18%

If we calculate tax for different amounts, we want every formula to use the same tax rate in E1.

We can write:

=B2*$E$1

When this formula is copied down:

B2*$E$1
B3*$E$1
B4*$E$1
B5*$E$1

The amount reference changes, but $E$1 remains fixed.

Formula Example

Suppose:

Here, the tax rate is stored in C1.

The formula:

=B2*$C$1

uses:

• B2 → Relative Reference

• $C$1 → Absolute Reference

When the formula is copied down:

=B2*$C$1
=B3*$C$1
=B4*$C$1

The B2 reference changes, but $C$1 stays fixed.

Role of $ Symbol

The $ symbol is used to lock or fix a row or column reference.

For a completely absolute reference:

$A$1

Reference Chart

A1      → Relative
$A$1    → Absolute

Absolute Reference vs Relative Reference

Easy Formula Chart

Relative:
=B2*C2
 ↓ Copy Down
=B3*C3
 ↓
=B4*C4

Absolute:
=B2*$E$1
 ↓ Copy Down
=B3*$E$1
 ↓
=B4*$E$1

Notice:

B2 → B3 → B4 changes because it is relative.

$E$1 → $E$1 → $E$1 does not change because it is absolute.

Using F4 Key

The reference material also explains the use of the F4 key to change between different cell reference types while entering a formula.

For exam