DeskPlainCompare matching cell positions only when both sheets have the same row order. If records moved, match them by a unique key first. Use EXACT for case-sensitive text, and use Spreadsheet Compare only if your Windows Office edition includes it.
Two spreadsheets can contain the same records in a different order. A cell-by-cell check will label many rows as changed even when the values are identical. Decide what you mean by a difference before selecting a method.
The two-minute starting decision
Make working copies. Compare sheet names, headers, record counts, and the first few IDs. If the row sequence is identical, position-based formulas can be useful. If it differs, identify a stable unique key, such as Order ID. A customer's name is usually unsuitable when that customer can have several orders.
| Question | Method | Limit |
|---|---|---|
| Did the same cell's value change? | Cell comparison formula | Requires aligned positions |
| Did a record's amount change? | Match by unique ID, then compare | Duplicates need resolution first |
| Did text capitalization change? | EXACT | Ignores cell formatting |
| Did formulas or formatting change? | Eligible Spreadsheet Compare installation | Not included with every Office edition |
Compare aligned cells with a small example
Copy the relevant values into two clearly labeled sheets named Old and New, preserving both original files separately. In a third sheet, =IF(Old!B2=New!B2,"Same","Changed") compares the values at B2. Fill only across the intended area, then inspect one known unchanged cell and one deliberate change.
This simple equality check does not enforce case-sensitive text matching. For text where capitalization matters, try =IF(EXACT(Old!B2,New!B2),"Same","Changed"). Microsoft defines EXACT as case-sensitive and formatting-independent. Neither example is a complete test of formulas, comments, charts, hidden sheets, or workbook settings. Blank cells and zero values also require a deliberate rule rather than an assumption.
Match moved records by their key
Suppose column A holds Order ID and column C holds Amount in both sheets. In New, a helper column can retrieve the older amount with =XLOOKUP(A2,Old!$A$2:$A$100,Old!$C$2:$C$100,"Missing ID"). Compare the retrieved amount with the current amount only after confirming that the key exists and is unique.
A lookup normally returns one match, so repeated IDs can hide a second record. Check duplicates in both versions first, and run a reverse check to find records removed from New. Missing and deleted records are different from an amount change. XLOOKUP is unavailable in Excel 2016 and 2019; choose a compatible exact-match method for those editions.
Handle meaningful versus cosmetic differences
Decide whether trailing spaces, capitalization, numeric text, and date presentation matter for this task. Preserve raw columns and put normalization in separate helper columns. An amount displayed as 10.00 may equal 10 numerically, while a product code ending with a space may fail a downstream import. Do not clean both lists until every disagreement disappears: that can erase a real issue.
For long narrative cells or copied instructions, paste plain text into our Text Difference Checker. It compares pasted text; it does not open XLSX files or inspect workbook formulas and formatting.
Use full-workbook comparison when available
Microsoft Spreadsheet Compare can report categories such as formulas, values, and cell formats. Microsoft limits availability to particular Professional Plus releases and Microsoft 365 Apps for enterprise. If installed, use Home > Compare Files, verify the earlier and later file selections, and inspect the categories relevant to your review. Record the tested range, key rule, and excluded features alongside the results.
Keep these in mind
- Choose position-based or key-based comparison deliberately.
- Check key uniqueness and added or removed records in both directions.
- State whether the report compares values, text case, or workbook structure.
Common questions
Does a matching value mean the workbook is identical?
No. Different formulas can produce the same current value, and charts, formatting, comments, macros, or hidden content may differ.
Why does sorting create so many differences?
Position-based comparison matches row numbers rather than records. Use a validated unique key when rows can move; do not sort just one column independently.
Sources & further help
Prepared with AI assistance from the linked documentation. This is a source-led explanation, not a claim of hands-on testing across every device. Read the editorial policy.