Microsoft Office Tutorials and References
In Depth Information
The Status Bar
A Tour of the Excel
Indicates whether Caps Lock mode is on. When Caps Lock is on,
every letter you type is automatically capitalized. To turn Caps Lock
mode on or off, hit Caps Lock.
Indicates whether Num Lock mode is on. When this mode is on,
you can use the numeric keypad (typically at the right side of your
keyboard) to type in numbers more quickly. When this sign’s off, the
numeric keypad controls cell navigation instead. To turn Num Lock on
or off, press Num Lock.
Indicates whether Scroll Lock mode is on. When it’s on, you can use
the arrow keys to scroll through the worksheet without changing the
active cell. (In other words, you can control your scrollbars by just
using your keyboard.) This feature lets you look at all the information
you have in your worksheet without losing track of the cell you’re
currently in. You can turn Scroll Lock mode on or off by pressing
Indicates when Fixed Decimal mode is on. When this mode is on,
Excel automatically adds a set number of decimal places to the values
you enter in any cell. For example, if you set Excel to use two fixed
decimal places and you type the number 5 into a cell, Excel actually
enters 0.05. This seldom-used featured is handy for speed typists
who need to enter reams of data in a fixed format. You can turn this
feature on or off by selecting File➝Options, choosing the Advanced
section, and then looking under “Editing options” to find the “Auto-
matically insert a decimal point” setting. Once you turn this checkbox
on, you can choose the number of decimal places (the standard
option is two).
Indicates when Overwrite mode is turned on. Overwrite mode
changes how cell edits work. When you edit a cell and Overwrite
mode is on, the new characters that you type overwrite existing
characters (rather than displacing them). You can turn Overwrite mode on
or off by pressing Insert.
Indicates that you’ve pressed End, which is the first key in many
two-key combinations; the next key determines what happens. For
example, hit End and then Home to move to the bottom-right cell in
your worksheet. See Table Table 14-1 for a list of key combinations,
some of which use End.
Macros are automated routines that perform some task in an Excel
spreadsheet. The Macro Recording indicator shows a record button
(which looks like a red circle superimposed on a worksheet) that lets
you start recording a new macro.
Indicates the current Selection mode. You have two options: normal
mode and extended selection . When you press the arrows keys and
extended selection is on, Excel automatically selects all the rows and
columns you cross. Extended selection is a useful keyboard
alternative to dragging your mouse to select swaths of the grid. To turn
extended selection on or off, press F8.
Shows the current page and the total number of pages (as in “Page 1
of 4”). This indicator appears only in Page Layout view (as described
on page 403).