Speed in Excel is mostly about not reaching for the mouse. You do not need every shortcut; learn the groups below a few at a time, and use them until they become habit. These are for Excel on Windows; Mac versions usually use Cmd instead of Ctrl.
Moving around
| Shortcut | Action |
|---|
| Ctrl + Arrow key | Jump to the edge of the data in that direction |
| Ctrl + Home / Ctrl + End | Go to the first cell / last used cell |
| Ctrl + Page Up / Page Down | Previous / next sheet |
| Ctrl + G (or F5) | Go to a cell or named range |
Selecting
| Shortcut | Action |
|---|
| Ctrl + Shift + Arrow | Select to the edge of the data |
| Ctrl + A | Select the current region (press again for the whole sheet) |
| Shift + Space | Select the row |
| Ctrl + Space | Select the column |
Editing
| Shortcut | Action |
|---|
| F2 | Edit the active cell |
| Ctrl + D | Fill down from the cell above |
| Ctrl + R | Fill right |
| Ctrl + Enter | Enter the same value in all selected cells |
| Ctrl + ; | Insert today's date |
| Ctrl + Z / Ctrl + Y | Undo / redo |
| Ctrl + E | Flash Fill |
| Ctrl + Plus / Ctrl + Minus | Insert / delete cells, rows or columns |
| Shortcut | Action |
|---|
| Alt + = | AutoSum |
| F4 | Cycle absolute and relative references while editing |
| Ctrl + ` (backtick) | Show formulas instead of results |
| Shift + F3 | Insert function dialog |
| Shortcut | Action |
|---|
| Ctrl + 1 | Format Cells dialog |
| Ctrl + B / I / U | Bold / italic / underline |
| Ctrl + Shift + 1 | Number format with separators |
| Ctrl + Shift + 5 | Percentage format |
| Ctrl + Shift + 4 | Currency format |
Tables, filters and data
| Shortcut | Action |
|---|
| Ctrl + T | Convert range to a Table |
| Ctrl + Shift + L | Turn filters on or off |
| Alt + Down Arrow | Open the filter menu of the current header |
| Alt, A, M | Remove Duplicates |
| Alt, A, E | Text to Columns |
Pivot tables and charts
| Shortcut | Action |
|---|
| Alt, N, V | Insert PivotTable |
| Alt + F5 / Ctrl + Alt + F5 | Refresh the pivot / refresh all |
| Alt + F1 | Insert a chart from the selection on the same sheet |
| F11 | Insert a chart on a new sheet |
Ribbon keys
Press Alt alone and letters appear on the ribbon. Follow them to reach any command without the mouse; shortcuts like Alt, A, M above come from this system.
How to learn them
- Pick five shortcuts this week, for example Ctrl + Arrow, Ctrl + Shift + Arrow, Ctrl + T, Ctrl + Shift + L and Alt + =.
- Use them deliberately until they feel natural.
- Add five more next week.
Shortcuts help most when combined with good formulas and clean data; see Excel formulas for analysts and Excel data cleaning.