Relative references (A1) in Excel - Cell-by-Cell Formula Trace

Concept Flow

    A     B
1 | 10 | =A1 |
2 | 20 | =A2 |
3 | 30 | =A3 |

Arrows:
B1 -> A1
B2 -> A2
B3 -> A3

Each formula in column B uses a relative reference to the cell in column A on the same row. When copied down, the reference adjusts to the row.

Formula

=A1 copied down to B2 and B3 becomes =A2 and =A3 respectively

The formula in B1 is =A1. When copied down to B2, it changes to =A2, and in B3 it changes to =A3. This is how relative references work.

Step-by-Step Trace

Cell	Formula	Evaluated Value
B1	=A1	10
B2	=A2	20
B3	=A3	30

Each cell in column B shows the value from the corresponding cell in column A using relative references.

Variable Tracker

Cell	Referenced Cell	Referenced Value
B1	A1	10
B2	A2	20
B3	A3	30

Key Moments

What value does the formula =A2 in cell B2 return?

What happens to the reference when the formula =A1 in B1 is copied to B3?

Sheet Trace Quiz - 3 Questions

What value will appear in cell B2?

A 10

B 20

C 30

D 0

Key Result

Relative references in Excel adjust automatically when formulas are copied to other cells, pointing to cells relative to the formula's new position.

Transcript

We start with a formula in B1 that is =A1. This means B1 shows the value from A1, which is 10. When we copy this formula down to B2, the formula changes to =A2 automatically, so B2 shows 20. Similarly, copying down to B3 changes the formula to =A3, showing 30. This behavior is called relative referencing because the reference changes relative to the formula's position. This helps us copy formulas easily without manually changing cell references.