The ultimate reference guide for Excel shortcuts. This list includes standard formatting keys, essential navigation tools, and new features introduced in modern versions of Excel (2013/2016/365).
| Shortcut | Action | Menu / Comment | Version |
|---|---|---|---|
| Modern Features (New) | |||
| Ctrl+E | Flash Fill (Auto-fill patterns) | Data > Flash Fill | 2013+ |
| Ctrl+Q | Quick Analysis Tool | Analyze Data instantly | 2013+ |
| Ctrl+T | Create Table | Insert > Table | 2007+ |
| Ctrl+Shift+L | Toggle Filters | Data > Filter | All |
| Alt (Press) | Show Ribbon Key Tips | Navigates menu without mouse | 2007+ |
| Essential Navigation | |||
| Ctrl + Arrow | Jump to edge of data | Selection movement | All |
| Ctrl + Shift + Arrow | Select to edge of data | Selection highlighting | All |
| Ctrl + PgDn | Next Worksheet Tab | Switch sheets | All |
| Ctrl + PgUp | Previous Worksheet Tab | Switch sheets | All |
| Alt + Enter | Insert Line Break (in cell) | Start new line inside a cell | All |
| Complete List (A-Z) | |||
| Ctrl+A | Select All | None | All |
| Ctrl+B | Bold | Format, Cells, Font, Bold | All |
| Ctrl+C | Copy | Edit, Copy | All |
| Ctrl+D | Fill Down | Edit, Fill, Down | All |
| Ctrl+F | Find | Edit, Find | All |
| Ctrl+G | Goto | Edit, Goto | All |
| Ctrl+H | Replace | Edit, Replace | All |
| Ctrl+I | Italic | Format, Cells, Font, Italic | All |
| Ctrl+K | Insert Hyperlink | Insert, Hyperlink | Excel 97+ |
| Ctrl+N | New Workbook | File, New | All |
| Ctrl+O | Open | File, Open | All |
| Ctrl+P | File, Print | All | |
| Ctrl+R | Fill Right | Edit, Fill Right | All |
| Ctrl+S | Save | File, Save | All |
| Ctrl+U | Underline | Format, Cells, Underline | All |
| Ctrl+V | Paste | Edit, Paste | All |
| Ctrl+W | Close | File, Close | Excel 97+ |
| Ctrl+X | Cut | Edit, Cut | All |
| Ctrl+Y | Repeat | Edit, Repeat | All |
| Ctrl+Z | Undo | Edit, Undo | All |
| F1 | Help | Help, Contents | All |
| F2 | Edit | Enters Cell Edit Mode | All |
| F3 | Paste Name | Insert, Name, Paste | All |
| F4 | Repeat last action | Or Toggle Absolute Ref ($) | All |
| F5 | Goto | Edit, Goto | All |
| F6 | Next Pane | None | All |
| F7 | Spell check | Tools, Spelling | All |
| F8 | Extend mode | None | All |
| F9 | Recalculate all | Calc Now | All |
| F10 | Activate Menubar | N/A | All |
| F11 | New Chart | Insert, Chart | All |
| F12 | Save As | File, Save As | All |
| Ctrl+: | Insert Current Time | None | All |
| Ctrl+; | Insert Current Date | None | All |
| Ctrl+" | Copy Value from Cell Above | Edit, Paste Special, Value | All |
| Ctrl+' | Copy Formula from Cell Above | Edit, Copy | All |
| Shift+F1 | What's This? | Help | All |
| Shift+F2 | Edit cell comment | Insert, Edit Comments | All |
| Shift+F3 | Paste function | Insert, Function | All |
| Shift+F4 | Find Next | Edit, Find Next | All |
| Shift+F5 | Find | Edit, Find | All |
| Shift+F6 | Previous Pane | None | All |
| Shift+F8 | Add to selection | None | All |
| Shift+F9 | Calc active sheet | Calc Sheet | All |
| Shift+F10 | Display shortcut menu | Right-click | All |
| Shift+F11 | New worksheet | Insert, Worksheet | All |
| Shift+F12 | Save | File, Save | All |
| Ctrl+F3 | Define name | Insert, Names, Define | All |
| Ctrl+F4 | Close | File, Close | All |
| Ctrl+F5 | Restore window size | Restore | All |
| Ctrl+F6 | Next workbook window | Window... | All |
| Ctrl+F7 | Move window | XL, Move | All |
| Ctrl+F8 | Resize window | XL, Size | All |
| Ctrl+F9 | Minimize workbook | XL, Minimize | All |
| Ctrl+F10 | Maximize/Restore | XL, Maximize | All |
| Ctrl+F11 | Insert 4.0 Macro sheet | Insert, Macro | All |
| Ctrl+F12 | File Open | File, Open | All |
| Alt+F1 | Insert Chart | Insert, Chart | All |
| Alt+F2 | Save As | File, Save As | All |
| Alt+F4 | Exit | File, Exit | All |
| Alt+F8 | Macro dialog box | Tools, Macro | All |
| Alt+F11 | Visual Basic Editor | Tools, Macro, VBE | All |
| Ctrl+Shift+F3 | Create name from labels | Insert, Name, Create | All |
| Ctrl+Shift+F6 | Prev workbook window | Window... | All |
| Ctrl+Shift+F12 | File, Print | All | |
| Alt+Shift+F1 | New worksheet | Insert, Worksheet | All |
| Alt+Shift+F2 | Save | File, Save | All |
| Alt+= | AutoSum | No direct equivalent | All |
| Ctrl+` | Toggle Formulas | View, Formulas | All |
| Ctrl+Shift+A | Insert arg names | No direct equivalent | All |
| Alt+Down arrow | Display AutoComplete | None | All |
| Alt+' | Format Style dialog | Format, Style | All |
| Ctrl+Shift+~ | General format | Format, General | All |
| Ctrl+Shift+! | Comma format | Format, Number | All |
| Ctrl+Shift+@ | Time format | Format, Time | All |
| Ctrl+Shift+# | Date format | Format, Date | All |
| Ctrl+Shift+$ | Currency format | Format, Currency | All |
| Ctrl+Shift+% | Percent format | Format, Percentage | All |
| Ctrl+Shift+^ | Exponential format | Format, Scientific | All |
| Ctrl+Shift+& | Outline border | Format, Border | All |
| Ctrl+Shift+_ | Remove border | Format, Border | All |
| Ctrl+Shift+* | Select current region | Goto, Special, Region | All |
| Ctrl++ | Insert | Insert Row/Col | All |
| Ctrl+- | Delete | Delete Row/Col | All |
| Ctrl+1 | Format cells dialog | Format, Cells | All |
| Ctrl+2 | Bold | Format, Bold | All |
| Ctrl+3 | Italic | Format, Italic | All |
| Ctrl+4 | Underline | Format, Underline | All |
| Ctrl+5 | Strikethrough | Format, Effects | All |
| Ctrl+6 | Show/Hide objects | View, Objects | All |
| Ctrl+7 | Show/Hide Std toolbar | View, Toolbars | All |
| Ctrl+8 | Toggle Outline symbols | None | All |
| Ctrl+9 | Hide rows | Format, Row, Hide | All |
| Ctrl+0 | Hide columns | Format, Column, Hide | All |
| Ctrl+Shift+( | Unhide rows | Format, Row, Unhide | All |
| Ctrl+Shift+) | Unhide columns | Format, Column, Unhide | All |
| Alt or F10 | Activate menu | None | All |
| Ctrl+Tab | Next workbook/toolbar | None | All |
| Shift+Ctrl+Tab | Prev workbook/toolbar | None | All |
| Tab | Next tool/cell | None | All |
| Shift+Tab | Previous tool/cell | None | All |
| Enter | Do command | None | All |
| Shift+Ctrl+F | Font Drop Down | Format, Font | All |
| Shift+Ctrl+P | Point size Drop Down | Format, Font | All |