Microsoft Excel keyboard shortcuts
Microsoft · 80 shortcuts80 Microsoft Excel shortcuts grouped by task, with Windows and Mac keys side by side. Click any row for the full answer page.
Essentials
| Action | Windows | Mac |
|---|---|---|
| Save workbook | Ctrl+SCtrlS | Cmd+S⌘S |
| Open workbook | Ctrl+OCtrlO | Cmd+O⌘O |
| Close workbook | Ctrl+WCtrlW | Cmd+W⌘W |
| Copy | Ctrl+CCtrlC | Cmd+C⌘C |
| Cut | Ctrl+XCtrlX | Cmd+X⌘X |
| Paste | Ctrl+VCtrlV | Cmd+V⌘V |
| Undo | Ctrl+ZCtrlZ | Cmd+Z⌘Z |
| Redo | Ctrl+YCtrlY | Cmd+Y⌘Y |
| Remove cell contents | DeleteDelete | DeleteDelete |
| Apply bold | Ctrl+BCtrlB | Cmd+B⌘B |
| Select all / entire worksheet | Ctrl+ACtrlA | Cmd+A⌘A |
| Repeat last command | Ctrl+YCtrlY | Cmd+Y⌘Y |
Navigation
| Action | Windows | Mac |
|---|---|---|
| Move one cell up | Up↑ | Up↑ |
| Move one cell down | Down↓ | Down↓ |
| Move one cell left | Left← | Left← |
| Move one cell right | Right→ | Right→ |
| Move to data region edge | Ctrl+Arrow keyCtrlArrow key | Cmd+Arrow key⌘Arrow key |
| Move to last used cell | Ctrl+EndCtrlEnd | Ctrl+End⌃End |
| Extend selection to last used cell | Ctrl+Shift+EndCtrlShiftEnd | Ctrl+Shift+End⌃⇧End |
| Move to worksheet beginning | Ctrl+HomeCtrlHome | Ctrl+Home⌃Home |
| Move down one screen | PgDnPgDn | PgDnPgDn |
| Move up one screen | PgUpPgUp | PgUpPgUp |
| Move right one screen | Alt+PgDnAltPgDn | Option+PgDn⌥PgDn |
| Move left one screen | Alt+PgUpAltPgUp | Option+PgUp⌥PgUp |
| Move to next sheet | Ctrl+PgDnCtrlPgDn | Ctrl+PgDn⌃PgDn |
| Move to previous sheet | Ctrl+PgUpCtrlPgUp | Ctrl+PgUp⌃PgUp |
| Move to next cell | Tab⇥ | Tab⇥ |
| Move to previous cell | Shift+TabShift⇥ | Shift+Tab⇧⇥ |
| Zoom in | Ctrl+Alt+=CtrlAlt= | — |
| Zoom out | Ctrl+Alt+-CtrlAlt- | — |
| Open Go To dialog | F5F5 | — |
Editing
| Action | Windows | Mac |
|---|---|---|
| Edit active cell | F2F2 | F2F2 |
| Insert or edit note | Shift+F2ShiftF2 | Shift+F2⇧F2 |
| Insert threaded comment | Ctrl+Shift+F2CtrlShiftF2 | Cmd+Shift+F2⌘⇧F2 |
| Cancel cell or formula bar entry | EscEsc | EscEsc |
| Complete entry and select cell below | Enter↵ | Enter↵ |
| Complete entry and select cell above | Shift+EnterShift↵ | Shift+Enter⇧↵ |
| Fill selected range with current entry | Ctrl+EnterCtrl↵ | Cmd+Enter⌘↵ |
| Start new line in same cell | Alt+EnterAlt↵ | Option+Enter⌥↵ |
| Turn on extend mode | F8F8 | F8F8 |
| Add non-adjacent cells to selection | Shift+F8ShiftF8 | Shift+F8⇧F8 |
| Select entire column | Ctrl+SpaceCtrlSpace | Ctrl+Space⌃Space |
| Select entire row | Shift+SpaceShiftSpace | Shift+Space⇧Space |
| Check spelling | F7F7 | F7F7 |
| Insert hyperlink | Ctrl+KCtrlK | Cmd+K⌘K |
| Open Paste Special dialog | Ctrl+Alt+VCtrlAltV | Cmd+Option+V⌘⌥V |
Formatting
| Action | Windows | Mac |
|---|---|---|
| Open Format Cells dialog | Ctrl+1Ctrl1 | Cmd+1⌘1 |
| Italicize / remove italic | Ctrl+ICtrlI | Cmd+I⌘I |
| Underline / remove underline | Ctrl+UCtrlU | Cmd+U⌘U |
| Apply / remove strikethrough | Ctrl+5Ctrl5 | — |
| Apply outline border | Ctrl+Shift+&CtrlShift& | Cmd+Option+0⌘⌥0 |
| Remove outline border | Ctrl+Shift+_CtrlShift_ | Cmd+Option+-⌘⌥- |
| Fill Down | Ctrl+DCtrlD | Cmd+D⌘D |
| Apply Currency format (2 decimals) | Ctrl+Shift+$CtrlShift$ | Ctrl+Shift+$⌃⇧$ |
| Apply Percentage format | Ctrl+Shift+%CtrlShift% | Ctrl+Shift+%⌃⇧% |
| Apply Date format | Ctrl+Shift+#CtrlShift# | Ctrl+Shift+#⌃⇧# |
| Apply Time format | Ctrl+Shift+@CtrlShift@ | Ctrl+Shift+@⌃⇧@ |
| Apply Number format (2 decimals, thousands) | Ctrl+Shift+!CtrlShift! | Ctrl+Shift+!⌃⇧! |
| Hide rows | Ctrl+9Ctrl9 | Ctrl+9⌃9 |
| Hide columns | Ctrl+0Ctrl0 | Ctrl+0⌃0 |
| Create Table | Ctrl+LCtrlL | Cmd+T⌘T |
Formulas
| Action | Windows | Mac |
|---|---|---|
| Insert Sum formula | Alt+=Alt= | Cmd+Shift+T⌘⇧T |
| Insert function | Shift+F3ShiftF3 | Shift+F3⇧F3 |
| Cycle absolute/relative references | F4F4 | Cmd+T⌘T |
| Calculate all open workbooks | F9F9 | F9F9 |
| Calculate active worksheet | Shift+F9ShiftF9 | Shift+F9⇧F9 |
| Invoke Flash Fill | Ctrl+ECtrlE | Ctrl+E⌃E |
| Define name | Alt then M then M then DAltthenMthenMthenD | Cmd+L⌘L |
| Insert argument names and parentheses | Ctrl+Shift+ACtrlShiftA | Ctrl+Shift+A⌃⇧A |
| Copy formula from cell above | Ctrl+'Ctrl' | Ctrl+'⌃' |
| Switch formula/value display | Ctrl+`Ctrl` | Ctrl+`⌃` |
| Create chart on separate sheet | F11F11 | F11F11 |
| Create embedded chart | Alt+F1AltF1 | — |
| Open Visual Basic Editor | Alt+F11AltF11 | Option+F11⌥F11 |
Cells & rows
| Action | Windows | Mac |
|---|---|---|
| Open Insert dialog (blank cells) | Ctrl+Shift++CtrlShift+ | Ctrl+Shift+=⌃⇧= |
| Open Delete dialog | Ctrl+-Ctrl- | Cmd+-⌘- |
| Enter current date | Ctrl+;Ctrl; | Ctrl+;⌃; |
| Enter current time | Ctrl+Shift+:CtrlShift: | Cmd+;⌘; |
| Toggle hide objects | Ctrl+6Ctrl6 | Ctrl+6⌃6 |
| Display/hide outline symbols | Ctrl+8Ctrl8 | Ctrl+8⌃8 |
Ask your agent
Prompt
Make me a one-page Microsoft Excel cheat sheet from the 80 shortcuts at https://keyflowhub.com/shortcuts/excel, ordered by what I'm most likely to use, and point out any that clash with my current keybindings.
Paste into Claude Code and it will do the rest.
Questions
Windows: Ctrl + Z. Mac: Cmd + Z.
Windows: Ctrl + Y. Mac: Cmd + Y.
Windows: Ctrl + S. Mac: Cmd + S.
Sources: support.microsoft.com