Method 1: Simple Cell-by-Cell Formula
If both sheets have the same structure, create a third sheet and use:
=IF(Sheet1!A1=Sheet2!A1,"","Changed")Copy it across the range. Blank cells mean no difference; changed cells show a marker.
Method 2: Conditional Formatting
Conditional formatting can highlight cells that differ from another sheet. This works best when the row and column layout is identical. It is less useful if rows were inserted, deleted, or reordered.
Method 3: View Side by Side
Excel's View Side by Side feature is useful for visual review, especially for small sheets. It does not automatically generate a difference report, so it is not ideal for large workbooks.
Method 4: Use an Excel Compare Tool
The Compare Excel Files tool compares two workbooks and reports cell-level changes. It is useful when you want a downloadable comparison report instead of scanning manually.
What to Check After Comparing
- Changed values: the same cell exists in both files but has different content.
- Added values: the second file contains data not found in the first file.
- Removed values: the first file contains data missing from the second file.
- Formula changes: values may look similar while formulas changed underneath.
Important Limitation
If rows were sorted differently, a cell-by-cell comparison may show many false differences. Sort both sheets by the same stable ID column first, or compare by unique record IDs instead of visual row position.