Knowing these excel shortcuts takes you a long way in saving your valuable time while working with MS Excel.
| Key | Alone | Shift | Ctrl | Alt | Shift + Ctrl |
| F1 | Help | What’s This Help | – | Insert Chart Sheet | – |
| F2 | Edit Mode | Edit Comment | – | Save As | – |
| F3 | Paste Name Formula | Paste Function | Define Name | – | Names From Labels |
| F4 | Repeat Action | Find Again | Close Window | Quit Excel | – |
| F5 | Goto | Find | Restore Window Size | – | – |
| F6 | Next Pane | Prev Pane | Next Workbook | Switch To VBA | Prev Workbook |
| F7 | Spell Check | – | Move Window | – | – |
| F8 | Extend Selection | Add To Selection | Resize Window | Macro List | – |
| F9 | Calculate All | Calculate Worksheet | Minimize Workbook | – | – |
| F10 | Activate Menu | Context Menu | Restore Workbook | – | – |
| F11 | New Chart | New Worksheet | New Macro Sheet | VB Editor | – |
| F12 | Save As | Save | Open | – | |
| A | – | – | Select All | – | Formula Arguments |
| B | – | – | Bold | – | – |
| C | – | – | Copy | – | – |
| D | – | – | Fill Down | Data Menu | – |
| E | – | – | – | Edit Menu | – |
| F | – | – | Find | File Menu | Font Name |
| G | – | – | Goto | – | – |
| H | – | – | Replace | Help Menu | – |
| I | – | – | Italics | Insert Menu | – |
| J | – | – | – | – | – |
| K | – | – | Insert Hyperlink | – | – |
| L | – | – | – | – | – |
| M | – | – | – | – | – |
| N | – | – | New Workbook | – | – |
| O | – | – | Open Workbook | Format Menu | Select Comments |
| P | – | – | – | Font Size | |
| Q | – | – | – | – | – |
| R | – | – | Fill Right | – | – |
| S | – | – | Save | – | – |
| T | – | – | – | Tools Menu | – |
| U | – | – | Underline | – | – |
| V | – | – | Paste | – | – |
| W | – | – | Close Workbook | Window Menu | – |
| X | – | – | Cut | – | – |
| Y | – | – | Repeat Active | – | – |
| Z | – | – | Undo | – | – |
| ` (~) | – | – | Toggle Formula View | – | General Format |
| 1 (!) | – | – | Cell Format | – | Number Format |
| 2 (@) | – | – | Toggle Bold | – | Time Format |
| 3 (#) | – | – | Toggle Italics | – | Date Format |
| 4 ($) | – | – | Toggle Underline | – | Currency Format |
| 5 (%) | – | – | Toggle Strikethru | – | Percent Format |
| 6 (^) | – | – | Toggle between | – | Exponent Format |
| 7 (&) | – | – | Toggle Standard tool bar | – | Apply Border |
| 8 (*) | – | – | Outline | – | Select Region |
| 9 (() | – | – | Hide Rows | – | Unhide Rows |
| 0 ()) | – | – | Hide Columns | – | Unhide Columns |
| – | – | – | Delete Selection | Control Menu | No Border |
| = (+) | Formula | – | – | Auto Sum | Insert dialog |
| [ | – | – | Direct Dependents | – | Direct Precedents |
| ] | – | – | All Dependents | – | All Precedents |
| ; (semicolon) | – | – | Insert Date | Select Visible Cells | Insert Time |
| ‘ (apostrophe) | – | – | – | Style | Copy Cell Value Above |
| : (colon) | – | – | Insert Time | – | – |
| / | – | – | Select Array | – | Select Array |
| \ | – | – | Select Differences | – | Select Unequal Cells |
| Insert | Insert Mode | – | Copy | – | – |
| Delete | Clear | – | Delete To End Of Line | – | – |
| Home | Begin Row | – | Start Of Worksheet | – | – |
| End | End Row | – | End Of Worksheet | – | – |
| Page Up | Page Up | – | Previous Worksheet | Left 1 screen | – |
| Page Down | Page Down | – | Next Worksheet | Right 1 screen | – |
| Left Arrow | Move Left | Select Left | Move Left Area | – | – |
| Right Arrow | Move Right | Select Right | Move Right Area | – | – |
| Up Arrow | Move Up | Select Up | Move Up Area | – | – |
| Down Arrow | Move Down | Select Down | Move Down Area | Drop down list | – |
| Space Bar | Space | Select Row | Select Column | Control Box | Select All |
| Tab | Move Right | Move Left | Next Window | Next Application | Previous Window |
| BackSpace | – | – | Goto Active Cell | – | – |
Comments are closed.