ExcelBasics

Click here to edit subtitle

Windowing sheets and books

To view two workbooks at the same time:

  1. Open both workbooks.
  2. Click on the View tab.
  3. Click on Arrange all.
  4. Click on how you would like the workbooks displayed
  5. Click ok after selection

 

Realize that even though you can see both workbooks at the same time, only one of them is active at any given time. You may switch between them by simply clicking back and forth, or by pressing Ctrl + F6.

If you would like to look at worksheets in the same workbook you will need to open a new window:

  1. Click on the View tab.
  2. Click on New Window.
  3. Click on Arrange All.
  4. Click on how you would like the workbooks displayed
  5. Click ok after selection

Vertial Selected

Horizontial selected