how to compare two excel 2010

Here is a very detailed tutorial

Comparing Two Excel 2007 Worksheets Side by Side

http://www.dummies.com/how-to/content/comparing-two-excel-2007-worksheets-side-by-side.html

Use xc Excel Compare Tools.

http://www.addictivetips.com/windows-tips/compare-two-excel-2010-worksheets/

• On the View tab, in the Window group, click New Window.
• On the View tab, in the Window group, click View Side by Side

• In the workbook window, click the worksheets that you want to compare.
• To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.

• If you resize the workbook windows for optimal viewing, you can click Reset Window Position to return to the original settings.
• To restore a workbook window to full size, click Maximize at the upper-right corner of the workbook window.