Microsoft Excel 2007 with Example
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.
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.
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.
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.