Microsoft Excel 2007 View Multiple Worksheets at the Same Time

When working with Excel you may need to see two worksheets on the screen at the same time. 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.  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.  On the View tab of the ribbon, click Arrange All in the Window
     group. Excel displays the Arrange Windows dialog box.

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.