Viewing Two Worksheets At Once

Dan asked if it is possible to see two Excel worksheets on the screen at the same time. Yes, you can do this, using the same general technique that you use to view multiple worksheets from different workbooks. Follow these steps:

1. Make sure you have only a single workbook open.
2. Choose New Window from the Window menu. (In Excel 2007 display the View tab of the ribbon and click New Window in the Window group.) Excel opens a second instance of the same workbook.
3. Choose Arrange from the Window menu. Excel displays the Arrange Windows dialog box. (Click here to see a related figure.) (To display this dialog box in Excel 2007 display the View tab of the ribbon and click Arrange All in the Window group.)
4. Choose the method Excel should use to arrange your windows.
5. Click on OK. Excel arranges the windows as you directed.

In each of the windows you can display different worksheets, even though they are part of the same workbook. When you are done, simply close one of the windows.

It is interesting to note that if you have a need to do so, you can view more than two worksheets from the same workbook. All you need to do is perform step 2 as many times as necessary to open the desired number of windows.