Microsoft Office Tutorials and References
In Depth Information
Working with Excel windows
Working with Excel windows
Each Excel workbook fi le that you open is displayed in a window. A workbook can hold any
number of sheets, and these sheets can be either worksheets (sheets consisting of rows and
columns) or chart sheets (sheets that hold a single chart). A worksheet is what people
usually think of when they think of a spreadsheet. You can open as many Excel workbooks as
necessary at the same time.
In previous versions of Excel, you could open multiple workbooks and have them displayed in a single Excel window.
With Excel 2013, you no longer have that option. An Excel 2013 window holds only one workbook. If you create or
open a second workbook, it appears in a separate window.
Each Excel window has fi ve buttons (which appear as icons) at the right side of its title bar.
From left to right, they are Help, Full Screen Mode (or Exit Full Screen Mode), Minimize,
Maximize (or Restore Down), and Close.
An Excel window can be in one of the following states:
Maximized: Fills the entire screen. To maximize a window, click its Maximize
Minimized: Hidden, but still open. To minimize a window, click its Minimize
Restored: A nonmaximized size. To restore a maximized window, click its Restore
Down button. To restore a minimized window, click its icon in the Windows taskbar.
A window in this state can be resized and moved.
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 or resize a window, make sure that it’s not maximized (click the Restore Down
button). Then drag its title bar with your mouse.
To resize a window, 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-headed arrow, which lets you know that you can now drag to resize the window. To
resize a window horizontally and vertically at the same time, drag any of its corners.
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
Arrange All displays the Arrange Windows dialog box, shown in
Figure 14.1. 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.
Search JabSto ::

Custom Search