View Multiple Worksheets

View multiple Excel worksheets at the same time

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

Step 1

On the View tab click New Window.

Excel opens a new window containing another view of the workbook.

Step 2

On the View tab click Arrange All.

Step 3

Select the desired arrange setting. In this example we will select Horizontal.

Step 4

Click OK

Both worksheets can now be viewed on the same screen.




Be the first to comment

Leave a Reply