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 |