Friday, November 27, 2009
MS Excel Shortcut Keys
5:34 AM | 
Posted by
Sushil
| Hide Column | Ctrl + 0 |
| Unhide Column | Ctrl + Shift + 0 |
| Hide Row | Ctrl + 9 |
| Unhide Row | Ctrl + Shift + 9 |
| Refresh | Ctrl + 6 |
| Strike Out | Ctrl + 5 |
| Underline | Ctrl + 4 |
| Italic | Ctrl + 3 |
| Bold | Ctrl + 2 |
| Format Cell Dialog | Ctrl + 1 |
| Change Relative Cell Ref to Absolute ref. (Toggle Key) | F4 |
| Edit Current Cell | F2 |
| Go To a Cell | F5 |
| Double Column Width in whole worksheet (Toogle Key) | Ctrl + ` |
| Close Current Workbook | Ctrl + w |
| Copy Contents of Cell to Left | Ctrl + R |
| Create Table and set filters | Ctrl + L Or Ctrl + T |
| Insert Hyperlink Dialog | Ctrl + K |
| Current Date | Ctrl + ; |
| Current Time | Ctrl + : |
| Copy Contents of Cell above current selection | Ctrl + ' |
| New Workbook | Ctrl + N |
| Delete Selected Cell | Ctrl + - |
| Insert Blank Cell | Ctrl + = |
| Auto Sum | Alt + - |
| Complete Formula with paranthesis and parameters | Ctrl + Shift + A |
| Toggle betwwen open workbooks | Ctrl + TAB |
| Open Worksheet to left of current worksheet | Ctrl + PgUP |
| Open Worksheet to right of current worksheet | Ctrl + PgDn |
| Box the Current Selection | Ctrl + Shift + 7 or Ctrl + & |
Subscribe to:
Post Comments (Atom)
0 comments: