If you need to compare two worksheets in Microsoft Excel, and want to make easy doing this job, you have to be able see those two sheets at the same time.
Showing two worksheets in one page at the same time in Ms Excel 2007, follow these steps :
Open the excel file
Click on View tab
Go to Window area menu
Click on the New Windows
Click on the View Side by Side
To make synchronous scrolling between those two worksheets, click on synchronous scrolling