|
To |
Press |
|
Start a formula |
= (EQUAL SIGN) |
|
Insert the AutoSum formula |
ALT-= (EQUAL SIGN) |
|
Display the Formula Palette (after you type a valid function name in a
formula) |
CTRL-A |
|
Insert the argument names and parentheses for a function (after you
type a valid function name in a formula) |
CTRL-SHIFT-A |
|
Paste a name into a formula |
F3 |
|
Insert the current date |
CTRL-; (SEMICOLON) |
|
Insert the current time |
CTRL-SHIFT-: (COLON) |
|
Insert a hyperlink |
CTRL-K |
|
Copy a formula from the cell above the active cell into the cell or the
formula bar |
CTRL-' (APOSTROPHE) |
|
Copy the value from the cell above the active cell into the cell or the
formula bar |
CTRL-SHIFT-" (QUOTATION MARK) |
|
Display the AutoComplete list |
ALT-DOWN ARROW |
|
Start a new line in the same cell |
ALT-ENTER |
|
Delete the character to the left of the insertion point, or delete the
selection |
BACKSPACE |
|
Complete a cell entry |
ENTER |
|
Cancel a cell entry |
ESC |
|
Enter a formula as an array formula |
CTRL-SHIFT-ENTER |
|
Complete a cell entry and move down in a selected range of cells |
ENTER |
|
Complete a cell entry and move up in a selected range of cells |
SHIFT-ENTER |
|
Complete a cell entry and move to the right in a selected range of
cells |
TAB |
|
Complete a cell entry and move to the left in a selected range of cells |
SHIFT-TAB |
|
Complete a cell entry and move up, down, left, or right |
UP, DOWN, LEFT, OR RIGHT ARROW |
|
Fill down (in a selected range of cells) |
CTRL-D |
|
Fill to the right (in a selected range of cells) |
CTRL-R |
|
Fill the selected cell range with the current entry |
CTRL-ENTER |
