View Multiple Worksheets in Excel

 

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.

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.

Click Arrange All

4. Select the desired arrange setting. For example, click Horizontal.

Horizontal Arrange Setting

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.

View Multiple Excel Worksheets

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.

View Side by Side

Finally, to quickly switch between sheets in Excel, use the following handy keyboard shortcuts.

8. To quickly move to the next worksheet, press CTRL + Page Down.

9. To quickly move to the previous worksheet, press CTRL + Page Up.