Data Entry
What It Does | Key(s) |
End cell entry and move down one cell | Enter |
End cell entry and move up one cell | Shift+Enter |
End cell entry and move one cell to right | Tab |
End cell entry and move one cell to left | Shift+Tab |
Cancel an entry you typed | Esc |
Move one character or line left, right, up, or down when entering or editing cell entry | Arrow Key |
Move to beginning of entry | Home |
Fill a cell entry into cells below | Ctrl+D |
Fill a cell entry into cells to right | Ctrl+R |
Fill range with current entry | Ctrl+Enter |
Paste a function into a formula | Shift+F3 |
Insert AutoSum formula | Alt+= (equal sign) |
Start new line in cell entry | Alt+Enter (when typing or editing entry) |
Insert page break | Alt+Enter (when cell, row, or column is selected) |
Insert date | Ctrl+; (semicolon) |
Insert time | Ctrl+: (colon) |
Insert new worksheet | Shift+F11 |
Select entry from a drop-down list of entries already typed in a row or column | Alt+Down Arrow |
Insert hyperlink (for Web-based worksheets) | Ctrl+K |
Formula/Function Entry
What It Does | Key(s) |
Start formula entry | = (equal sign) |
Enter a formula as an array formula | Ctrl+Shift+Enter |
Display Insert Function dialog box when typing or editing a formula | Shift+F3 |
Display Function Arguments dialog box when insertion point is to right of function name in formula | Ctrl+A |
Insert argument names and parentheses when insertion point is to right of function name in formula | Ctrl+Shift+A |
Paste range name into formula | F3 |
Insert AutoSum formula with SUM function | Alt+= (equal sign) |
Copy value from cell above active cell into active cell | Ctrl+Shift+" (quotation mark) |
Copy formula from cell above active cell into active cell | Ctrl+' (apostrophe) |
Toggle display of cell values and formulas | Ctrl+` (single left quotation mark) |
Recalculate all formulas or selected portion of current formula | F9 |
Calculate only the active worksheet | Shift+F9 |
Recalculate all formulas whether or not they have changed since the last calculation | Ctrl+Alt+F9 |
Check all dependent formulas and recalculate all formulas, including those not marked for recalculation | Ctrl+Alt+Shift+F9 |
Selection Keystrokes
What It Does | Key(s) |
Select cell | Arrow Keys |
Name selected range of cells | Ctrl+F3 |
Name range using an entry from a cell in the range | Ctrl+Shift+F3 |
Select entire column | Ctrl+Spacebar |
Select entire row | Shift+Spacebar |
Select entire worksheet | Ctrl+A |
Deselect all but the active cell | Shift+Backspace |
Select all objects on worksheet when an object is selected | Ctrl+Shift+Spacebar |
Toggle between hiding or displaying objects or displaying placeholders for objects | Ctrl+6 |
Select current and next worksheet | Ctrl+Shift+Page Down |
Select current and previous worksheet | Ctrl+Shift+Page Up |
Deselect multiple worksheets | Ctrl+Page Down |