Microsoft Office Tutorials and References
In Depth Information
Using the workbook window
proportionally smaller, giving you immediate feedback about the size of the
worksheet. A tiny scroll thumb indicates a huge worksheet.
Using the scroll arrows at either end of the scroll bars, you can move through the
worksheet one column or row at a time.
The Name box at the left end of the formula bar always displays the active cell
reference, regardless of where you scroll the window.
To scroll the worksheet without changing the active cell, press Scroll Lock. For
example, to scroll to the right one full screen without moving the active cell, press Scroll
Lock and then press Ctrl+Right Arrow.
The active area of a worksheet is simply the rectangular area that encompasses all the
data the worksheet contains. So, if you have just three rows and columns of actual data
in the top-left corner of the worksheet, the active area would be A1:C3. If, on the same
worksheet, a stray character (even a space) happens to be in cell AB1299, the active
area would be A1:AB1299. On a new blank worksheet, however, Excel considers the
default active area to be roughly what you can see on the screen, even before you enter
Working with workbook windows
In Excel 2013, workbook windows behave differently than in any previous version.
Previously, there was one Excel window that contained all open worksheets, which appeared as
separate windows within the Excel workspace . (Even the term “workspace” has been retired
for 2013.) Each workbook appears as a separate instance of Excel in the 2013 version. If you
have three workbooks open, there will be three windows, each with a complete Excel
interface, including ribbon tabs, a formula bar, a status bar, and other such items.
So workbook windows now behave like any other windows in Windows. At the right end
of each title bar are the familiar Minimize, Maximize/Restore, and Close buttons. After you
maximize a window, a button with two small boxes—the Restore button—takes the place
of the Maximize button. Clicking the Restore button changes the maximized window into a