How to Compare Two Ranges in Excel (Cell-Level Diff)
You need to know precisely which cells changed between two versions of a grid — but an IF-formula grid is tedious and falls apart the moment a row is inserted. Here's why, and the one-click way.
Last updated: August 2026
| Cell (old → new) | Diff | |
|---|---|---|
| B2: 100 → 100 | → | (same) |
| B3: 40 → 55 | → | Changed |
| Row 5 | → | Added |
Why IF grids are tedious
The manual way is a mirror grid of =IF(Sheet1!A1<>Sheet2!A1,"diff","") across every cell. It's slow to lay out over a wide table, it clutters the sheet with a second grid, and it assumes both ranges line up perfectly. Insert one row in the new version and every cell below shifts, so the formula reports the whole tail as different when nothing really changed. There's no built-in way to diff two ranges cleanly.
The 1-click way — Tellsheet's Diff Two Ranges
Select the first range and run Diff Two Ranges. Point it at another range of the same layout and it writes a new sheet listing every changed cell with its old and new value, plus rows added or removed. It's the cell-level companion to Reconcile, with a case-sensitive option, and it runs fully local — nothing leaves your PC. Pairs with Reconcile and Compare Two Excel Files.
Frequently asked questions
How do I compare two ranges cell by cell?
Diff Two Ranges lists every cell that changed between two ranges of the same layout, plus rows added or removed, on a new sheet.
Why not just use an IF formula grid?
An IF grid is tedious to build, clutters the sheet, and can't handle inserted rows — everything after the shift shows as different.
Can the comparison be case-sensitive?
Yes — a case-sensitive option lets 'ACME' and 'Acme' count as a difference or as equal, whichever you need.
How is this different from Reconcile?
Reconcile labels whole rows by a key; Diff Two Ranges lists each individual cell that changed.
Related Excel guides
Diff two ranges in one click
Diff Two Ranges lists every changed cell between two grids, plus rows added or removed, on a new sheet — fully offline.
Get Tellsheet free See pricing