View More Than One Worksheet at the Same Time

0 Flares 0 Flares ×

A common question I hear when training Excel or browsing the forums is whether it is possible to view more than one worksheet in a book at the same time.

Well yes there is.

There is no real set feature for this task. It involves arranging windows just as you would with multiple workbooks.

With the workbook open and selected;

  1. Click the View tab on the Ribbon
  2. Click the New Window button in the Window group. Excel opens a second instance of the workbook
  3. Click the Arrange All button in the Window group

Arrange windows on screen

  1. Select the arrangement option you want to use and click Ok

The windows are arranged as selected and you can now select a different sheet and view them both at the same time.

Check out this video on how its done.

Leave a Reply

Your email address will not be published. Required fields are marked *