Showing posts with label SHORTCUTS. Show all posts
Showing posts with label SHORTCUTS. Show all posts

Tuesday 7 February 2012

Microsoft Excel shortcut keys

F2Edit the selected cell.
F5Go to a specific cell. For example, C6.
F7Spell check selected text or document.
F11Create chart.
Ctrl + Shift + ;Enter the current time.
Ctrl + ;Enter the current date.
Alt + Shift + F1Insert New Worksheet.
Shift + F3Open the Excel formula window.
Shift + F5Bring up search box.
Ctrl + ASelect all contents of the worksheet.
Ctrl + BBold highlighted selection.
Ctrl + IItalic highlighted selection.
Ctrl + KInsert link.
Ctrl + UUnderline highlighted selection.
Ctrl + 5Strikethrough highlighted selection.
Ctrl + PBring up the print dialog box to begin printing.
Ctrl + ZUndo last action.
Ctrl + F9Minimize current window.
Ctrl + F10Maximize currently selected window.
Ctrl + F6Switch between open workbooks / windows.
Ctrl + Page upMove between Excel work sheets in the same Excel document.
Ctrl + Page downMove between Excel work sheets in the same Excel document.
Ctrl + TabMove 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 keyMove to next section of text.
Ctrl + SpaceSelect entire column.
Shift + SpaceSelect entire row.

Microsoft Word shortcut keys

Ctrl + 0Adds or removes 6pts of spacing before a paragraph.
Ctrl + ASelect all contents of the page.
Ctrl + BBold highlighted selection.
Ctrl + CCopy selected text.
Ctrl + EAligns the line or selected text to the center of the screen.
Ctrl + FOpen find box.
Ctrl + IItalic highlighted selection.
Ctrl + JAligns the selected text or line to justify the screen.
Ctrl + KInsert link.
Ctrl + LAligns the line or selected text to the left of the screen.
Ctrl + MIndent the paragraph.
Ctrl + POpen the print window.
Ctrl + RAligns the line or selected text to the right of the screen.
Ctrl + TCreate a hanging indent.
Ctrl + UUnderline highlighted selection.
Ctrl + VPaste.
Ctrl + XCut selected text.
Ctrl + YRedo the last action performed.
Ctrl + ZUndo last action.
Ctrl + Shift + LQuickly create a bullet point.
Ctrl + Shift + FChange 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.
Ctrl + / + cInsert a cent sign (¢).
Ctrl + ' + Insert a character with an accent (grave) mark, where is the character you want. For example, if you wanted an accented รจ you would use Ctrl + ' + e as your shortcut key. To reverse the accent mark use the opposite accent mark, often on the tilde key.
Ctrl + Shift + *View or hide non printing characters.
Ctrl + Moves one word to the left.
Ctrl + Moves one word to the right.
Ctrl + Moves to the beginning of the line or paragraph.
Ctrl + Moves to the end of the paragraph.
Ctrl + DelDeletes word to right of cursor.
Ctrl + BackspaceDeletes word to left of cursor.
Ctrl + EndMoves the cursor to the end of the document.
Ctrl + HomeMoves the cursor to the beginning of the document.
Ctrl + SpacebarReset highlighted text to the default font.
Ctrl + 1Single-space lines.
Ctrl + 2Double-space lines.
Ctrl + 51.5-line spacing.
Ctrl + Alt + 1Changes text to heading 1.
Ctrl + Alt + 2Changes text to heading 2.
Ctrl + Alt + 3Changes text to heading 3.
Alt + Ctrl + F2Open new document.
Ctrl + F1Open the Task Pane.
Ctrl + F2Display the print preview.
Ctrl + Shift + >Increases the highlighted text size by one.
Ctrl + Shift + <Decreases the highlighted text size by one.
Ctrl + Shift + F6Opens to another open Microsoft Word document.
Ctrl + Shift + F12Prints the document.
F1Open Help.
F4Repeat the last action performed (Word 2000+)
F5Open the find, replace, and go to window in Microsoft Word.
F7Spellcheck and grammar check selected text or document.
F12Save as.
Shift + F3Change the text in Microsoft Word from uppercase to lowercase or a capital letter at the beginning of every word.
Shift + F7Runs a Thesaurus check on the word highlighted.
Shift + F12Save.
Shift + EnterCreate a soft break instead of a new paragraph.
Shift + InsertPaste.
Shift + Alt + DInsert the current date.
Shift + Alt + TInsert the current time.