View worksheets side by side
The sheets can be in the same workbook or in different workbooks.
On the View tab, in the Window group, click View Side by Side:
- To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.
- To close Side by Side view, click View Side by Side in the Window group on the View tab.