Press

To

BACKSPACE

Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents

ENTER

Complete a cell entry

CTRL+SHIFT+ENTER

Enter a formula as an array formula

ESC

Cancel an entry in the cell or formula bar

CTRL+A

Display the Formula Palette after you type a function name in a formula

CTRL+SHIFT+A

Insert the argument names and parentheses for a function after you type a function name in a formula

CTRL+K

Insert a hyperlink

ENTER (in cell w/hyperlink)

Activate a hyperlink

F2

Edit the active cell and position the insertion point at the end of the line

F3

Paste a defined name into a formula

SHIFT+F3

Paste a function into a formula

F9

Calculate all sheets in all open workbooks

CTRL+ALT+F9

Calculate all sheets in the active workbook

SHIFT+F9

Calculate the active worksheet

= (equal sign)

Start a formula

ALT+= (equal sign)

Insert the AutoSum formula

CTRL+; (semicolon)

Enter the date

CTRL+SHIFT+: (colon)

Enter the time

CTRL+SHIFT+" (quotation mark)

Copy the value from the cell above the active cell into the cell or the formula bar

CTRL+` (single left quotation mark)

Alternate between displaying cell values and displaying cell formulas

CTRL+' (apostrophe)

Copy a formula from the cell above the active cell into the cell or the formula bar

ALT+DOWN ARROW

Display the AutoComplete list