Friday, February 12, 2010

Keyboard Shortcuts to explore Microsoft Office

Got this in a forwarded mail today. posting it for your reference. We know shortcuts, and here some more to explore Windows Office in different ways.

Important Word Shortcuts

  • All Caps - CTRL+SHIFT+A
  • Annotation - ALT+CTRL+M
  • Auto Format - ALT+CTRL+K
  • Auto Text - F3 or ALT+CTRL+V
  • Bold - CTRL+B or CTRL+SHIFT+B
  • Bookmark - CTRL+SHIFT+F5
  • Copy - CTRL+C or CTRL+INSERT
  • Copy Format - CTRL+SHIFT+C
  • Copy Text - SHIFT+F2
  • Create Auto Text - ALT+F3
  • Date Field - ALT+SHIFT+D
  • Delete Back Word - CTRL+BACKSPACE
  • Delete Word - CTRL+DELETE
  • Dictionary - ALT+SHIFT+F7
  • Do Field Click - ALT+SHIFT+F9
  • Doc Maximize - CTRL+F10
  • Doc Move - CTRL+F7
  • Doc Restore - CTRL+F5
  • Doc Size - CTRL+F8
  • Grow Font - CTRL+SHIFT+.
  • Grow Font One Point - CTRL+]Hanging Indent - CTRL+T
  • Header Footer Link - ALT+SHIFT+R
  • Help - F1
  • Hidden - CTRL+SHIFT+H
  • Hyperlink - CTRL+K
  • Indent - CTRL+M
  • Italic - CTRL+I or CTRL+SHIFT+I
  • Justify Para - CTRL+J
  • Left Para - CTRL+L
  • Line Up Extend - SHIFT+UP
  • List Num Field - ALT+CTRL+L
  • Outline - ALT+CTRL+O
  • Outline Collapse - ALT+SHIFT+- or ALT+SHIFT+NUM -
  • Outline Demote - ALT+SHIFT+RIGHT
  • Outline Expand - ALT+SHIFT+=
  • Outline Expand - ALT+SHIFT+NUM +
  • Outline Move Down - ALT+SHIFT+DOWN
  • Outline Move Up - ALT+SHIFT+UP
  • Outline Promote - ALT+SHIFT+LEFT
  • Outline Show First Line - ALT+SHIFT+L
  • Lock Fields - CTRL+3 or CTRL+F11
  • Web Go Back - ALT+LEFT
  • Web Go Forward - ALT+RIGHT
  • Word Left - CTRL+LEFT
  • Word Left Extend - CTRL+SHIFT+LEFT
  • Word Right - CTRL+RIGHT

Excel Time saving Shortcuts:

  • Move to next cell in row - Tab
  • Move to previous cell in row - Shift + Tab
  • Up one screen - Page Up
  • Down one screen - Page Down
  • Move to next worksheet - Ctrl + Page Down
  • Move to previous worksheet - Ctrl + Page Up
  • Go to first cell in data region - Ctrl + Home
  • Go to last cell in data region - Ctrl + End
  • Bold toggle for selection - Ctrl + B
  • Italic toggle for selection - Ctrl + I
  • Underline toggle for selection - Ctrl + U
  • Strikethrough for selection - Ctrl + 5
  • Change the font - Ctrl + Shift + F
  • Change the font size - Ctrl + Shift + P
  • Apply outline borders - Ctrl + Shift + 7
  • Remove all borders - Ctrl + Shift + Underline
  • Wrap text in same cell - Alt + Enter
  • Format cells - Ctrl + 1
  • Select font - Ctrl + Shift + F
  • Select point size - Ctrl + Shift + P
  • Format as currency - Ctrl + Shift + 4
  • Format as general - Ctrl + Shift + # (hash sign)
  • Format as percentage - Ctrl + Shift + 5
  • Format as number - Ctrl + Shift + 1
  • Autosum a range of cells - Alt + Equals Sign
  • Insert the date - Ctrl +; (semi-colon)
  • Insert the time - Ctrl + Shift +; (semi-colon)
  • Insert columns/rows - Ctrl + Shift + + (plus sign)
  • Insert a new worksheet - Shift + F11
  • Read Monitor Cell One - Alt + Shift + 1
  • Read Monitor Cell Two - Alt + Shift + 2
  • Read Monitor Cell Three - Alt + Shift + 3
  • Read Monitor Cell Four - Alt + Shift + 4
  • List Visible Cells With Data - Ctrl + Shift + D
  • Lists Data In Current Column - Ctrl + Shift + C
  • List Data In Current Row - Ctrl + Shift + R
  • Select Hyperlink - Ctrl + Shift + H
  • Move To Worksheet Listbox - Ctrl + Shift + S
  • Move To Monitor Cell - Ctrl + Shift + M
  • Select Worksheet Objects - Ctrl + Shift + O
  • List Cells At Page Breaks - Ctrl + Shift + B
  • Options Listbox - Insert + V

Easy move through Powerpoint:

  • Apply subscript formatting - CTRL+EQUAL SIGN (=)
  • Apply superscript formatting - CTRL+PLUS SIGN (+)
  • Bold - CTRL+B
  • Capitalize - SHIFT+F3
  • Copy - CTRL+C
  • Delete a word - CTRL+BACKSPACE
  • Demote a paragraph - ALT+SHIFT+RIGHT ARROW
  • Find - CTRL+F
  • Insert a hyperlink - CTRL+K
  • Insert a new slide - CTRL+M
  • Italicize - CTRL+I
  • Make a duplicate of the current slide - CTRL+D
  • Open - CTRL+O
  • Open the Font dialog box - CTRL+T
  • Paste - CTRL+V
  • Print - CTRL+P
  • Promote a paragraph - ALT+SHIFT+LEFT ARROW
  • Repeat your last action - F4 or CTRL+Y
  • Save - CTRL+S
  • Select all - CTRL+A
  • Start a slide show - F5
  • Switch to the next pane (clockwise) - F6
  • Switch to the previous pane - SHIFT+F6
  • Undo - CTRL+Z
  • View guides - CTRL+G

The trick here is not to learn each one of them. Real benefit will come in taking a bunch of them and applying them on regular basis and then coming back for some more..

Search This Blog