Tuesday, February 24, 2009

Wednesday, December 3, 2008

Wednesday, October 22, 2008

Tuesday, October 21, 2008

Saturday, September 27, 2008

song

Computer Short Cuts

Key -Description
CTRL+( -Unhides any hidden rows within the selection.
CTRL+) -Unhides any hidden columns within the selection.
CTRL+& -Applies the outline border to the selected cells.
CTRL+_ -Removes the outline border from the selected cells.
CTRL+~ -Applies the General number format.
CTRL+$ -Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+% -Applies the Percentage format with no decimal places.
CTRL+^ -Applies the Exponential number format with two decimal places.
CTRL+# -Applies the Date format with the day, month, and year.
CTRL+@ -Applies the Time format with the hour and minute, and AM or PM.
CTRL+! -Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+- -Displays the Delete dialog box to delete the selected cells.
CTRL+* -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+: -Enters the current time.
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+" -Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL++ -Displays the Insert dialog box to insert blank cells.
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+7 -Displays or hides the Standard toolbar.
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 entire worksheet.
When the insertion point is to the right of a function name in a formula, displays the Function 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 Microsoft Office 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 dialog box.
SHIFT+F5 also displays this dialog box, while SHIFT+F4 repeats the last Find action.
CTRL+G -Displays the Go To dialog box.
F5 also displays this dialog box.
CTRL+H -Displays the Find and Replace dialog box.
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+L -Displays the Create List dialog box.
CTRL+N -Creates a new, blank file.
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+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+U -Applies or removes underlining.
CTRL+V -Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you cut or copied an object, text, or cell contents.
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 you typed.
CTRL+SHIFT+Z -uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are

Thursday, September 11, 2008

MS-Word Shortcut Keys

Command Name Shortcut Keys
------------------------------------------------------------------------

