Microsoft Office Tutorials and References
In Depth Information
The Status Bar
A Tour of the Excel
In the status bar, you can
see the basic status text
(which just says “Ready”
in this example), the view
buttons (which are useful
when you’re preparing a
spreadsheet for printing),
and the zoom slider bar
(which lets you enlarge
or shrink the current
Record a macro
The status bar combines several different types of information. The leftmost part of
the status bar shows the Cell Mode, which displays one of three indicators:
• The word “Ready” means that Excel isn’t doing anything much at the moment,
other than waiting for you to take some action.
• The word “Enter” appears when you start typing a new value into a cell.
• The word “Edit” means the cell is currently in edit mode, and pressing the left
and right arrow keys moves through the cell data, instead of moving from cell
to cell. As discussed on page 357, you can place a cell in edit mode or take it out
of edit mode by pressing F2.
Just to the right of the Cell Mode information, you may see a small button that lets
you start recording a macro. (A macro is a series of steps you can replay as often
as you need to automate tiresome chores; they’re typically created by Excel jockeys
who, for example, design corporate expense report forms.)
Farther to the right on the status bar are the view buttons, which let you switch to
Page Layout View or Page Break Preview. These different views help you see what
your worksheet will look like when you print it. They’re covered later in this chapter,
starting on page 403.
The zoom slider is next to the view buttons, at the far right edge of the status bar. You
can slide it to the left to zoom out (which fits more information into your Excel
window at once) or slide it to the right to zoom in (and take a closer look at fewer cells).
In addition, the status bar displays other miscellaneous indicators. For example, if
you press the Scroll Lock key, a Scroll Lock indicator appears on the status bar (next
to the “Ready” text). This indicator tells you that you’re in scroll mode . In scroll
mode, the arrow keys don’t move you from one cell to another; instead, they scroll
the entire worksheet up, down, or to the side. Scroll mode is a great way to check out
another part of your spreadsheet without leaving your current position.