Friday, November 25, 2011

Other Links for Microsoft Excel Solution

Other Links for Microsoft Word Solution

2. Shortcut Keys of Microsoft Excel

F2                       Edit the selected cell.
F5                       Go to a specific cell. For example, C6.
F7                       Spell check selected text or document.
F11                     Create chart.
Ctrl+Shift+;          Enter the current time.
Ctrl + ;                 Enter the current date.
Alt+Shift+F1        Insert New Worksheet.
Shift + F3            Open the Excel formula window.
Shift + F5             Bring up search box.
Ctrl + A               Select all contents of the worksheet.
Ctrl + B               Bold highlighted selection.
Ctrl + I                Italic highlighted selection.
Ctrl + K              Insert link.
Ctrl + U              Underline highlighted selection.
Ctrl + 5               Strikethrough highlighted selection.
Ctrl + P               Bring up the print dialog box to begin printing.
Ctrl + Z               Undo last action.
Ctrl + F9             Minimize current window.
Ctrl + F10           Maximize currently selected window.
Ctrl + F6              Switch between open workbooks / windows.
Ctrl + Page up     Move between Excel work sheets in the same Excel document.
Ctrl+Page down  Move between Excel work sheets in the same Excel document.
Ctrl + Tab           Move between Two or more open Excel files.
Alt + =                Create a formula to sum all of the above cells
Ctrl + '                 Insert the value of the above cell into cell currently selected.
Ctrl+Shift+!         Format number in comma format.
Ctrl+Shift+ $       Format number in currency format.
Ctrl+Shift+ #       Format number in date format.
Ctrl+Shift+ %      Format number in percentage format.
Ctrl+Shift+ ^       Format number in scientific format.
Ctrl+Shift+ @     Format number in time format.
Ctrl+Arrow key  Move to next section of text.
Ctrl+Space         Select entire column.
Shift+Space        Select entire row.

1. Shortcut Keys for Microsoft Work

Ctrl + 0       Adds or removes 6 points of spacing before a paragraph
Ctrl + A      Select all contents of the page.
Ctrl + B      Bold highlighted selection.
Ctrl + C     Copy selected text.
Ctrl + E      Aligns the line or selected text to the center of the screen.
Ctrl + F     Open find box.
Ctrl + I      Italic highlighted selection.
Ctrl + J     Aligns the selected text or line to justify the screen.
Ctrl + K    Insert link.
Ctrl + L    Aligns the line or selected text to the left of the screen.
Ctrl + M   Indent the paragraph.
Ctrl + P    Open the print window.
Ctrl + R    Aligns the line or selected text to the right of the screen.
Ctrl + T    Create a hanging indent.
Ctrl + U    Underline highlighted selection.
Ctrl + V    Paste.
Ctrl + X    Cut selected text.
Ctrl + Y    Redo the last action performed.
Ctrl + Z    Undo last action.
Ctrl + Shift + L    Quickly create a bullet point.
Ctrl + Shift + F    Change the font.
Ctrl + Shift + >    Increase selected font +1pts up to 12pt and then increases font +2pts.
Ctrl + ]                 Increase selected font +1pts.
Ctrl + Shift + <     Decrease selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.
Ctrl + [                 Decrease selected font -1pts.