How to Compare Sheets in Excel 2007

Compare Worksheets in the Same Workbook
1. Click the 'View' tab and click 'New Window' from the 'Window' group.
2. Click the 'View Side by Side' button from the 'Window' group.
3. Click the tabs at the bottom of each worksheet to display the worksheets you want to compare.
4. Click the 'Synchronous Scrolling' button from the 'Window' group to scroll both worksheets at the same time.
Compare Worksheets from Different Workbooks
5. Open both workbooks that contain the worksheets that you want to compare.
6. Click the 'View' tab and click 'New Window' from the 'Window' group.
7. Click the 'View Side by Side' button from the 'Window' group.
8. Click the tabs at the bottom of each worksheet to display the worksheets you want to compare.
9. Click the 'Synchronous Scrolling' button from the 'Window' group to scroll both worksheets at the same time.