how to compare excel worksheets for differences

HOW TO COMPARE EXCEL WORKSHEETS FOR DIFFERENCES HOW TO

Calculated Values: it highlights the difference in the computed values within the workbooks.

Entered Values: it highlights a change in the data input within the workbooks.

The function of some of the checkboxes are explained below: Step 6: You can streamline what the Spreadsheet Compare tool analyzes by either ticking or unticking the checkboxes at the bottom left of the tool. Note: If you find that the order of the file comparison is mixed up, you can click on Swap to change the position of each workbook. Step 5: Click on OK to begin the comparison process. Select the Excel file in File Explorer and click on Open. Step 4: Select the File icon beside the To (newer file) option within the Compare Files dialog box. Step 3: Within the Compare Files dialog box, select the File icon beside the Compare (older file) option. Step 2: On the Home Tab, in the Compare group, select Compare Files to launch a dialog box.

Step 1: From the Start menu, search for Spreadsheet Compare and launch it. To analyze different versions of a workbook, you have to import both workbooks in the Spreadsheet Compare tool.

HOW TO COMPARE EXCEL WORKSHEETS FOR DIFFERENCES HOW TO

Here’s how it works: How to Analyze Two Versions of a Workbook With Microsoft Spreadsheet Compare

The tool then analyzes the files and highlights the differences using certain criteria. The tool can be accessed from the Microsoft Office Tools program group.įor the comparison to work, it is necessary to have different versions of the spreadsheet. You can access Microsoft Spreadsheet Compare in Microsoft 365, Office Professional Plus 2013, Office Professional Plus 2016, and Office Professional Plus 2019. Requirements to Use Microsoft Spreadsheet Compare

How to compare excel worksheets for differences