Not all 500+ Excel shortcuts matter. Here are the ones that genuinely save time, organized by what you're trying to do.
This is every shortcut worth actually memorizing — not the full official list of 500+, just the ones that save real time every day. Windows shortcut shown first; Mac in parentheses where it differs.
| Action | Shortcut |
|---|---|
| Jump to the edge of your data | Ctrl + Arrow key (⌘ + Arrow) |
| Jump to cell A1 | Ctrl + Home (⌘ + Home) |
| Jump to the last used cell | Ctrl + End (⌘ + End) |
| Go to a specific cell | Ctrl + G or F5 |
| Switch between open workbooks | Ctrl + Tab |
| Move to next worksheet tab | Ctrl + Page Down |
| Action | Shortcut |
|---|---|
| Select to the edge of your data | Ctrl + Shift + Arrow |
| Select the entire column | Ctrl + Space |
| Select the entire row | Shift + Space |
| Select the whole sheet | Ctrl + A |
| Select only visible cells (skip hidden rows) | Alt + ; |
If you've filtered a list and then copy-paste normally, Excel secretly includes the hidden filtered-out rows too. Alt + ; selects only what you can actually see — the fix for one of the most common silent copy-paste mistakes.
| Action | Shortcut |
|---|---|
| Edit the active cell | F2 |
| Confirm entry and move down | Enter |
| Confirm entry and move right | Tab |
| Add a line break inside a cell | Alt + Enter (Ctrl + Option + Enter) |
| Fill down from the cell above | Ctrl + D |
| Fill right from the cell to the left | Ctrl + R |
| Undo | Ctrl + Z |
| Redo | Ctrl + Y |
| Repeat your last action | F4 |
| Action | Shortcut |
|---|---|
| Insert the SUM function automatically | Alt + = |
| Show formulas instead of results | Ctrl + ` |
| Toggle absolute/relative reference ($) | F4 while editing a formula |
| Recalculate the whole workbook | F9 |
| Enter an array formula | Ctrl + Shift + Enter |
Press F4 while typing a cell reference inside a formula to cycle through $A$1, A$1, $A1, and A1 — no manually typing dollar signs ever again.
| Action | Shortcut |
|---|---|
| Bold | Ctrl + B |
| Italic | Ctrl + I |
| Open the Format Cells dialog | Ctrl + 1 |
| Apply currency format | Ctrl + Shift + 4 |
| Apply percentage format | Ctrl + Shift + 5 |
| Add or remove a border around the selection | Ctrl + Shift + 7 |
| Action | Shortcut |
|---|---|
| Insert a new row or column | Ctrl + Shift + + |
| Delete the selected row or column | Ctrl + - |
| Insert a new worksheet | Shift + F11 |
| Hide the selected rows | Ctrl + 9 |
| Unhide rows | Ctrl + Shift + 9 |
If you only learn five shortcuts from this entire page, make it these — they come up constantly, in almost every spreadsheet task:
ExcelPro has 700+ real exercises across 7 career tracks — type actual formulas, get instant feedback, no videos.
Start practising free →