Relative Reference in Microsoft Excel

What is a Relative Reference?

A Relative Reference is a cell reference that changes automatically when a formula is copied or moved to another cell.

In a relative reference, the column letter and row number are not fixed.

The normal cell reference, such as:

A1
B2
C5

is a relative reference.

Simple Example

Suppose we have:

In cell C2, we enter:

=B2+5

If we copy the formula from C2 to C3, Excel automatically changes the reference:

C2 → =B2+5
C3 → =B3+5

The reference changes according to the new position of the formula.

How Relative Reference Works

Original Formula
      ↓
=B2+5
      ↓
Copy Formula Down
      ↓
=B3+5
      ↓
Copy Again
      ↓
=B4+5

The row number changes because the formula has been moved down.

Similarly, if a formula is copied to another column, the column reference can also change.

Example with Student Marks

Suppose we want to add 5 bonus marks to every student’s marks.

Instead of writing every formula separately, we can enter:

=B2+5

in the first result cell and copy it downward.

Excel automatically adjusts the relative reference:

=B2+5
=B3+5
=B4+5

Important Point

In a Relative Reference, there is no $ symbol before the column or row.

A1     → Relative Reference
B2     → Relative Reference
C5     → Relative Reference

Whereas:

$A$1   → Absolute Reference

The $ symbol is used when we want to fix a row or column.

Relative Reference Formula Chart

Original Cell: C2
Formula:       =B2+5

        ↓ Copy Down

New Cell:      C3
Formula:       =B3+5

        ↓ Copy Down

New Cell:      C4
Formula:       =B4+5

Quick Comparison

Easy Way to Remember

Relative Reference = Reference moves with the formula.

A1
 ↓
Copy Down
 ↓
A2
 ↓
Copy Down
 ↓
A3

One-Line Definition:

A Relative Reference is a cell reference that automatically changes its row and/or column when the formula is copied or moved to another cell.

Reference: Your provided notes explain Relative Reference along with Absolute and Mixed References and show how references behave when formulas are copied.