Hidden Excel: Spreadsheet Compare

Capture2

This hidden gem,  (available with Office Professional 2013,  2016, and Office 365 ProPlus) makes it easy to compare two workbooks, interactively. You can see how values, formulas, and formatting differ – line by line, and cell by cell, highlighting just the type of differences you specify.

To Use Spreadsheet Compare

  1. Find and launch the app by clicking Start then typing ‘Spreadsheet Compare’.
  2. Click Compare Files. The Compare Files dialog appears.
    Capture
  3. Click the folder icon to select the older and newer files, then click OK.

Cheers

quincy

Related Posts

  1. Hidden Excel: Find Date Differences with DATEDIF
  2. Excel Text Functions 1 of 4: =LEFT() and =RIGHT()
  3. Using Histogram for Data Analysis