Hidden Excel: Spreadsheet Compare


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.
  3. Click the folder icon to select the older and newer files, then click OK.



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

Author: quincy harley jr

Quincy is a technophile, coach and Learning Development expert. He has an extensive legal IT background and is practiced in MS Office application support and product development. As a project leader he has been integral in numerous new application rollouts. Whatever spare time he has, is spent with reading, archery and watching his young sons grow.

3 thoughts on “Hidden Excel: Spreadsheet Compare”

  1. Yes! Isn’t it great? So glad you’ve highlighted this functionality! I found it last spring because someone in one of my classes asked me if it was possible to compare two worksheets. I always research those kinds of requests, but I wasn’t expecting to find anything. Imagine my surprise! Created a quick reference which has received some traffic, a like, and even a follow-up question on my current client’s Jive site. I measure success as any kind of response. 😉

  2. Thanks Quincy! I compared a couple of XLs using the tool and it appears to work fine showing the differences in the UI but the Export Results button is grayed out. Would you know why?

Comments and Replies SOOO welcome!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: