View Multiple Workbooks

This tutorial will show you how to quickly navigate between active workbooks or display multiple active workbooks on the same screen.
In this example we have two active workbooks: Book1 and Book2.

View Side by Side

Instead of switching back and forth between workbooks you can view them side by side. This makes it easier if you need to compare information in each workbook.

Click on the View tab.
Click View Side by Side.

Both workbooks will be displayed on the screen with an addition option to Synchronous Scrolling on the workbooks.

Arrange All

The Arrange All options will stack all open workbooks so you can see them all at once.

Click the View tab.
Click Arrange All.

An options box will appear.
Select your desired layout.
Click OK.

All open workbooks will be displayed on the screen.

Be the first to comment

Leave a Reply