Search This Blog

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

Tuesday, February 7, 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.