Excel 2010 Bible

Chapter 3: Essential Worksheet Operations

51

l (^) Maximized: Fills the entire Excel workspace. A maximized window doesn’t have a title
bar, and the workbook’s name appears in the title bar for Excel. To maximize a window,
click its Maximize button.
l Minimized: Appears as a small window with only a title bar. To minimize a window, click
its Minimize button.
l Restored: A nonmaximized size. To restore a maximized or minimized window, click its
Restore button.
If you work with more than one workbook simultaneously (which is quite common), you need to
know how to move, resize, and switch among the workbook windows.

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.

Note
You can’t move or resize a workbook window if it’s maximized. You can move a minimized window, but doing
so has no effect on its position when it’s subsequently restored. n

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 3.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 command.

FIGURE 3.2

Use the Arrange Windows dialog box to quickly arrange all open non-minimized workbook windows.