Microsoft Excel 2007 with Example

3 Basics

3.14 Worksheets: 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, click New Window.

Click New Window

Excel opens a new window containing another view of the document.

3. On the View tab, click Arrange All.

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

Vertical Arrange Setting

5. Click OK.

The titles (view-multiple-worksheets:2 and view-multiple-worksheets:1) indicate that two windows of the same file are open.

6. In the right 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 Worksheets

Note: any changes you make to one window are immediately reflected in the other window. 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.