Viewing 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. (Click here to see a related figure.)
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.