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
Horizontal option.
If your worksheet has just
a few columns, you can
click to select the Vertical
option, instead.
6 Click to select the
Windows of Active
Workbook option.
7 Click OK.
Excel arranges the
workbook’s windows.
8 When you are done with
the second window, click
its Close button to return
to using just the original
workbook window.
Try This!
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.
Search JabSto ::

Custom Search