Datasheet
25
Chapter 1: Making Excel More Efficient
77
55
66
88
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.
03_577769-ch01.indd 2503_577769-ch01.indd 25 3/27/10 9:00 AM3/27/10 9:00 AM