OHSU's Software Forum

Bill Foust · Joined: 11 Apr 2008 Posts: 10

When you are working with two worksheets in a workbook, and you are frequently switching back and forth between them, say, to check the effect of some data entry, consider displaying them both on the screen at the same time instead.

With just the one workbook open, click on the View tab, then click on New Window. A second instance of your workbook will open, and you can then click on Arrange All, and select your preference from the options presented: Tiled, Vertical, Horizontal or Cascade.

You can now display different worksheets in each of the windows, even though they are in the same workbook. Changes in one window will trigger appropriate updates in the other window in cells with formulas.

To "undo" the arrangement, just close one of the windows.