Page 197 - Excel Timesaving Techniques for Dummies

38_574272 ch33.qxd 10/1/04 10:53 PM Page 182
33 Managing
Worksheet

Windows
Technique

eeping tabs on your data in a large spreadsheet is a challenge.
Save Time By Comparing the data entered into widely separate parts of the same
Kworksheet can require a lot of scrolling back and forth between
Splitting the window
into panes to view regions. The problem is only compounded when you’re dealing with a
diverse parts of the spreadsheet whose data is distributed over different worksheets. There
same worksheet you have to flip between sheets and scroll the regions you’re comparing
into view.
Setting up windows on
separate sheets of the This technique covers ways you can use worksheet windows to compare
same workbook data, copy and move it between different regions of the same (or differ-
Setting up windows on ent) worksheets, and even move it from one workbook file to another.
separate sheets in differ- Two approaches are possible:
ent workbooks
Using a single worksheet: You split the worksheet window into hori-
zontal or vertical panes and then scroll different sections of the sheet
into view.
Using data on different worksheets: You open a second window on a
second worksheet and then arrange the windows to display data from
the desired regions of both worksheets.

Opening Panes in the Worksheet Window

Excel makes it easy to split the worksheet window into two or four panes,
each equipped with its own scroll bars. After splitting the window into
panes, you can then use each pane’s scroll bars to bring different parts of
the same worksheet into view. This is great for comparing the data in dif-
ferent sections of a table that wouldn’t otherwise be legible if you zoomed
out far enough to display both sections in the worksheet window.

To split the worksheet window into panes, you can use a variety of meth-
ods. The most direct way when you need to split the window into only
two panes is by dragging the window’s split bars to the desired row or
column. The most direct way when you need to split the window into
four panes is to strategically position the cell pointer at the appropriate
row and column and then choose Window➪Split.