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.
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.
All open workbooks will be displayed on the screen.