In this example we have two worksheets in our workbook.
We want to view both worksheets on the same screen.
Here are four easy steps to execute this….
On the View tab click New Window.
Excel opens a new window containing another view of the workbook.
On the View tab click Arrange All.
Select the desired arrange setting. In this example we will select Horizontal.
Both worksheets can now be viewed on the same screen.