How to view multiple worksheets at the same time
To view multiple worksheets at the same time follow these steps:
1. Open your workbook.
2. In the Window menu click New Window.
3. In the Window menu click Arrange and select an option (Tiled, horizontal .. etc). Now you will have two windows showing the same worksheet.
4. Click on any one of the two windows and select a different worksheet. Now each one of your windows will point to a different worksheet, and you can have as many windows as you want.
Applies to Excel 2003



