Publishers of technology books, eBooks, and videos for creative people

Home > Articles > Productivity > Microsoft Excel

  • Print
  • + Share This
This chapter is from the book

Workbook Windows

Like most Windows programs, Excel allows you to have more than one document window open at a time. You can manipulate Excel's workbook windows a number of ways:

  • Activate a window so you can work with its contents.
  • Create a new window for a workbook so you can see two sheets from the same workbook at once.
  • Arrange windows so you can see and work with more than one at a time.
  • Close and hide windows to get them out of the way.
  • Change a window's magnification so you can see more of its contents or see its contents more clearly.
  • Split a window so you can see and work with two or more parts of a sheet at a time.

To create a new window

  1. Activate the workbook for which you want to create another window.
  2. Click View > Window > New Window (Figure 29).
    Figure 29

    Figure 29 The View tab's Window group offers commands for working with—you guessed it—windows.

    A new window for that workbook appears (Figure 30) and the new window's name appears at the bottom of the Switch Windows menu (Figure 31).
    Figure 30

    Figure 30 When you open more than one window for a workbook file, the window number appears in the title bar ...

    Figure 31

    Figure 31 ... and both windows are listed on the Switch Windows menu.

To activate another window

Choose the name of the window you want to make active from the list of open windows at the bottom of the Switch Windows menu on the View tab (Figure 31).

To arrange windows

  1. Click View > Window > Arrange All (Figure 29).
  2. In the Arrange Windows dialog that appears (Figure 32), select an Arrange option. Figures 33 through 36 illustrate all of them.
    Figure 32

    Figure 32 The Arrange Windows dialog.

    Figure 33

    Figure 33 Tiled windows.

    Figure 34

    Figure 34 Horizontally arranged windows.

    Figure 35

    Figure 35 Vertically arranged windows.

    Figure 36

    Figure 36 Cascading windows.

  3. To arrange only the windows of the active workbook, turn on the Windows of active workbook check box.
  4. Click OK.

To close a window

Click the window's close button or choose Microsoft Office > Close (Figure 37).

Figure 37

Figure 37 The Microsoft Office menu.

To hide a window

  1. Activate the window you want to hide.
  2. Click View > Window > Hide (Figure 29). The window disappears from your screen and from the Switch Windows menu.

To unhide a window

  1. Click View > Window > Unhide (Figure 29).
  2. In the Unhide dialog that appears (Figure 39), choose the window you want to unhide.
    Figure 39

    Figure 39 Use the Unhide dialog to select the window you want to unhide.

  3. Click OK. The window appears.

To change a window's magnification

  1. Choose View > Zoom > Zoom (Figure 40).
    Figure 40

    Figure 40 The View tab's Zoom group.

  2. In the Zoom dialog that appears (Figure 41), select the option button for the magnification you want.
    Figure 41

    Figure 41 Use the Zoom dialog to set the window's magnification.

  3. Click OK.

    Or

    Drag the slider in the Zoom control on the bottom-right corner of the application window (Figure 42).

    Figure 42

    Figure 42 You can also change the magnification by dragging the slider on the Zoom control.

To split a window

  1. Select the cell immediately below and to the right of where you want the split(s) to occur (Figure 43).
    Figure 43

    Figure 43 Select the cell below and to the right of where you want the split to occur.

  2. Click View > Window > Split (Figure 29). The window splits at the location you specified (Figure 44).
    Figure 44

    Figure 44 When you choose the Split command, the window splits.

Or

  1. Position the mouse pointer on the split bar at the top of the vertical scroll bar or right end of the horizontal scroll bar. The mouse pointer turns into a double line with arrows coming out of it (Figure 45).
    Figure 45

    Figure 45 Position the mouse pointer on the split bar at the end of the scroll bar.

  2. Press the mouse button down and drag. A split bar moves along with the mouse pointer (Figure 46).
    Figure 46

    Figure 46 Drag the split bar into the window.

  3. Release the mouse button. The window splits at the bar (Figure 47).
    Figure 47

    Figure 47 When you release the mouse button, the window splits.

To adjust the size of panes

  1. Position the mouse pointer on a split bar.
  2. Press the mouse button down and drag until the split bar is in the desired position.
  3. Release the mouse button. The window split moves.

To remove a window split

Click View > Window > Split or double-click a split bar.

  • + Share This
  • 🔖 Save To Your Account