Important: Spreadsheet Compare is only available with Office Professional Plus 2013, Office Professional 2016, or Office 365 ProPlus.
Use Spreadsheet Compare to compare two workbooks to see the differences between them, line by line. You can see how values, formulas, and formatting differ – line by line, and cell by cell.
Spreadsheet Compare can detect and highlight just the type of differences you specify.
Read the following articles for more information and step-by-step procedures.