Viewing Two Worksheets At Once

http://excel.tips.net/Pages/T002688_Viewing_Two_Worksheets_At_Once.html
Summary: If you need to work on two worksheets in the same workbook at the same time, Excel makes this rather easy to do. All you need to do is display two windows and arrange them to both be visible. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

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.