Basic editing
| Shortcut | What it does |
|---|---|
| Ctrl+C | Copy |
| Ctrl+X | Cut |
| Ctrl+V | Paste |
| Ctrl+Z | Undo |
| Ctrl+Y | Redo |
| Ctrl+S | Save |
| F12 | Save As |
| Ctrl+P | |
| Ctrl+F | Find |
| Ctrl+H | Find and replace |
| F2 | Edit the active cell |
| Alt+Enter | Start a new line inside a cell |
Formatting
| Shortcut | What it does |
|---|---|
| Ctrl+B | Bold |
| Ctrl+I | Italic |
| Ctrl+U | Underline |
| Ctrl+1 | Open Format Cells |
| Ctrl+Shift+% | Percent format |
| Ctrl+Shift+$ | Currency format |
| Ctrl+Shift+L | Turn filters on or off |
| Ctrl+T | Create a table |
Navigation and selection
| Shortcut | What it does |
|---|---|
| Ctrl+Arrow keys | Jump to the edge of data |
| Ctrl+Home | Go to cell A1 |
| Ctrl+End | Go to the last used cell |
| Ctrl+A | Select all |
| Ctrl+Space | Select the whole column |
| Shift+Space | Select the whole row |
| Ctrl+Page Down | Next worksheet |
| Ctrl+Page Up | Previous worksheet |
| Ctrl+G or F5 | Go To a cell |
Formulas and data
| Shortcut | What it does |
|---|---|
| Alt+= | AutoSum |
| F4 | Switch between relative and absolute references |
| Ctrl+; | Insert today's date |
| Ctrl+Shift+; | Insert the current time |
| Ctrl+D | Fill down |
| Ctrl+R | Fill right |
| Ctrl+9 | Hide the selected rows |
| Ctrl+0 | Hide the selected columns |
