Microsoft Excel 2007 with Example

3 Basics

3.4 Workbook: View Multiple Workbooks

If you want to view multiple Excel workbooks at the same time, execute the following steps.

1. First, open two or more workbooks.

2. On the View tab, click Arrange All.

Click Arrange All

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

Horizontal Arrange Setting

4. Click OK.

View Multiple Workbooks

Note: 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.