Rabu, 15 Februari 2012

shortcut ms powerpoint


Action
PowerPoint shortcut
Bold
Ctrl-B
Close
Ctrl-W
Close
Ctrl-F4
Copy
Ctrl-C
Find
Ctrl-F
Italics
Ctrl-I
Menu bar
F10
New slide
Ctrl-N
Next window
Ctrl-F6
Open
Ctrl-O
Paste
Ctrl-V
Print
Ctrl-P
Repeat Find
Shift-F4
Repeat/Redo
Ctrl-Y
Replace
Ctrl-H
Save
Ctrl-S
Slide Show: Begin
F5
Slide Show: Black screen show/hide
B
Slide Show: End
Esc
Slide Show: Erase annotations
E
Slide Show: Go to next hidden slide
H
Slide Show: Hide pointer and button always
Ctrl-L
Slide Show: Hide pointer and button temporarily
Ctrl-H
Slide Show: Mouse pointer to arrow
Ctrl-A
Slide Show: Mouse pointer to pen
Ctrl-P
Slide Show: Next slide
N
Slide Show: Previous slide
P
Slide Show: Set new timings while rehearsing
T
Slide Show: Stop/restart automatic slide show
S
Slide Show: Use mouse-click to advance (rehearsing)
M
Slide Show: Use original timings
O
Slide Show: White screen show/hide
W
Spelling and Grammar check
F7
Switch to the next presentation window
Ctrl-F6
Switch to the next tab in a dialog box
Ctrl-Tab / Ctrl-Page Down
Switch to the previous presentation window
Ctrl-Shift-F6
Switch to the previous tab in a dialog box
Ctrl-Shift-Tab / Ctrl-Page Up
Turn character formatting on or of
Num /
Underline
Ctrl-U
Undo
Ctrl-Z

Sumber : http://www.shortcut-keys.com/powerpoint-shortcut-keys.php

shortcut ms excel

Action
Excel shortcut
Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+`
Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL+6
Applies or removes bold formatting
CTRL+2
Applies or removes bold formatting
CTRL+B
Applies or removes italic formatting
CTRL+3
Applies or removes italic formatting
CTRL+I
Applies or removes underlining
CTRL+4
Applies or removes underlining
CTRL+V
Applies the Currency format with two decimal places
CTRL+$
Applies the Date format with the day, month, and year
CTRL+#
Applies the Exponential number format with two decimal places
CTRL+^
Applies the General number format
CTRL+~
Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values
CTRL+!
Applies the outline border to the selected cells
CTRL+&
Applies the Percentage format with no decimal places
CTRL+%
Applies the Time format with the hour and minute, and AM or PM
CTRL+@
Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation
CTRL+ALT+F9
Calculates all worksheets in all open workbooks
F9
Calculates the active worksheet
SHIFT+F9
Closes and reopens the current task pane
CTRL+F1
Closes the selected workbook window
CTRL+F4
Closes the selected workbook window
CTRL+X
Copies the selected cells
CTRL+C
Copies the value from the cell above the active cell into the cell or the Formula Bar"
CTRL+"
Creates a chart of the data in the current range
ALT+F1
Creates a chart of the data in the current range
F11
Cuts the selected cells
CTRL+Y
Displays or hides the outline symbols
CTRL+8
Displays or hides the Standard toolbar
CTRL+7
Displays the Create List dialog box. CTRL+N Creates a new, blank file
CTRL+L
Displays the Delete dialog box to delete the selected cells
CTRL+-
Displays the Find and Replace dialog box
CTRL+H
Displays the Format Cells dialog box
CTRL+1
Displays the Go To dialog box
CTRL+G
Displays the Go To dialog box
F5
Displays the Help task pane
F1
Displays the Insert dialog box to insert blank cells
CTRL++
Displays the Insert Function dialog box
SHIFT+F3
Displays the Macro dialog box to run, edit, or delete a macro
ALT+F8
Displays the Microsoft Office Clipboard
CTRL+C
Displays the Open dialog box to open or find a file
CTRL+O
Displays the Print dialog box
CTRL+R
Displays the Save As dialog box
F12
Displays the shortcut menu for a selected item
SHIFT+F10
Displays the Spelling dialog box to check spelling in the active worksheet or selected range
F7
Edits a cell comment
SHIFT+F2
Enters the current date
CTRL+;
Enters the current time
CTRL+:
Hides the selected columns
CTRL+0
Hides the selected rows
CTRL+9
Including cells not marked as needing to be calculated
CTRL+F9
Inserts a new worksheet
ALT+SHIFT+F1
Inserts a new worksheet
SHIFT+F11
Maximizes or restores the selected workbook window
CTRL+F10
Minimizes a workbook window to an icon
F10
Pastes a defined name into a formula
F3
Removes the outline border from the selected cells
CTRL+_
Repeats the last command or action, if possible
CTRL+Z
Repeats the last command or action, if possible
F4
Restores the window size of the selected workbook window
CTRL+F5
Saves the active file with its current file name and location
CTRL+S
Selects all cells that contain comments
CTRL+SHIFT+O
Selects the current region
CTRL+A
Selects the entire worksheet
CTRL+A CTRL+A (two times)
Undo command
CTRL+U
Unhides any hidden columns within the selection
CTRL+
 Sumber : http://www.shortcut-keys.com/Microsoft-excel-shortcut-keys.php