Thursday, 3 April 2014

Microsoft Office Shortcut Keys

Word

To do this Press Key As follows                                                                                                      
Switch to the next window.
ALT+Tab
Switch to the previous window.
ALT+SHIFT+Tab
Close the active window.
CTRL+W or CTRL+F4
Restore the size of the active window after you maximize it.
ALT+F5
Move to a task pane from another pane in the program window (clockwise direction). You may have to press F6 multiple times.
F6
Move to a task pane from another pane in the program window (counterclockwise direction).
SHIFT+F6
When more than one window is open, switch to the next window.
CTRL+F6
Switch to the previous window.
CTRL+SHIFT+F6
Maximize or restore a selected window.
CTRL+F10
Copy a picture of the screen to the Clipboard.
PRINT SCREEN
Copy a picture of the selected window to the Clipboard.
ALT+PRINT SCREEN
Research
Alt + Click
Macros
Alt + F8

Auto Text


Alt + F3

Use dialog boxes
To do this
Press
Move to the next option or option group.
Tab
Move to the previous option or option group.
SHIFT+Tab
Switch to the next tab in a dialog box.
CTRL+Tab
Switch to the previous tab in a dialog box.
CTRL+SHIFT+Tab
Move between options in an open drop-down list, or between options in a group of options.
Arrow keys
Perform the action assigned to the selected button; select or clear the selected check box.
SPACEBAR
Select an option; select or clear a check box.
ALT+the letter underlined in an option
Open a selected drop-down list.
ALT+DOWN ARROW
Select an option from a drop-down list.
First letter of an option in a drop-down list.
Close a selected drop-down list; cancel a command and close a dialog box.
ESC
Run a selected command.
Enter
Use edit boxes within dialog boxes
Note An edit box is a blank in which you type or paste an entry, such as your user name or the path of a folder.
To do this
Press
Move to the beginning of the entry.
HOME
Move to the end of the entry.
END
Move one character to the left or right.
LEFT ARROW or RIGHT ARROW
Move one word to the left.
CTRL+LEFT ARROW
Move one word to the right.
CTRL+RIGHT ARROW
Select or cancel the selection of one character to the left.
SHIFT+LEFT ARROW
Select or cancel the selection of one character to the right.
SHIFT+RIGHT ARROW
Select or cancel the selection of one word to the left.
CTRL+SHIFT+LEFT ARROW
Select or cancel the selection of one word to the right.
CTRL+SHIFT+RIGHT ARROW
Select from the cursor to the beginning of the entry.
SHIFT+HOME
Select from the cursor to the end of the entry.
SHIFT+END
Use the Open and Save As dialog boxes
To do this
Press
Display the Open dialog box.
CTRL+F12 or CTRL+O
Display the Save As dialog box.
F12
Open the selected folder or file.
Enter
Open the folder one level above the selected folder.
BACKSPACE
Delete the selected folder or file.
DELETE
Display a shortcut menu for a selected item such as a folder or file.
SHIFT+F10
Move forward through options.
Tab
Move back through options.
SHIFT+Tab
Open the look in list.
F4 or ALT+I
Undo and redo actions
To do this
Press
Cancel an action.
ESC
Undo an action.
CTRL+Z
Redo or repeat an action.
CTRL+Y
Access and use task panes and galleries
To do this
Press
Move to a task pane from another pane in the program window. You may have to press F6 multiple times.
F6
When a menu is active, move to a task pane. You may have to press CTRL+Tab multiple times.
CTRL+Tab
When a task pane is active, select the next or previous option in the task pane.
Tab or SHIFT+Tab
Display the full set of commands on the task pane menu.
CTRL+SPACE BAR
Perform the action assigned to the selected button.
SPACE BAR or Enter
Open a drop-down menu for the selected gallery item.
SHIFT+F10
Select the first or last item in a gallery.
HOME or END
Scroll up or down in the selected gallery list.
PAGE UP or PAGE DOWN
Close a task pane
  1. Press F6 to move to the task pane, if it is necessary.
  2. Press CTRL+SPACEBAR.
  3. Use the arrow keys to select Close, and then press Enter.
Move a task pane
  1. Press F6 to move to the task pane, if it is necessary.
  2. Press CTRL+SPACEBAR.
  3. Use the arrow keys to select Move, and then press Enter.
  4. Use the arrow keys to move the task pane, and then press Enter.
Resize a task pane
  1. Press F6 to move to the task pane, if it is necessary.
  2. Press CTRL+SPACEBAR.
  3. Use the arrow keys to select Size, and then press Enter.
  4. Use the arrow keys to resize the task pane, and then press Enter.
Access and use available actions
To do this
Press
Display the shortcut menu for the selected part.
SHIFT+F10
Display the menu or message for an available action or for the Autocorrect Options button
or the Paste options
http://support.microsoft.com/Library/Images/2733349.png
button. If more than one action is present, switch to the next action and display its menu or message.
ALT+SHIFT+F10
Move between options in a menu of available actions.
Arrow keys
http://support.microsoft.com/Library/Images/2733348.pngPerform the action for the selected item on a menu of available actions.
Enter
Close the available actions menu or message.
ESC

Sub script (H2O)
Cntl + =
Super Script (H2O)
Cntl + +
Show and Hide
Cntl + *
Open Font Dialog
Cntl + d

