Thinkfree.com‘s Doc
Exchange is a site that encourages their users to share their
documents with one another. You can use their search feature to find
documents in areas you are interested in. Here is a helpful
little document I found that shows all of the Keyboard
Shortcuts for Microsoft Excel. These will really help those
power Excel users who need to use many of Excel’s features in their
day-to-day work and tasks. If you fall into that category, I hope this
helps you out.
Excel
Keyboard Shortcuts
| 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 |
Popularity: 23% [?]
Related Posts:
Tags for this post>> Excel
Very helpful shortcut keys all important keys are listed here…..
Hardware Keylogger
Comment by John Cooper — January 17, 2011 @ 6:45 am