| Select the first visible cell in the sheet (or bottom-right of freeze panes) | Ctrl+Home | Fn+Ctrl+← |
| Select the last used cell in the sheet | Ctrl+End | Fn+Ctrl+→ |
| Select first cell in the row of the active cell | Home | Fn+← |
| Turn on End Mode (similar to Ctrl+Arrow Keys) | End | Fn+→ |
| Select the first/last cell of a region (non-blank cells) moving up | Ctrl+↑ | Ctrl+↑ |
| Select the first/last cell of a region (non-blank cells) moving right | Ctrl+→ | Ctrl+→ |
| Select the first/last cell of a region (non-blank cells) moving down | Ctrl+↓ | Ctrl+↓ |
| Select the first/last cell of a region (non-blank cells) moving left | Ctrl+← | Ctrl+← |
| Select cell one screen down from the active cell | PgDn | Fn+↓ |
| Select cell one screen up from the active cell | PgUp | Fn+↑ |
| Select cell one screen to the right of the active cell | Alt+PgDn | Fn+Alt+↓ |
| Select cell one screen to the left of the active cell | Alt+PgUp | Fn+Alt+↑ |
| Move one cell up | ↑ | ↑ |
| Move one cell right | → | → |
| Move one cell down | ↓ | ↓ |
| Move one cell left | ← | ← |
| Go back to hyperlink | Ctrl+G,Enter | Ctrl+G,Return |
| Open the Find window | Ctrl+F | Cmd+F |
| Open the Find & Replace window | Ctrl+H | Ctrl+H |
| Find next match | Shift+F4 | Cmd+G |
| Find previous match | Ctrl+Shift+F4 | Cmd+Shift+G |
| Begin entering a formula | = OR + | = OR + |
| Insert function into formula with autocomplete | Tab | ↓Tab |
| Edit the active cell | F2 | Ctrl+U |
| Toggle Enter and Edit modes while editing formula | F2 | Ctrl+U |
| Exit cell edit mode | Esc | Esc |
| Toggle absolute and relative references | F4 | Cmd+T |
| AutoSum | Alt+= | Cmd+Shift+T |
| Open Function Arguments window | Ctrl+A | Ctrl+A |
| Open the Insert Function window | Shift+F3 | Fn+Shift+F3 |
| Show Formulas instead of Values in cells (toggle) | Ctrl+` or Ctrl+~ | Ctrl+` |
| Expand or collapse the formula bar | Ctrl+Shift+U | Ctrl+Shift+U |
| Calculate worksheets | F9 | Fn+F9 |
| Calculate active worksheet | Shift+F9 | Fn+Shift+F9 |
| Calculate entire workbook | Ctrl+Alt+F9 | |
| Insert name into formula | F3 | |
| Open Name Manager window | Ctrl+F3 | Fn+Ctrl+F3 |
| Open Create Names From Selection window | Ctrl+Shift+F3 | Fn+Ctrl+Shift+F3 |
| Set focus on Name Box | Alt+F3 | |
| Enter array formula | Ctrl+Shift+Enter | Ctrl+Shift+Return |
| Evaluate selected text in a formula | F9 | Fn+F9 |
| Insert function arguments | Ctrl+Shift+A | Ctrl+Shift+A |
| Open AutoComplete dropdown list | Alt+↓ | Alt+↓ |
| Enter and move to next cell | Enter | Return |
| Enter and move to previous cell | Shift+Enter | Shift+Return |
| Enter and move right | Tab | Tab |
| Enter and move left | Shift+Tab | Shift+Tab |
| Insert current date | Ctrl+; | Ctrl+; |
| Insert current time | Ctrl+Shift+: | Cmd+; |
| Copy formula from cell above | Ctrl+’ | Ctrl+’ |
| Fill down from cell above | Ctrl+D | Ctrl+D |
| Fill right | Ctrl+R | Ctrl+R |
| Flash fill | Ctrl+E | |
| Stay in same cell when editing | Ctrl+Enter | Ctrl+Return |
| Copy value (result of formula) from cell above | Ctrl+Shift+" | Ctrl+Shift+" |