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).
   194   195   196   197   198   199   200   201   202   203   204