MENU
Donate
=TOOLS.A12

Cell reference converter

Convert between A1 and R1C1 notation, or paste a reference to see its relative and absolute variants side by side. No sign-up required.

A1 ↔ R1C1

Edit either field — the other updates to match. This converts absolute R1C1 (like R4C2); relative brackets such as R[1]C[-1] depend on Excel's active cell and aren't supported here.

Relative ↔ absolute helper

Paste a cell reference to see all four ways to lock it — handy before copying a formula across cells.

  • RelativeA1
  • Absolute$A$1
  • Column locked$A1
  • Row lockedA$1

Sources we reference — not partners

26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.

Official documentation

Educators and channels

Course platforms

AI & data tools