You can quickly compare two worksheets in the same workbook or in different workbooks by viewing them side by side. You can also arrange multiple worksheets to view them all at the same time.
Learn how to setup Excel to view two sheets side-by-side in the same workbook using the New Window feature. This technique is great for writing formulas, copying and pasting data, or comparing two or more sheets. It saves time from having to navigate between two tabs that are not close to each other in the workbook.
View Multiple Worksheets
If you want to view multiple Excel worksheets at the same time, execute the following steps.
1. Open a workbook.
2. On the View tab, in the Window group, click New Window.
Excel opens a new window containing another view of the document.
3. On the View tab, in the Window group, click Arrange All.
4. Select the desired arrange setting. For example, click Horizontal.
5. Click OK.
The titles (view-multiple-worksheets:1 and view-multiple-worksheets:2) indicate that two windows of the same file are open.
6. In the lower window, select the sheet tab of Wk2. You can now view the sales in week 1 and week 2 at the same time.
Note: any changes you make to one window are immediately reflected in the other window.
7. On the View tab, in the Window group, click View Side by Side (by default, Synchronous Scrolling is activated), to scroll both worksheets at the same time.