Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

How to Compare Two Excel 2010 Worksheets

There are several freewares to compare excel sheets and most of them are worth to try. If you already using Excel 2010, you can compare worksheets with this free add-in which allows comparison of values and formulas between two excel spreadsheets. The xc Excel Compare Tools add-in supports Excel 2010 and Excel 2007.

After installation, just go to the Add-Ins tab and hit Compare. On the xcCompareTools dialog, select the first spreadsheet and the second spreadsheet, then select if you want to compare the value or formula and lastly hit the Compare Sheet button to start the comparison.

Download xc Excel Compare Tools via [Google Code]