The Compare Files command lets you see the differences, cell by cell, between two workbooks.
The results are returned in a window in which you can see the differences side by side. Click Home > Copy Results to Clipboard to copy and paste the results to another program.
In Windows 7, click the Windows Start button and then > All Programs > Microsoft Office 2013 > Office 2013 Tools > Spreadsheet Compare 2013. Use the Workbook Relationship Diagram to create an interactive, graphical map of workbook dependencies created by connections (links) between files. You need to have two workbooks open in Excel to run this command.
If you work with scripts, Excel Compare can also be spawned from the command line. Excel Compare is perfect for analyzing the changes in data over time and can find new, changed and delete data.
Differences are highlighted with a cell fill color or text font color, depending on the type of difference. The Inquire tab on the Excel ribbon has buttons for the commands described below.
This diagram shows two levels of cell relationships for cell A10 on Sheet5 in Book1.xlsx.
To learn more about Spreadsheet Compare and comparing files, read Compare two versions of a workbook. This trail can help you find and correct mistakes before the auditors find them. This download is licensed as shareware for the Windows operating system from excel tools and can be used as a free trial until the trial period ends (after 15 days). Free version of OrgPlus, the leading organizational chart software, Compare sheets that contain a database structure, Comparison algorithm for the data not containing unique identifiers, Compare of any selected ranges of a sheet, Compare all files located in two different directories, Comparison of all sheets with the same names in two workbooks, Creates difference report as a new Excel sheet, Difference report keeps the format of the compared data, Division of the report into three parts: deleted, added and changed data, Automatic addition of user-defined macros to the report workbook. Important: Spreadsheet Compare is only available with Office Professional Plus 2013 or Microsoft 365 Apps for enterprise. Analyze a workbook To learn more, read See links between worksheets. This wikiHow teaches how to compare different sets of data in Excel, from two columns in the same spreadsheet to two different Excel files.
You can use the commands in the Inquire tab to do all these tasks, and more. Workbooks connected to other workbooks through cell references can get confusing. To learn more, see Clean excess cell formatting on a worksheet.
In the Compare Files dialog box, in the Compare row, browse to the earlier version of your workbook. To show cell formatting from the workbook, click Home > Show Workbook Colors. It can compare between different ranges of multiple spreadsheets and can even present the report as a new Excel spreadsheet.