Microsoft Excel Shortcut Keys
Excel
| Shortcut | Action | Menu | |
|---|---|---|---|
| Ctrl+A | Ctrl A | Select All | None |
| Ctrl+B | Ctrl B | Bold | Format Cells Font Font Style Bold |
| Ctrl+C | Ctrl C | Copy | Edit Copy |
| Ctrl+D | Ctrl D | Fill Down | Edit Fill Down |
| Ctrl+F | Ctrl F | Find | Edit Find |
| Ctrl+G | Ctrl G | Goto | Edit Goto |
| Ctrl+H | Ctrl H | Replace | Edit Replace |
| Ctrl+I | Ctrl I | Italic | Format Cells Font Font Style Italic |
| Ctrl+K | Ctrl K | Insert Hyperlink | Insert Hyperlink |
| Ctrl+N | Ctrl N | New Workbook | File New |
| Ctrl+O | Ctrl O | Open | File Open |
| Ctrl+P | Ctrl P | File Print | |
| Ctrl+R | Ctrl R | Fill Right | Edit Fill Right |
| Ctrl+S | Ctrl S | Save | File Save |
| Ctrl+U | Ctrl U | Underline | Format Cells Font Underline Single |
| Ctrl+V | Ctrl V | Paste | Edit Paste |
| Ctrl W | Ctrl W | Close | File Close |
| Ctrl+X | Ctrl X | Cut | Edit Cut |
| Ctrl+Y | Ctrl Y | Repeat | Edit Repeat |
| Ctrl+Z | Ctrl Z | Undo | Edit Undo |
| F1 | F1 | Help | Help Contents and Index |
| F2 | F2 | Edit | None |
| F3 | F3 | Paste Name | Insert Name Paste |
| F4 | F4 | Repeat last action | Edit Repeat. Works while not in Edit mode. |
| F4 | F4 | While typing a formula switch between absolute/relative refs | None |
| F5 | F5 | Goto | Edit Goto |
| F6 | F6 | Next Pane | None |
| F7 | F7 | Spell check | Tools Spelling |
| F8 | F8 | Extend mode | None |
| F9 | F9 | Recalculate all workbooks | Tools Options Calculation Calc,Now |
| F10 | F10 | Activate Menubar | N/A |
| F11 | F11 | New Chart | Insert Chart |
| F12 | F12 | Save As | File Save As |
| Ctrl+: | Ctrl : | Insert Current Time | None |
| Ctrl+; | Ctrl ; | Insert Current Date | None |
| Ctrl+" | Ctrl " | Copy Value from Cell Above | Edit Paste Special Value |
| Ctrl+' | Ctrl ' | Copy Fromula from Cell Above | Edit Copy |
| Shift | Shift | Hold down shift for additional functions in Excel's menu | none |
| Shift+F1 | Shift F1 | What's This? | Help What's This? |
| Shift+F2 | Shift F2 | Edit cell comment | Insert Edit Comments |
| Shift+F3 | Shift F3 | Paste function into formula | Insert Function |
| Shift+F4 | Shift F4 | Find Next | Edit Find Find Next |
| Shift+F5 | Shift F5 | Find | Edit Find Find Next |
| Shift+F6 | Shift F6 | Previous Pane | None |
| Shift+F8 | Shift F8 | Add to selection | None |
| Shift+F9 | Shift F9 | Calculate active worksheet | Calc Sheet |
| Shift+F10 | Shift F10 | Display shortcut menu | None |
| Shift+F11 | Shift F11 | New worksheet | Insert Worksheet |
| Shift+F12 | Shift F12 | Save | File Save |
| Ctrl+F3 | Ctrl F3 | Define name | Insert Names Define |
| Ctrl+F4 | Ctrl F4 | Close | File Close |
| Ctrl+F5 | Ctrl F5 | XL Restore window size | Restore |
| Ctrl+F6 | Ctrl F6 | Next workbook window | Window ... |
| Shift+Ctrl+F6 | Shift Ctrl F6 | Previous workbook window | Window ... |
| Ctrl+F7 | Ctrl F7 | Move window | XL Move |
| Ctrl+F8 | Ctrl F8 | Resize window | XL Size |
| Ctrl+F9 | Ctrl F9 | Minimize workbook | XL Minimize |
| Ctrl+F10 | Ctrl F10 | Maximize or restore window | XL Maximize |
| Ctrl+F11 | Ctrl F11 | Inset 4.0 Macro sheet | None in Excel 97. In versions prior to 97 - Insert Macro 4.0 Macro |
| Ctrl+F12 | Ctrl F12 | File Open | File Open |
| Alt+F1 | Alt F1 | Insert Chart | Insert Chart... |
| Alt+F2 | Alt F2 | Save As | File Save As |
| Alt+F4 | Alt F4 | Exit | File Exit |
| Alt+F8 | Alt F8 | Macro dialog box | Tools Macro Macros in Excel 97 Tools Macros - in earlier versions |
| Alt+F11 | Alt F11 | Visual Basic Editor | Tools Macro Visual Basic Editor |
| Ctrl+Shift+F3 | Ctrl Shift F3 | Create name by using names of row and column labels | Insert Name Create |
| Ctrl+Shift+F6 | Ctrl Shift F6 | Previous Window | Window ... |
| Ctrl+Shift+F12 | Ctrl Shift F12 | File Print | |
| Alt+Shift+F1 | Alt Shift F1 | New worksheet | Insert Worksheet |
| Alt+Shift+F2 | Alt Shift F2 | Save | File Save |
| Alt+= | Alt = | AutoSum | No direct equivalent |
| Ctrl+` | Ctrl ` | Toggle Value/Formula display | Tools Options View Formulas |
| Ctrl+Shift+A | Ctrl Shift A | Insert argument names into formula | No direct equivalent |
| Alt+Down arrow | Alt | Display AutoComplete list | None |
| Alt+' | Alt ' | Format Style dialog box | Format Style |
| Ctrl+Shift+~ | Ctrl Shift ~ | General format | Format Cells Number Category General |
| Ctrl+Shift+! | Ctrl Shift ! | Comma format | Format Cells Number Category Number |
| Ctrl+Shift+@ | Ctrl Shift @ | Time format | Format Cells Number Category Time |
| Ctrl+Shift+# | Ctrl Shift # | Date format | Format Cells Number Category Date |
| Ctrl+Shift+$ | Ctrl Shift $ | Currency format | Format Cells Number Category Currency |
| Ctrl+Shift+% | Ctrl Shift % | Percent format | Format Cells Number Category Percentage |
| Ctrl+Shift+^ | Ctrl Shift ^ | Exponential format | Format Cells Number Category, |
| Ctrl+Shift+& | Ctrl Shift & | Place outline border around selected cells | Format Cells Border |
| Ctrl+Shift+_ | Ctrl Shift _ | Remove outline border | Format Cells Border |
| Ctrl+Shift+* | Ctrl Shift * | Select current region | Edit Goto Special Current Region |
| Ctrl++ | Ctrl + | Insert | Insert (Rows, Columns, or Cells) Depends on selection |
| Ctrl+- | Ctrl - | Delete | Delete (Rows, Columns, or Cells) Depends on selection |
| Ctrl+1 | Ctrl 1 | Format cells dialog box | Format Cells |
| Ctrl+2 | Ctrl 2 | Bold | Format Cells Font Font Style Bold |
| Ctrl+3 | Ctrl 3 | Italic | Format Cells Font Font Style Italic |
| Ctrl+4 | Ctrl 4 | Underline | Format Cells Font Font Style Underline |
| Ctrl+5 | Ctrl 5 | Strikethrough | Format Cells Font Effects Strikethrough |
| Ctrl+6 | Ctrl 6 | Show/Hide objects | Tools Options View Objects Show All/Hide |
| Ctrl+7 | Ctrl 7 | Show/Hide Standard toolbar | View Toolbars Stardard |
| Ctrl+8 | Ctrl 8 | Toggle Outline symbols | None |
| Ctrl+9 | Ctrl 9 | Hide rows | Format Row Hide |
| Ctrl+0 | Ctrl 0 | Hide columns | Format Column Hide |
| Ctrl+Shift+( | Ctrl Shift ( | Unhide rows | Format Row Unhide |
| Ctrl+Shift+) | Ctrl Shift ) | Unhide columns | Format Column Unhide |
| Alt or F10 | Alt / F10 | Activate the menu | None |
| Ctrl+Tab | Ctrl Tab | In toolbar: next toolbar | None |
| Ctrl+Tab | Ctrl Tab | In a workbook: activate next workbook | None |
| Shift+Ctrl+Tab | Shift Ctrl Tab | In toolbar: previous toolbar | None |
| Shift+Ctrl+Tab | Shift Ctrl Tab | In a workbook: activate previous workbook | None |
| Tab | Tab | Next tool | None |
| Shift+Tab | Shift Tab | Previous tool | None |
| Enter | Enter | Do the command | None |
| Shift+Ctrl+F | Shift Ctrl F | Font Drop Down List | Format Cells Font |
| Shift+Ctrl+F+F | Shift Ctrl F F | Font tab of Format Cell Dialog box | Format Cells Font |
| Shift+Ctrl+P | Shift Ctrl P | Point size Drop Down List | Format Cells Font |