O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Opening Multiple Windows for the Same Workbook

image with no caption

Suppose you’ve created a workbook like the one shown in Figure 7-5. 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.

We want to work on the summary worksheet while viewing a supporting worksheet in the same workbook.

Figure 7-5. We want to work on the summary worksheet while ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required