View Multiple Workbooks

Excel offers an easy way to view multiple workbooks. Follow the steps below.

1. Open at least two workbooks.

2. Click “Arrange All” on the View tab.

Arrange all on View tab

3. Arrange your workbook the way you want. Here, we click Horizontal.

Arrange windows dialog box

4. Click OK.

multiple excel workbooks in one window

Note: You try other orientations as a practice to see what the workbooks look like.

3 of 5 finished! Recommending more on Workbook: Next Example >>
<< Previous Example | Skip to Next Chapter 04: Using Worksheet