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
Find and launch the app by clicking Start then typing ‘Spreadsheet Compare’.
Click Compare Files. The Compare Files dialog appears.
Click the folder icon to select the older and newer files, then click OK.
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.
View all posts by quincy harley jr
2 thoughts on “Hidden Excel: Spreadsheet Compare”
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. 😉
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. 😉
Thanks, Lisa. And kudos on the find (and write up)! 🙂