Microsoft Office Tutorials and References
In Depth Information
Open a New Window for a Workbook
Chapter 1: Making Excel More Efficient
The Arrange Windows
dialog box appears.
5 Click to select the
If your worksheet has just
a few columns, you can
click to select the Vertical
6 Click to select the
Windows of Active
7 Click OK.
Excel arranges the
8 When you are done with
the second window, click
its Close button to return
to using just the original
If you are using the new window to monitor
either the first few rows or columns in the
workbook, then you might find it easier to
split the worksheet into panes instead of
creating a new window. In the View tab, click
the Split button and then click and drag the
pane borders to define the area you want to
monitor. The areas inside each pane scroll
independently, so you can keep the data in
the other area in view at all times.
Did You Know?
If you are using the new window to
monitor a particular cell value in
another part of the workbook, Excel
offers another method for doing this:
the Watch Window. You use this
window to monitor the current value of
one or more cells. To learn how to use
this window, see Chapter 4.