Microsoft Excel Keyboard Shortcuts
NOTE: These key assignments are for standard US-English keyboards. The mappings may be slightly different on non-US-English keyboards.
Download Your Own Copy of Excel Keyboard Shortcuts.
| Shortcut/Key | Function |
| F1 | Help |
| F1 + Shift | What's This? Help |
| F1 + Alt | Insert Chart Sheet |
| F2 | Edit Mode |
| F2 + Shift | Edit Comment |
| F2 + Alt | Save As... |
| F3 | Past Name Formula |
| F3 + Shift | Paste Function |
| F3 + Ctrl | Define Name |
| F4 | Repeat Action |
| F4 + Shift | Find Again |
| F4 + Ctrl | Close Window |
| F4 + Alt | Quit Excel |
| F5 | Go to |
| F5 + Shift | Find |
| F5 + Ctrl | Restore Window Size |
| F6 | Next Pane |
| F6 + Shift | Previous Pane |
| F6 + Ctrl | Next Workbook |
| F6 + Alt | Switch to VBA |
| F6 + Shift + Ctrl | Previous Workbook |
| F7 | Spell Check |
| F7 + Ctrl | Move Window |
| F8 | Extend Selection |
| F8 + Shift | Add to Selection |
| F8 + Ctrl | Resize Window |
| F8 + Alt | Macro List |
| F9 | Calculate All |
| F9 + Shift | Calculate Worksheet |
| F9 + Ctrl | Minimize Workbook |
| F10 | Activate Menu |
| F10 + Shift | Context Menu |
| F10 + Ctrl | Restore Workbook |
| F11 | New Chart |
| F11 + Shift | New Worksheet |
| F11 + Ctrl | New Macro Sheet |
| F11 + Alt | VB Editor |
| F12 | Save As |
| F12 + Shift | Save |
| F12 + Ctrl | Open |
| F12 + Shift + Ctrl | |
| A + Ctrl | Select All |
| A + Shift + Ctrl | Formula Arguments |
| B + Ctrl | Bold |
| C + Ctrl | Copy |
| D + Ctrl | Fill Down |
| D + Alt | Data Menu |
| E + Alt | Edit Menu |
| F + Ctrl | Find |
| F + Alt | File Menu |
| F + Shift + Ctrl | Font Name |
| G + Ctrl | Goto |
| H + Ctrl | Replace |
| H + Alt | Help Menu |
| I + Ctrl | Italics |
| I + Alt | Insert Menu |
| K + Ctrl | Insert Hyperlink |
| N + Ctrl | New Workbook |
| O + Ctrl | Open Workbook |
| O + Alt | Format Menu |
| O + Shift + Ctrl | Select Comments |
| P + Ctrl | |
| P + Shift + Ctrl | Font Size |
| R + Ctrl | Fill Right |
| S + Ctrl | Save |
| T + Alt | Tools Menu |
| U + Ctrl | Underline |
| V + Ctrl | Paste |
| W + Ctrl | Close Workbook |
| W + Alt | Window Menu |
| X + Ctrl | Cut |
| Y + Ctrl | Repeat Active/Redo |
| Z + Ctrl | Undo |
| `(~) + Ctrl | Toggle Formula View |
| `(~) + Shift + Ctrl | General Format |
| 1( ! ) + Ctrl | Cell Format |
| 1( ! ) + Shift + Ctrl | Number Format |
| 2( @ ) + Ctrl | Toggle Bold |
| 2( @ ) + Shift + Ctrl | Time Format |
| 3(#) + Ctrl | Toggle Italics |
| 3(#) + Shift + Ctrl | Date Format |
| 4($) + Ctrl | Toggle Underline |
| 4($) + Shift + Ctrl | Currency Format |
| 5(%) + Ctrl | Toggle Strikethru |
| 5(%) + Shift + Ctrl | Percent Format |
| 6(^) + Ctrl | Deactivates Drawing Toolbar |
| 6(^) + Shift + Ctrl | Exponent Format |
| 7(&) + Ctrl | Hide Standard Tools Bar |
| 7(&) + Shift + Ctrl | Apply Border |
| 8(*) + Ctrl | Outline |
| 8(*) + Shift + Ctrl | Select Region |
| 9( ( ) + Ctrl | Hide Rows |
| 9( ( ) + Shift + Ctrl | Unhide Rows |
| 0( ) ) + Ctrl | Hide Columns |
| 0( ) ) + Shift + Ctrl | Unhide Columns |
| - + Ctrl | Date Selection |
| - + Alt | Control Menu |
| - + Shift + Ctrl | No Border |
| = (+) | Formula |
| = (+) + Alt | Auto Sum |
| = (+) + Shift + Ctrl | Insert Dialog |
| [ + Ctrl | Direct Dependents |
| [ + Shift + Ctrl | Direct Precedents |
| ] + Ctrl | All Dependents |
| ] + Shift + Ctrl | All Precedents |
| ; (semicolon) + Ctrl | Insert Date |
| ; (semicolon) + Alt | Select Visible Cells |
| ; (semicolon) + Shift + Ctrl | Insert Time |
| ' (apostrophe) + Alt | Style |
| ' (apostrophe) + Shift + Ctrl | Copy Cell Value Above |
| : (colon) + Ctrl | Insert Time |
| / + Ctrl | Select Array |
| / + Shift + Ctrl | Select Array |
| \ + Ctrl | Select Differences |
| \ + Shift + Ctrl | Select Unequal Cells |
| Insert | Insert Mode |
| Insert + Ctrl | Copy |
| Delete | Clear |
| Delete + Ctrl | Delete to End of Line |
| Home | Begin Row |
| Home + Ctrl | Start of Worksheet |
| End | End Row |
| End + Ctrl | End of Worksheet |
| Page Up | Page Up |
| Page Up + Ctrl | Previous Worksheet |
| Page Up + Alt | Left 1 Screen |
| Page Down | Page Down |
| Page Down + Ctrl | Next Worksheet |
| Page Down + Alt | Right 1 Screen |
| Left Arrow | Move Left |
| Left Arrow + Shift | Select Left |
| Left Arrow + Ctrl | Move Left Area |
| Right Arrow | Move Right |
| Right Arrow + Shift | Select Right |
| Right Arrow + Ctrl | Move Right Area |
| Up Arrow | Move Up |
| Up Arrow + Shift | Select Up |
| Up Arrow + Ctrl | Move Up Area |
| Down Arrow | Move Down |
| Down Arrow + Shift | Select Down |
| Down Arrow + Ctrl | Move Down Area |
| Down Arrow + Alt | Drop Down Menu |
| Space Bar | Space |
| Space Bar + Shift | Select Row |
| Space Bar + Ctrl | Select Column |
| Space Bar + Alt | Control Box |
| Space Bar + Shift + Ctrl | Select All |
| Tab | Move Right |
| Tab + Shift | Move Left |
| Tab + Ctrl | Next Window |
| Tab + Alt | Next Application |
| Tab + Shift + Alt | Previous Application |
| Tab + Shift + Ctrl | Previous Window |
| Backspace + Ctrl | Goto Active Cell |
Download Your Own Copy of Excel Keyboard Shortcuts.
Back to Top| sign up for our newsletter |
|
Want to order our products? |
|
- Other Excel Tutorials
- How to Print Gridlines
- How to use Goal Seek Feature
- Microsoft Word Tutorials
- Microsoft Word Keyboard Shortcuts
