| The Most comprehensive listing of Keyboard shortcuts - Chip Pearson !! | ||||||
| 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 (^) | a | Exponent Format | ||||
| 7 (&) | a | 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 | |||||