How to compare worksheets side by side
To compare two worksheets side by side, on the “VIEW” tab click “New Window”.
Excel opens up a second window showing the same spreadsheet. Unlike in previous versions, each window in Excel 2013 has its own menu bars so that it’s easier to work on multiple monitors. In the window marked with colon 1 I’ll open up the worksheet with the budget for 2014. To see these windows side by side on the “VIEW” tab click “View Side-by-Side” and make sure that “Synchronous Scrolling” is turned on under the “VIEW” tab to scroll both windows simultaneously.
Now I can easily compare the windows side by side. If I want to scroll each window independently I’ll click “Synchronous Scrolling” on the “VIEW” tab to turn it off, and then I can scroll them one by one.