Print Preview
Cntl + f2
Format Painter
Cntl + Shift + C
Alignment

Left
Cntl + L
Right
Cntl + R
Center
Cntl + E
Justified
Cntl + J
Find and Replace

Find
Cntl + F
Replace
Cntl + H
Go to
Cntl + G




Excel Key






DESCRIPTION
CTRL+PgUp
Switches between worksheet tabs, from left-to-right.
CTRL+PgDn
Switches between worksheet tabs, from right-to-left.
CTRL+SHIFT+(
Unhides any hidden rows within the selection.
CTRL+SHIFT+)
Unhides any hidden columns within the selection.
CTRL+SHIFT+&
Applies the outline border to the selected cells.
CTRL+SHIFT_
Removes the outline border from the selected cells.
CTRL+SHIFT+~
Applies the General number format.
CTRL+SHIFT+$
Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+SHIFT+%
Applies the Percentage format with no decimal places.
CTRL+SHIFT+^
Applies the Exponential number format with two decimal places.
CTRL+SHIFT+#
Applies the Date format with the day, month, and year.
CTRL+SHIFT+@
Applies the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+!
Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+SHIFT+*
Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).
In a PivotTable, it selects the entire PivotTable report.
CTRL+SHIFT+:
Enters the current time.
CTRL+SHIFT+"
Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+SHIFT+Plus (+)
Displays the Insert dialog box to insert blank cells.
CTRL+Minus (-)
Displays the Delete dialog box to delete the selected cells.
CTRL+;
Enters the current date.
CTRL+`
Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+'
Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+1
Displays the Format Cells dialog box.
CTRL+2
Applies or removes bold formatting.
CTRL+3
Applies or removes italic formatting.
CTRL+4
Applies or removes underlining.
CTRL+5
Applies or removes strikethrough.
CTRL+6
Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL+8
Displays or hides the outline symbols.
CTRL+9
Hides the selected rows.
CTRL+0
Hides the selected columns.
CTRL+A
Selects the entire worksheet.
If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet.
When the insertion point is to the right of a function name in a formula, displays theFunction Arguments dialog box.
CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
CTRL+B
Applies or removes bold formatting.
CTRL+C
Copies the selected cells.
CTRL+C followed by another CTRL+C displays the Clipboard.
CTRL+D
Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
CTRL+F
Displays the Find and Replace dialog box, with the Find tab selected.
SHIFT+F5 also displays this tab, while SHIFT+F4 repeats the last Find action.
CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected.
CTRL+G
Displays the Go To dialog box.
F5 also displays this dialog box.
CTRL+H
Displays the Find and Replace dialog box, with the Replace tab selected.
CTRL+I
Applies or removes italic formatting.
CTRL+K
Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+N
Creates a new, blank workbook.
CTRL+O
Displays the Open dialog box to open or find a file.
CTRL+SHIFT+O selects all cells that contain comments.
CTRL+P
Displays the Print dialog box.
CTRL+SHIFT+P opens the Format Cells dialog box with the Font tab selected.
CTRL+R
Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
CTRL+S
Saves the active file with its current file name, location, and file format.
CTRL+T
Displays the Create Table dialog box.
CTRL+U
Applies or removes underlining.
CTRL+SHIFT+U switches between expanding and collapsing of the formula bar.
CTRL+V
Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.
CTRL+ALT+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
CTRL+W
Closes the selected workbook window.
CTRL+X
Cuts the selected cells.
CTRL+Y
Repeats the last command or action, if possible.
CTRL+Z
Uses the Undo command to reverse the last command or to delete the last entry that you typed.
CTRL+SHIFT+Z uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.

Power point


TO DO THIS
PRESS
Perform the next animation or advance to the next slide
N, ENTER, PAGE DOWN, RIGHT ARROW, DOWN ARROW, or the SPACEBAR (or click the mouse)
Perform the previous animation or return to the previous slide
P, PAGE UP, LEFT ARROW, UP ARROW, or BACKSPACE
Go to slide number
number+ENTER
Show or hide arrow pointer
A or =
Display a black screen, or return to the slide show from a black screen
B or PERIOD
Display a white screen, or return to the slide show from a white screen
W or COMMA
Stop or restart an automatic slide show
S or PLUS SIGN
End a slide show
ESC, CTRL+BREAK, or HYPHEN
Erase on-screen annotations
E
Go to the next hidden slide
H
Set new timings while rehearsing
T
Use original timings while rehearsing
O
Use mouse-click to advance while rehearsing
M
Return to the first slide
1+ENTER (or press both mouse buttons for 2 seconds)
Redisplay hidden pointer and/or change the pointer to a pen
CTRL+P
Redisplay hidden pointer and/or change the pointer to an arrow
CTRL+A
Hide the pointer and navigation button immediately
CTRL+H
Show or hide ink markup
CTRL+M
Hide the pointer and navigation button in 15 seconds
CTRL+U
View task bar
CTRL+T
All Slides dialog box
CTRL+S
Display the shortcut menu
SHIFT+F10 (or right-click)
Go to the first or next hyperlink on a slide
TAB
Go to the last or previous hyperlink on a slide
SHIFT+TAB
Perform the "mouse click" behavior of the selected hyperlink
ENTER while a hyperlink is selected
Perform the "mouse over" behavior of the selected hyperlink
SHIFT+ENTER while a hyperlink is selected