To perform this
action... |
Press... |
To complete a cell
entry and select the cell below |
ENTER
|
To start a new line
in the same cell |
ALT+ENTER
|
To fill the selected
cell range with the current entry |
CTRL+ENTER
|
To complete a cell
entry and select the previous cell above |
SHIFT+ENTER
|
To complete a cell
entry and select the next cell to the right |
TAB
|
To complete a cell
entry and select the previous cell to the left |
SHIFT+TAB
|
To cancel a cell
entry |
ESC
|
To move one
character up, down, left, or right |
Arrow keys
|
To move to the
beginning of the line |
HOME
|
To repeat the last
action |
F4
or CTRL+Y
|
To create names from
row and column labels |
CTRL+SHIFT+F3
|
To fill down
|
CTRL+D
|
To fill to the right
|
CTRL+R
|
To define a name
|
CTRL+F3
|
To insert a
hyperlink |
CTRL+K
|
To enter the date
|
CTRL+;
(semicolon) |
To enter the time
|
CTRL+SHIFT+:
(colon) |
To display a
drop-down list of the values in the current column of a range
|
ALT+DOWN ARROW
|
To undo the last
action |
CTRL+Z
|
To perform this
action... |
Press... |
To start a formula
|
= (equal sign)
|
To move the
insertion point into the Formula Bar when editing in a cell is turned
off |
F2
|
To delete one
character to the left in the Formula Bar |
BACKSPACE
|
To complete a cell
entry from the cell or Formula Bar |
ENTER
|
To enter a formula
as an array formula |
CTRL+SHIFT+ENTER
|
To cancel an entry
in the cell or Formula Bar |
ESC
|
To display the
Insert Function dialog box in a formula |
SHIFT+F3
|
To display the
Function Arguments dialog box when the insertion point is to the right
of a function name in a formula |
CTRL+A
|
To insert the
argument names and parentheses when the insertion point is to the right
of a function name in a formula |
CTRL+SHIFT+A
|
To paste a defined name into a formula |
F3
|
To insert an AutoSum
formula with the SUM function |
ALT+= (equal
sign) |
To copy the value
from the cell above the active cell into the cell or the Formula Bar
|
CTRL+SHIFT+"
(quotation mark) |
To copy a formula
from the cell above the active cell into the cell or the Formula Bar
|
CTRL+'
(apostrophe) |
To alternate between
displaying cell values and displaying formulas |
CTRL+` (single
left quotation mark) |
To calculate all
worksheets in all open workbooks
|
F9
|
To calculate the
active worksheet |
SHIFT+F9
|
To calculate all
worksheets in all open workbooks, regardless of whether they have
changed since the last calculation |
CTRL+ALT+F9
|
To recheck dependent
formulas and then calculate all cells in all open workbooks, including
cells not marked as needing to be calculated |
CTRL+ALT+SHIFT+F9
|
To calculate the
selected portion of a formula |
F9 (To replace the selected portion with the calculated value, press
ENTER
or, for array formulas, CTRL+SHIFT+ENTER) |