| What to do | Shortcuts |
|---|
| Switches to Page Break Preview view | Alt, W, I |
| Switches to Normal view | Alt, W, L |
| Switches to Page Layout view | Alt, W, P |
| Select the visible cells | Alt + ; |
| Start a new line in the same cell | Alt + Enter |
| Select the current range around the active cell | Ctrl + * |
| Select cells directly referenced by formulas | Ctrl + [ |
| Select cells with formulas that refer to active cell | Ctrl + ] |
| Select cells that don't match the formula or static value | Ctrl + \ |
| Select the current data or entire worksheet | Ctrl + A |
| Repeat the last command or action, if possible | Ctrl + Y |
| Undo the last action | Ctrl + Z |
| Fill selected range with the current entry | Ctrl + Enter |
| Select the current data range | Ctrl + Shift + * |
| Select all cells referenced by formulas | Ctrl + Shift + { |
| Select cells with formulas that refer the active cell | Ctrl + Shift + } |
| Select cells that don't match the formula or static value | Ctrl + Shift + | |
| Extend selection up to the first nonblank cell | Ctrl + Shift + ↑ |
| Extend selection down to the last nonblank cell | Ctrl + Shift + ↓ |
| Extend selection left to the first nonblank cell | Ctrl + Shift + ← |
| Extend selection right to the last nonblank cell | Ctrl + Shift + → |
| Extend selection to the current range | Ctrl + Shift + 8 |
| Unhide selected rows | Ctrl + Shift + 9 |
| Select cells with comments | Ctrl + Shift + O |
| Extend selection to the beginning | Ctrl + Shift + Home |
| Select the same cell in the next sheet | Ctrl + Shift + PageDown |
| Select the same cell in the previous sheet | Ctrl + Shift + PageUp |
| Select the current data range or the entire worksheet | Ctrl + Shift + Spacebar |
| Select an entire column in a worksheet | Ctrl + Spacebar |
| Select an entire row in a worksheet | Shift + Spacebar |
| Extend selection by one cell up | Shift + ↑ |
| Extend selection by one cell down | Shift + ↓ |
| Extend selection by one cell left | Shift + ← |
| Extend selection by one cell right | Shift + → |
| Extend selection to non-adjacent cells or ranges | Shift + F8 |
| Select the active cell when multiple cells selected | Shift + Backspace |
| Complete an entry and select the cell above | Shift + Enter |
| Move to the beginning of a row | Home |
| Select additional functions or information | Shift |
| Activate a selected button. | Spacebar |