Excel Keyboard Shortcuts: The Complete List
Organised by task — navigation, selection, editing, formatting, formulas, and data tools. Windows and Mac versions side by side. Bookmark this page.
Learn These 8 First
Navigation
| Windows | Mac | Action |
|---|---|---|
| Ctrl + Home | Cmd + Home | Go to cell A1 |
| Ctrl + End | Cmd + End | Go to last used cell in the sheet |
| Ctrl + Arrow | Cmd + Arrow | Jump to last non-blank cell in direction |
| Ctrl + G | Cmd + G | Go To dialog (then Special for errors, blanks, etc.) |
| Ctrl + F | Cmd + F | Find |
| Ctrl + H | Cmd + H | Find and Replace |
| Ctrl + Page Down/Up | Fn + Ctrl + ↓/↑ | Move to next / previous sheet |
Selection
| Windows | Mac | Action |
|---|---|---|
| Ctrl + Shift + Arrow | Cmd + Shift + Arrow | Extend selection to last non-blank cell |
| Ctrl + Shift + End | Cmd + Shift + End | Select from current cell to last used cell |
| Ctrl + Space | Ctrl + Space | Select entire column |
| Shift + Space | Shift + Space | Select entire row |
| Ctrl + A | Cmd + A | Select all (press twice to select entire sheet) |
| Ctrl + Shift + L | Cmd + Shift + F | Toggle AutoFilter on/off |
Editing
| Windows | Mac | Action |
|---|---|---|
| F2 | Ctrl + U | Edit the active cell (enter edit mode) |
| Ctrl + D | Cmd + D | Fill Down (copy formula from cell above) |
| Ctrl + R | Cmd + R | Fill Right (copy formula from cell to the left) |
| Ctrl + Enter | Ctrl + Return | Confirm entry and stay in the same cell |
| Ctrl + Z | Cmd + Z | Undo |
| Ctrl + Y | Cmd + Y | Redo |
| F4 | Cmd + T | Repeat last action (outside formula) / toggle $A$1 locking (in formula) |
| Delete | Delete / Fn+Delete | Clear cell contents (not formatting) |
| Ctrl + - | Cmd + - | Delete rows or columns (after selecting them) |
| Ctrl + Shift + + | Cmd + Shift + + | Insert rows or columns |
Formatting
| Windows | Mac | Action |
|---|---|---|
| Ctrl + 1 | Cmd + 1 | Format Cells dialog (all formatting options) |
| Ctrl + B | Cmd + B | Bold |
| Ctrl + I | Cmd + I | Italic |
| Ctrl + U | Cmd + U | Underline |
| Ctrl + Shift + $ | Cmd + Shift + $ | Currency format |
| Ctrl + Shift + % | Cmd + Shift + % | Percentage format |
| Ctrl + Shift + # | Cmd + Shift + # | Date format (dd-mmm-yy) |
| Ctrl + Shift + ~ | Cmd + Shift + ~ | General format (remove all number formatting) |
| Alt + H + H | — | Fill colour picker (ribbon shortcut) |
Formulas
| Windows | Mac | Action |
|---|---|---|
| Alt + = | Cmd + Shift + T | AutoSum (inserts =SUM() for the range above) |
| F4 | Cmd + T | Toggle reference locking ($A$1 → A$1 → $A1 → A1) |
| Ctrl + ` | Ctrl + ` | Toggle between formula view and value view |
| Ctrl + [ | Cmd + [ | Select all cells that the active formula references |
| Ctrl + Shift + Enter | Cmd + Shift + Return | Enter as legacy array formula (Excel 2019 and older) |
| Ctrl + Shift + A | Ctrl + Shift + A | Insert function arguments (after typing function name) |
| F9 | F9 | Recalculate all formulas (or evaluate selected part of formula) |
Data and Tables
| Windows | Mac | Action |
|---|---|---|
| Ctrl + T | Cmd + T | Create Excel Table from selection |
| Ctrl + ; | Ctrl + ; | Insert today's date (static) |
| Ctrl + Shift + : | Cmd + ; | Insert current time (static) |
| Alt + D + S | — | Sort dialog |
| Alt + A + M | — | Remove duplicates dialog |
| Ctrl + Shift + F3 | Cmd + Shift + F3 | Create named ranges from selection labels |
| Alt + F5 | — | Refresh all Power Query / pivot table connections |
Workbook and Sheets
| Windows | Mac | Action |
|---|---|---|
| Ctrl + N | Cmd + N | New workbook |
| Ctrl + S | Cmd + S | Save |
| Ctrl + W | Cmd + W | Close workbook |
| Ctrl + P | Cmd + P | Print dialog |
| F12 | Cmd + Shift + S | Save As |
| Shift + F11 | Fn + Shift + F11 | Insert new sheet |
| Alt + F11 | Fn + Alt + F11 | Open VBA editor |
| Ctrl + F4 | Cmd + W | Close active workbook window |
Frequently Asked Questions
What are the most important Excel shortcuts to learn first?
Ctrl+T (table), Ctrl+Shift+L (filters), Ctrl+D (fill down), F4 (toggle locking/repeat), Alt+= (AutoSum), Ctrl+1 (format cells), Ctrl+; (today's date), Ctrl+` (formula view). These 8 cover the most repetitive daily tasks.
How do I see all Excel shortcuts?
Press Alt in Excel — every ribbon tab shows a letter key overlay. Press the letter to open that tab, then the letter shown on the button you want. Works for every ribbon command.
Related Guides
Excel Formulas Hub
The formulas behind the shortcuts — XLOOKUP, SUMIFS, IF, and more.
Read →
Excel Tables Guide
Ctrl+T is the most underused shortcut — learn what it unlocks.
Read →
Best Excel Tools
Add-ins that add even more shortcuts and automation to Excel.
Read →
Excel and AI
AI tools that write formulas so you spend less time typing them.
Read →