Opening Multiple Windows for the Same Workbook

Opening Multiple Windows for the Same Workbook

Suppose you’ve created a workbook like the one shown in Figure 12-35. You might want to monitor the cells on the summary worksheet while working on one of the other worksheets in the workbook. On the other hand, if you have a large worksheet, you might want to keep an eye on more than one area of the same worksheet at the same time. To perform either of these tasks, you can open a second window for the workbook by clicking New Window on the View tab.

You can work on the summary worksheet while viewing supporting worksheets in the same workbook.

Figure 12-35. You can work on the summary worksheet ...

Get 2007 Microsoft® Office System Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.