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.
View2

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

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.
View4

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

All open workbooks will be displayed on the screen.
View5




Be the first to comment

Leave a Reply