Excel 2007 lets you view two worksheets side by side, as opposed to flipping between them. This is especially helpful when you need to compare two worksheets because you view them both on your desktop at once.
To compare two worksheets side by side in Excel 2007:
- On the View tab, within the Window group, click New Window.
- On the View tab, within the Windows group, click View Side by Side.
- In the Compare Side by Side dialog box, 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.