Yes. In Excel for Microsoft 365 on Windows, the quickest built-in method is Spreadsheet Compare: open the Inquire tab, select Compare Files, and choose the two workbooks. If that option is unavailable, compare the files visually side by side or use formulas to check matching cells or records.
Choose a comparison method
The best approach depends on what “compare” means for your task. Spreadsheet Compare is designed to identify differences across workbook contents. Side-by-side viewing helps you inspect layouts and related sections, but it does not mark differences automatically. Formulas are useful when you need a repeatable check, such as finding changed prices or matching customer IDs.
- Use Spreadsheet Compare for a broad, cell-level review of two versions of a workbook.
- Use side-by-side viewing when you want to inspect sheets or formatting by eye.
- Use formulas when you need targeted comparisons, a reusable report, or a way to compare records by ID.
Before starting, make sure you know whether you are comparing cells in the same positions or records that should match by a key such as an invoice number. Those are different checks: a row may move between versions while its underlying record remains unchanged.
Compare workbooks with Spreadsheet Compare
Spreadsheet Compare is a Windows desktop tool associated with Excel’s Inquire features. When it is available, open Excel and choose Inquire > Compare Files. In the comparison dialog, select the older workbook as the “Compare” file and the newer one as the “To” file, then start the comparison. The tool opens a results view that helps you inspect detected differences.
If the Inquire tab is missing, check whether the add-in is available in your installed Excel edition. In Excel, go to File > Options > Add-ins. At the bottom, choose COM Add-ins in the Manage list and select Go. If Inquire appears in the list, select its checkbox and confirm. If it is not listed, your Office license or installation may not include the feature; enabling a checkbox cannot add a component that is not installed or licensed.
The results are more useful than simply opening two files and scanning them: Spreadsheet Compare can categorize differences and let you examine changed cells, including differences in content and formatting. The exact comparison options depend on the tool and configuration. Treat the report as a way to locate changes, not as a judgment about whether a change is correct. For example, a changed formula may be intentional, while a seemingly harmless number-format change could affect how a report is interpreted.
Keep both source workbooks unchanged while reviewing results. If you need to annotate findings, save a separate report or working copy rather than editing one of the originals during the comparison.
Availability on Mac and Excel for the web
Spreadsheet Compare and the Inquire add-in are Windows desktop features, and availability depends on the Excel edition or Microsoft 365 license. They are not standard comparison tools in Excel for Mac or Excel for the web. If you do not see Inquire in Windows, first check your organization’s Office license and installed apps; workplace administrators may control which features are provided.
On a Mac, you can compare sheets manually, use formulas, or open both workbooks in separate windows for visual review. Menu names and window controls can differ from Windows. Excel for the web is also suitable for viewing and editing many workbooks, but it does not provide the Inquire comparison workflow described above. For a detailed, repeatable review, use formulas in a workbook or compare the files in a supported Windows desktop installation.
View two workbooks side by side
For a visual check in Excel for Microsoft 365 on Windows, open both workbooks, select the View tab, and choose View Side by Side. If Excel asks which workbook to compare, select the other open file. When useful, turn on Synchronous Scrolling so scrolling one window also moves the other. Turn it off when the sheets are at different positions or you want to inspect them independently.
This method is helpful for comparing report headings, sheet organization, formulas shown in the formula bar, or formatting. It does not calculate a list of differences. A row inserted near the top of one sheet can also make a visual position-by-position comparison misleading: corresponding records may no longer appear on the same rows. On Mac, use the available window arrangement and viewing commands in that version of Excel; do not assume the Windows Inquire tab or its comparison dialog is present.
Compare cells in the same positions with a formula
If the two sheets have the same layout, put both sets of values in one workbook—for example, by copying each sheet into a comparison workbook—and use a helper column. Comparing within one workbook avoids relying on a live link to a separate file. The same technique works with formulas that refer to another open workbook, but external references can be awkward to maintain if a file is moved or renamed.
With the old value in A2 and the new value in B2, enter this formula in C2 and fill it down:
=IF(A2=B2,"Same","Different")
For example, if A2 contains 125 and B2 contains 130, the result is Different. If both contain 125, the result is Same. The comparison treats text case as equivalent, so “North” and “NORTH” compare as the same. It also treats two blank cells as equal. If capitalization matters, use Excel’s EXACT function instead:
With the old text in A2 and the new text in B2, enter this in C2 and fill down:
=IF(EXACT(A2,B2),"Same","Different")
EXACT returns TRUE only when the text matches character for character, including letter case. For instance, “North” and “NORTH” produce Different. Choose the ordinary equality check for typical numeric or case-insensitive comparisons; use EXACT when letter case is part of the data you are validating.
Match records by an ID instead of row number
When rows can be sorted or inserted, match records by a stable identifier rather than comparing the same row numbers. Suppose the old data has IDs in A2:A100 and amounts in B2:B100, while the new data has IDs in D2:D100 and amounts in E2:E100. Put this formula beside the old data and fill it down:
=IFERROR(IF(B2=XLOOKUP(A2,$D$2:$D$100,$E$2:$E$100),"Same","Changed"),"Missing from new")
If ID 104 has an old amount of 250 and the matching new amount is 275, the result is Changed. If ID 104 is absent from the new list, the result is Missing from new. XLOOKUP is available in Microsoft 365 and Excel 2021 or later. It uses an exact match by default, which suits IDs. If the new list can contain duplicate IDs, investigate those duplicates rather than relying on a single lookup result.
This formula checks whether each old ID is present in the new list; it does not find IDs that exist only in the new list. To identify those, check each new ID against the old ID range too. A comparison is only as reliable as its key: if IDs have extra spaces, inconsistent number-versus-text formats, or accidental duplicates, clean or validate those fields before drawing conclusions.
What to verify before trusting the results
First, check that you selected the intended versions. Similar file names, dates, or copies in different folders can make it easy to compare the wrong pair. Confirm the workbook names and, where relevant, the sheet names and reporting periods before reviewing differences.
- Check sheet structure. Confirm that similarly named sheets represent the same information and that columns have not been repurposed.
- Check formulas as well as displayed values. Two cells may show the same number while using different formulas, or show different numbers because one workbook has not recalculated.
- Consider formatting separately. A changed date format can alter how a value appears without changing the stored date; a changed number format can affect readability without changing the underlying number.
- Look for missing and added records. Position-based checks do not reliably reveal records moved to another row. Use an ID-based check and review both directions.
- Check workbook features beyond ordinary cells. A cell comparison does not automatically establish that macros, external connections, charts, pivot tables, or other workbook components behave identically.
For sensitive files, follow your organization’s rules for storing or uploading data. Spreadsheet Compare and formulas can help identify differences, but they do not replace access controls, backup procedures, or a formal review process.
Common problems and practical fixes
Inquire or Compare Files is missing: confirm you are using Excel desktop for Windows and check the installed edition and license. If Inquire is listed under COM Add-ins, enable it there. If it is not listed, ask your administrator or use a formula or visual method instead.
Many cells appear different after a sort: the rows may no longer align. Compare by a unique ID rather than cell position. Formulas show unexpected differences: check whether formulas refer to different sheets, ranges, or external files, and recalculate the workbooks if necessary. A lookup says an ID is missing even though it looks present: inspect for spaces, leading zeros, or a value stored as text in one list and as a number in the other.
One common misconception is that “same displayed value” means “same cell.” A formula result can be identical while its formula, source data, or formatting differs. Decide whether your task concerns displayed values, formulas, formatting, or entire records, then select a method that checks that specific thing.
Frequently Asked Questions
Can Excel compare two workbooks automatically?
Yes. Spreadsheet Compare can identify differences when it is available in Excel for Windows. Otherwise, formulas can compare selected cells or records, while side-by-side viewing supports a manual review.
Is Spreadsheet Compare included with every Microsoft 365 plan?
No. Availability depends on the Windows Excel edition and license. Check for the Inquire tab or the Inquire COM add-in; if neither is available, use another comparison method or ask your organization’s administrator.
Can I compare two workbooks in Excel for Mac?
You can compare them with formulas or by viewing their windows side by side, but the Windows Inquire and Spreadsheet Compare workflow is not available as a standard Mac feature.
Can Excel compare workbooks when rows are in a different order?
Yes, if you match records by a stable unique key such as an order ID. A simple cell-by-cell comparison assumes that corresponding information is in the same positions.
Does side-by-side viewing highlight changed cells?
No. It displays both workbooks for you to inspect but does not generate a difference report. Use Spreadsheet Compare, or create formulas, if you need differences identified automatically.
Related
- Machine ROI Calculator in Excel: Build and Use One
- Mac Numbers vs Excel: Which Spreadsheet Should You Use?
- Machine Checklist Format in Excel: A Practical Template
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Share a Calendar in Outlook: Steps and PermissionsTo share your Outlook calendar, open Calendar, choose Share Calendar or Sharing and permissions, add the recipient, select…
- Excel Regression Line: Add, Format, and Interpret ItYes. In Excel for Microsoft 365 on Windows, create or select an XY scatter chart, then choose Chart…
- Rotate an Excel Table in Word: Step-by-Step GuideTo rotate an Excel table in Word, copy the cells from Excel, paste them into Word as a…
- Create a Brochure in Microsoft Word: Layout, Steps and TipsTo create a brochure in Microsoft Word, start with a brochure template or set up a blank document…
- Wrap Text in Excel: Keyboard Shortcuts and Quick FixesIn Excel for Microsoft 365 on Windows, select the cell or cells and press Alt, H, W—one key…
- How to Remove Double Spaces in Excel Without Losing DataTo remove repeated spaces in Excel, select the cells and use Home > Find & Select > Replace…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.