Page 199 - Excel Timesaving Techniques for Dummies
P. 199
38_574272 ch33.qxd 10/1/04 10:53 PM Page 184
184
Technique 33: Managing Worksheet Windows
vertical scrolling of each pane remains independent. compare data from separate sheets or from different
When you split a window into two vertical panes workbook files. The easiest way to do this is to use
(as shown in Figure 33-2), the worksheet window Excel’s Compare Side by Side feature to split the
contains a single vertical scroll bar and two separate worksheet into two horizontal windows (one on top
horizontal scroll bars: All vertical scrolling of the of the other) in which you can display different
two panes is synchronized; horizontal scrolling of sheets from the same workbook.
each pane remains independent.
The following steps show how to use this feature to
When you split a window into two horizontal and compare data entered in the same regions on sepa-
two vertical panes (as shown in Figure 33-3), the rate sheets of a spreadsheet. The example compares
worksheet window contains two horizontal scroll revenue figures from two different years, entered on
bars and two separate vertical scroll bars: Vertical separate sheets of the same workbook:
scrolling is synchronized in the top two window
panes when you use the top vertical scroll bar 1. Open the workbook containing the sheets you
and synchronized for the bottom two window want to compare and then activate the work-
panes when you use the bottom vertical scroll bar. sheet that you want to appear in the topmost
Likewise, horizontal scrolling is synchronized for the window (as shown in Figure 33-4).
left two panes when you use the horizontal scroll bar
on the left and synchronized for the right two panes
when you use the horizontal scroll bar on the right.
To move the cell pointer from pane to pane
with the keyboard when the window is split
into four panes, press F6 (the cell pointer
moves to the first cell in each pane, going
clockwise) or press Shift+F6 (the cell pointer
moves to the first cell in each pane, going
counterclockwise).
To remove all panes from a window when you no
longer need them, choose Window➪Remove Split.
You can also remove individual panes by dragging
the gray dividing bar for the horizontal or vertical
pane until you reach one of the edges of the work- • Figure 33-4: Spreadsheet with annual revenues on
sheet window — or you can simply double-click the separate worksheets.
bar that divides that pane.
2. Choose Window➪Compare Side by Side With.
Comparing Sheets in Excel creates two horizontal windows numbered
1 and 2, with window 2 on the top and window 1
the Same Workbook on the bottom (as shown in Figure 33-5).
3. Press Ctrl+F6 to activate window 1 (the lower),
Panes are fine for comparing different sections of the and then select the sheet tab of the worksheet
same worksheet, but you need to divide the Excel whose data you’re comparing with the data in
worksheet into separate windows if you want to window 2 (as shown in Figure 33-6).