Page 98 - Excel 2007 Bible
P. 98

08_044039 ch04.qxp  11/21/06  10:56 AM  Page 55
                                             Moving and resizing windows
                                             To move a window, make sure that it’s not maximized. Then click and drag its title bar with your mouse.
                                             To resize a window, click and drag any of its borders until it’s the size that you want it to be. When you
                                             position the mouse pointer on a window’s border, the mouse pointer changes to a double-sided arrow,
                                             which lets you know that you can now click and drag to resize the window. To resize a window horizontally
                                             and vertically at the same time, click and drag any of its corners.
                                                       You can’t move or resize a workbook window if it’s maximized. You can move a minimized
                                          NOTE
                                          NOTE
                                                       window, but doing so has no effect on its position when it’s subsequently restored.
                                             If you want all your workbook windows to be visible (that is, not obscured by another window), you can
                                             move and resize the windows manually, or you can let Excel do it for you. Choosing View ➪ Window ➪
                                             Arrange All displays the Arrange Windows dialog box, shown in Figure 4.2. This dialog box has four window-
                                             arrangement options. Just select the one that you want and click OK. Windows that are minimized aren’t
                                             affected by this comment.
                                       FIGURE 4.2
                                     Use the Arrange Windows dialog box to quickly arrange all open workbook windows.
                                             Switching among windows                       Essential Worksheet Operations    4
                                             At any given time, one (and only one) workbook window is the active window. The active window accepts
                                             your input and is the window on which your commands work. The active window’s title bar is a different
                                             color, and the window appears at the top of the stack of windows. To work in a different window, you need
                                             to make that window active. You can make a different window the active workbook in several ways:
                                                 n Click another window, if it’s visible. The window you click moves to the top and becomes the
                                                    active window. This method isn’t possible if the current window is maximized.
                                                 n Press Ctrl+Tab (or Ctrl+F6) to cycle through all open windows until the window that you want to
                                                    work with appears on top as the active window. Shift+Ctrl+Tab (or Shift+Ctrl+F6) cycles through
                                                    the windows in the opposite direction.
                                                 n Choose View ➪ Window ➪ Switch Windows and select the window that you want from the
                                                    drop-down list (the active window has a check mark next to it). This menu can display up to nine
                                                    windows. If you have more than nine workbook windows open, choose More Windows (which
                                                    appears below the nine window names).
                                                 n Click the icon for the window in the Windows taskbar. This technique is available only if the
                                                    Show All Windows In The Taskbar option is turned on. You can control this setting in the
                                                    Advanced tab of the Excel Options dialog box (in the Display section).





                                                                                                                        55
   93   94   95   96   97   98   99   100   101   102   103