Microsoft Office Tutorials and References
In Depth Information
Navigating regions with the keyboard
Mode
Description
Add To
Selection
Press Shift+F8 to add more cells to the current selection using the keyboard;
the cells need not be adjacent. After pressing Shift+F8, click any cell or drag
through any range to add it to the selection. This is the keyboard equivalent of
holding down Ctrl and selecting additional cells with the mouse.
Num Lock
This mode keeps your keypad in numeric entry mode. This is turned on by
default, but its status is not usually displayed in the status bar. However, you
can make it do so by right-clicking the status bar anywhere and clicking Num
Lock.
Fixed
Decimal
To add a decimal point to the numeric entries in the current selection, click
the File tab, click Options, select the Advanced category, and select the
Automatically Insert A Decimal Point check box in the Editing Options group.
Excel places the decimal point in the location you specify in the Places box. For
example, when you turn on Fixed Decimal mode, specify two decimal places,
and type the number 12345 in a cell, the value 123.45 appears in the cell after
you press Enter. Existing cell entries are not affected unless you edit them. To
turn off Fixed Decimal mode, return to the Advanced category in the Excel
Options dialog box and clear the Automatically Insert A Decimal Point check
box.
Caps Lock Press the Caps Lock key to type text in capital letters. (This does not affect
number and symbol keys.) To turn off Caps Lock mode, press the Caps Lock
key again. The status of this mode does not usually display in the status bar,
but you can make it do so. Right-click the status bar anywhere, and click Caps
Lock.
Scroll Lock Press Scroll Lock to use the Page Up, Page Down, and arrow keys to move the
viewed portion of the window without moving the active cell. When Scroll
Lock mode is off, the active cell moves one page at a time when you press
Page Up or Page Down and moves one cell at a time when you press one of
the arrow keys. To turn off Scroll Lock mode, press the Scroll Lock key again.
End
Press the End key, and then press an arrow key to move the selection to
the edge of the region in that direction or to the last worksheet cell in that
direction. This mode functions like holding down Ctrl and pressing an arrow
key, except you need to press only one key at a time. To turn off End mode,
press the End key again. End mode is also turned off after you press one of the
arrow keys.
Overtype
Click the formula bar or double-click a cell and press the Insert key to turn on
Overtype mode (formerly known as Overwrite mode). Usually, new characters
you type in the formula bar are inserted between existing characters. With
Overtype mode turned on, the characters you type replace any existing
characters to the right of the insertion point. Overtype mode turns off when
you press Insert again or when you press Enter or one of the arrow keys to
lock in the cell entry. The status of this mode does not usually display in the
status bar, but you can make it do so. Right-click the status bar anywhere, and
click Overtype Mode.
Search JabSto ::




Custom Search