Tip 292 – View two sheets from the same workbook, side by side

If you need to see two sheets from the same workbook side by side, open one of the sheets and click on the View tab. Click the “New Window” button and a duplicate view of your sheet will open. Both views will have a :1 and :2 after the name in the Window title. Press the Windows button and left arrow to move one of the sheets to the left hand side of the Window, then select the other view and use the Windows button and right key to set it to the right half of the screen. You can now select the sheets you want to see in each view, and any changes made on either view will be made to the original Workbook.