Apr 12, 2013 · Comparing Worksheets Is there an easier way to compare two workbooks to find differences than using the side by side or vlookup etc. I have two, with approximately 12,000 rows and 25 columns and I need to find the difference by row, then by column. In Excel, you can apply the New Window utility to compare two sheets in the same workbook. 1. Enable the workbook you want to compare two sheets within, and then click View > New Window. See screenshot: 2. Then go to the task bar to display the new window of the current workbook. In Excel, you can compare multiple sheets across different workbooks with the Arrange All function. 1. Open all workbooks you want to compare, and activate one of them, and click View > Arrange All. See screenshot: 2. Then the Arrange Windows dialog pops out, you can check one option in the Arrange section as you need.

Comparing Two Excel 2007 Worksheets Side by Side 1 Open the two workbooks you want to compare. 2 Click the View Side by Side button in the Window group of the View tab. 3 Scroll down or across a worksheet. Both worksheets scroll together because... 4 (Optional) Click the Synchronous Scrolling ... Apr 12, 2013 · Comparing Worksheets Is there an easier way to compare two workbooks to find differences than using the side by side or vlookup etc. I have two, with approximately 12,000 rows and 25 columns and I need to find the difference by row, then by column.