Opening Multiple Windows for the Same Workbook

Suppose you’ve created a Office 2007 workbook like the one\. You might want to mon-itor the cells on the Summary sheet while working on one of the other sheets in the workbook.On the other hand, if you have a very large worksheet, you might want to keep an eye on more than one area of the same worksheet at the same time. To do either of these things, you can open a second window for the workbook by choosing Window, New Window.

To view both windows together on your screen, choose Window, Arrange, and select any of the Arrange options except Cascade. If you choose the Cascade option, you’ll only be able to view the top sheet in the stack.

You might notice that Microsoft Office Professional 2007 Excel assigned the name Pacific Sales.xls:2 to the new workbook win-dow. In addition, it changed the name of the original workbook window to Pacific Sales xls:1. Because it was the active window when the New window command was issued, Pacific Sales.xls:2 now becomes the active window, and as such, it’s positioned on top, as indicated by the presence of scroll bars.

ou can view any part of the workbook in any window associated with that workbook.  Pacific Sales.xls:2 originally displayed the Summary sheet when we first created it, because that was the active sheet when we issued the New Window command. Then we clicked the Brass tab, leaving the Summary sheet visible in Pacific Sales.xls:1.