All Caps - CTRL+SHIFT+A
Annotation- ALT+CTRL+M
App Maximize- ALT+F10
App Restore- ALT+F5
Apply Heading1- ALT+CTRL+1
Apply Heading2- ALT+CTRL+2
Apply Heading3- ALT+CTRL+3
Apply List Bullet- CTRL+SHIFT+L
Auto Format- ALT+CTRL+K
Auto Text- F3 or ALT+CTRL+V
Bold- CTRL+B or CTRL+SHIFT+B
Bookmark- CTRL+SHIFT+F5
Browse Next- CTRL+PAGE DOWN
Browse Previous- CTRL+PAGE UP
Browse Sel- ALT+CTRL+HOME
Cancel- ESC
Center Para- CTRL+E
Change Case- SHIFT+F3
Char Left- LEFT
Char Left Extend- SHIFT+LEFT
Char Right- RIGHT
Char Right Extend- SHIFT+RIGHT
Clear- DELETE
Close or Exit- ALT+F4
Close Pane- ALT+SHIFT+C
Column Break- CTRL+SHIFT+ENTER
Column Select- CTRL+SHIFT+F8
Copy - CTRL+C or CTRL+INSERT
Copy Format- CTRL+SHIFT+C
Copy Text - SHIFT+F2
Create Auto Text - ALT+F3
Customize Add Menu - ALT+CTRL+=
Customize Keyboard - ALT+CTRL+NUM +
Customize Remove Menu- ALT+CTRL+-
Cut - CTRL+X or SHIFT+DELETE
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 Close - CTRL+W or CTRL+F4
Doc Maximize -CTRL+F10
Doc Move -CTRL+F7
Doc Restore -CTRL+F5
Doc Size -CTRL+F8
Doc Split -ALT+CTRL+S
Double Underline - CTRL+SHIFT+D
End of Column - ALT+PAGE DOWN
End of Column -ALT+SHIFT+PAGE DOWN
End of Doc Extend -CTRL+SHIFT+END
End of Document -CTRL+END
End of Line -END
End of Line Extend -SHIFT+END
End of Row -ALT+END
End of Row -ALT+SHIFT+END
End of Window -ALT+CTRL+PAGE DOWN
End of Window Extend -ALT+CTRL+SHIFT+PAGE DOWN
Endnote Now -ALT+CTRL+D
Extend Selection -F8
Field Chars - CTRL+F9
Field Codes -ALT+F9
Find -CTRL+F
Font -CTRL+D or CTRL+SHIFT+F
Font Size Select -CTRL+SHIFT+P
Footnote Now -ALT+CTRL+F
Go Back -SHIFT+F5 or ALT+CTRL+Z
Go To -CTRL+G or F5
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 Down -DOWN
Line Down Extend -SHIFT+DOWN
Line Up -UP
Line Up Extend -SHIFT+UP
List Num Field -ALT+CTRL+L
Lock Fields -CTRL+3 or CTRL+F11
Macro -ALT+F8
Mail Merge Check -ALT+SHIFT+K
Mail Merge Edit Data Source -ALT+SHIFT+E
Mail Merge to Doc -ALT+SHIFT+N
Mail Merge to Printer -ALT+SHIFT+M
Mark Citation -ALT+SHIFT+I
Mark Index Entry -ALT+SHIFT+X
Mark Table of Contents Entry -ALT+SHIFT+O
Menu Mode -F10
Merge Field - ALT+SHIFT+F
Microsoft Script Editor -ALT+SHIFT+F11
Microsoft System Info -ALT+CTRL+F1
Move Text -F2
New -CTRL+N
Next Cell -TAB
Next Field -F11 or ALT+F1
Next Misspelling -ALT+F7
Next Object -ALT+DOWN
Next Window -CTRL+F6 or ALT+F6
Normal -ALT+CTRL+N
Normal Style -CTRL+SHIFT+N or ALT+SHIFT+CLEAR (NUM 5)
Open -CTRL+O or CTRL+F12 or ALT+CTRL+F2
Open or Close Up Para - CTRL+0
Other Pane - F6 or SHIFT+F6
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
Overtype - INSERT
Page - ALT+CTRL+P
Page Break - CTRL+ENTER
Page Down - PAGE DOWN
Page Down Extend - SHIFT+PAGE DOWN
Page Field - ALT+SHIFT+P
Page Up - PAGE UP
Page Up Extend - SHIFT+PAGE UP
Para Down -CTRL+DOWN
Para Down Extend -CTRL+SHIFT+DOWN
Para Up -CTRL+UP
Para Up Extend -CTRL+SHIFT+UP
Paste -CTRL+V or SHIFT+INSERT
Paste Format -CTRL+SHIFT+V
Prev Cell -SHIFT+TAB
Prev Field -SHIFT+F11 or ALT+SHIFT+F1
Prev Object -ALT+UP
Prev Window -CTRL+SHIFT+F6 or ALT+SHIFT+F6
Print -CTRL+P or CTRL+SHIFT+F12
Print Preview -CTRL+F2 or ALT+CTRL+I
Proofing -F7
Redo -ALT+SHIFT+BACKSPACE
Redo or Repeat -CTRL+Y or F4 or ALT+ENTER
Repeat Find -SHIFT+F4 or ALT+CTRL+Y
Replace -CTRL+H
Reset Char -CTRL+SPACE or CTRL+SHIFT+Z
Reset Para -CTRL+Q
Revision Marks Toggle -CTRL+SHIFT+E
Right Para -CTRL+R
Save -CTRL+S or SHIFT+F12 or ALT+SHIFT+F2
Save As -F12
Select All -CTRL+A or CTRL+CLEAR (NUM 5) or CTRL+NUM 5
Select Table -ALT+CLEAR (NUM 5)
Show All -CTRL+SHIFT+8
Show All Headings -ALT+SHIFT+A
Show Heading1 -ALT+SHIFT+1
Show Heading2 -ALT+SHIFT+2
Show Heading3 -ALT+SHIFT+3
Show Heading4 -ALT+SHIFT+4
Show Heading5 -ALT+SHIFT+5
Show Heading6 -ALT+SHIFT+6
Show Heading7 -ALT+SHIFT+7
Show Heading8 -ALT+SHIFT+8
Show Heading9 -ALT+SHIFT+9
Shrink Font -CTRL+SHIFT+,
Shrink Font One Point -CTRL+[
Small Caps -CTRL+SHIFT+K
Space Para1 -CTRL+1
Space Para15 -CTRL+5
Space Para2 -CTRL+2
Spike -CTRL+SHIFT+F3 or CTRL+F3
Start of Column -ALT+PAGE UP
Start of Column -ALT+SHIFT+PAGE UP
Start of Doc Extend -CTRL+SHIFT+HOME
Start of Document -CTRL+HOME
Start of Line -HOME
Start of Line Extend -SHIFT+HOME
Start of Row -ALT+HOME
Start of Row -ALT+SHIFT+HOME
Start of Window -ALT+CTRL+PAGE UP
Start of Window Extend -ALT+CTRL+SHIFT+PAGE UP
Style -CTRL+SHIFT+S
Subscript -CTRL+=
Superscript -CTRL+SHIFT+=
Symbol Font -CTRL+SHIFT+Q
Thesaurus -SHIFT+F7
Time Field -ALT+SHIFT+T
Toggle Field Display -SHIFT+F9
Toggle Master Subdocs -CTRL+\
Tool -SHIFT+F1
Un Hang -CTRL+SHIFT+T
Un Indent -CTRL+SHIFT+M
Underline -CTRL+U or CTRL+SHIFT+U
Undo -CTRL+Z or ALT+BACKSPACE
Unlink Fields -CTRL+6 or CTRL+SHIFT+F9
Unlock Fields -CTRL+4 or CTRL+SHIFT+F11
Update Auto Format -ALT+CTRL+U
Update Fields -F9 or ALT+SHIFT+U
Update Source -CTRL+SHIFT+F7
VBCode -ALT+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
Word Right Extend -CTRL+SHIFT+RIGHT
Word Underline -CTRL+SHIFT+W

Comedy03

Comedy02

Comedy01