Excel • 10 min read
50 Excel Shortcuts Every Pro Uses
The keystrokes that separate amateurs from Excel experts.
Table of contents
Editing
- F2 — edit the active cell.
- Ctrl+D — fill down.
- Ctrl+R — fill right.
- Ctrl+Z / Ctrl+Y — undo / redo.
- Ctrl+; — insert today's date.
- Ctrl+Shift+; — insert current time.
- Alt+Enter — new line inside a cell.
Formulas
- = — start a formula.
- F4 — cycle absolute/relative references.
- Alt+= — AutoSum.
- Ctrl+Shift+Enter — array formula (older Excel).
- F9 — evaluate selected part of a formula.
Formatting
- Ctrl+B/I/U — bold/italic/underline.
- Ctrl+1 — Format Cells dialog.
- Ctrl+Shift+$ — currency format.
- Ctrl+Shift+% — percent format.
- Ctrl+Shift+# — date format.