The Keyboard Shortcut Magic!
This is free ebook & may be freely distributed
The Keyboard Shortcut Magic! (Updated 2009 version)
Discover The MAGIC Of Your Keyboard That Can Practically REPLACE Your Mouse! (Over 350 Keyboard Shortcuts Revealed)
By Wong Hing www.msoffice-tutorial-training.com
This is a free bonus. Feel free to forward to or make copies for your friends. This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information.
The Keyboard Shortcut Magic!
Table of Contents
INTRODUCTION .................................................................................................................................. 1 PART I: MICROSOFT WORD KEYBOARD SHORTCUTS........................................................... 2 DOCUMENT ACTIONS ............................................................................................................................ 2 TEXT STYLE .......................................................................................................................................... 2 TABLES ................................................................................................................................................. 3 FORMATTING ......................................................................................................................................... 3 CURSOR MOVEMENT ............................................................................................................................. 4 MISCELLANEOUS ................................................................................................................................... 4 ADVANCED – F1 TO F12 ........................................................................................................................ 4 PART II: MICROSOFT EXCEL KEYBOARD SHORTCUTS ........................................................ 6 SPREADSHEET ACTIONS ........................................................................................................................ 6 SELECTING & NAVIGATING ................................................................................................................... 6 FORMATTING ......................................................................................................................................... 7 DATA & FORMULAS .............................................................................................................................. 8 PART III: MICROSOFT POWERPOINT KEYBOARD SHORTCUTS ......................................... 9 PRESENTATION ACTIONS ....................................................................................................................... 9 FORMATTING ......................................................................................................................................... 9 SELECTING & NAVIGATING ................................................................................................................. 10 EDITING............................................................................................................................................... 10 DRAWING & FORMATTING .................................................................................................................. 11 SLIDE SHOW ACTIONS ......................................................................................................................... 11 PART IV: MICROSOFT OUTLOOK KEYBOARD SHORTCUTS .............................................. 13 GENERAL ACTIONS ............................................................................................................................. 13 CALENDAR WEEK VIEW ...................................................................................................................... 14 MAIN OUTLOOK ACTIONS ................................................................................................................... 14
This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information.
The Keyboard Shortcut Magic!
Introduction I'd like to thank you for downloading this FREE e-book. If you like it, feel free to forward to or make copies for your friends, relatives, colleagues, associates, customers and subscribers as long as it is not modified in any way. If you sell digital products you’re also encouraged to offer this e-book as a bonus. This book contains nearly all the keyboard shortcuts that related to the 3 programs: Microsoft Office Word, Excel and PowerPoint. It can save time and the effort of switching from the keyboard to the mouse to execute simple commands. With this ebook, it will release all the shortcuts available to perform the task that you wish, just simply pressing 2 or 3 keyboard buttons. This ebook is categorized according to the topics such as formatting actions, selecting & navigating, etc to let you can easily use the shortcuts according to the related topic. I highly recommend you to print this list of keyboard shortcuts and keep it in front of your PC for a quick reference.
Happy trying!
Note: A plus sign indicates that the keys need to be pressed at the same time. For example, Ctrl+O means while holding down the Ctrl key and press on the O button! This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information. Page 1
The Keyboard Shortcut Magic!
Part I: Microsoft Word Keyboard Shortcuts Document Actions Action Open a document New document Close a document Save As Save Print Preview Print Show/Hide paragraph symbols Spelling and grammar Help Find Replace Go To Quit/Exit Word
Keystroke CTRL+O CTRL+N CTRL+W F12 CTRL+S / SHIFT+F12 CTRL+F2 CTRL+P CTRL+* F7 F1 CTRL+F CTRL+H CTRL+G / F5 ALT+F4
Text Style Action Keystroke Font Type CTRL+SHIFT+F+Up/down arrow - Enter Font Size CTRL+SHIFT+P+Up/down arrow - Enter Bold CTRL+B Italics CTRL+I Underline CTRL+U Double underline CTRL+SHIFT+D Word underline CTRL+SHIFT+W All caps CTRL+SHIFT+A Small caps CTRL+SHIFT+K Change case SHIFT+F3 Single spacing CTRL+1 1.5 spacing CTRL+5 Double spacing CTRL+2 Subscript CTRL+= Superscript CTRL+SHIFT+= Hidden text CTRL+SHIFT+H Revert to default font CTRL+SHIFT+Z Decrease point size CTRL+[ Increase point size CTRL+] Make web hyperlink CTRL+K This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information. Page 2
The Keyboard Shortcut Magic!
Tables Action Go to next cell Go to previous cell Go to beginning of column Highlight to beginning of column Go to end of column Highlight to end of column Go to beginning of row Highlight to beginning of row Go to end of row Highlight to end of row Column break
Keystroke Tab SHIFT+Tab ALT+PageUp ALT+SHIFT+PageUp ALT+PageDown ALT+SHIFT+PageDown ALT+Home ALT+SHIFT+Home ALT+End ALT+SHIFT+End CTRL+SHIFT+Enter
Formatting Action Select all Copy Cut Paste Undo Redo Left alignment Center alignment Right alignment Justified Indent from left Decrease indent from left Hanging indent Decrease hanging indent Page break Promote list item Demote list item Format painter Delete previous word Apply bulleted list Style Normal style
Keystroke CTRL+A CTRL+C CTRL+X CTRL+V CTRL+Z CTRL+Y CTRL+L CTRL+E CTRL+R CTRL+J CTRL+M CTRL+SHIFT+M CTRL+T CTRL+SHIFT+T CTRL+Enter ALT+SHIFT+Left arrow ALT+SHIFT+Right arrow or TAB CTRL+SHIFT+C CTRL+Backspace CTRL+SHIFT+L CTRL+SHIFT+S CTRL+SHIFT+N
This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information. Page 3
The Keyboard Shortcut Magic!
Cursor Movement Action Select from cursor to beginning of line Select from cursor to end of line Go to beginning of line Go to end of line Go to beginning of document Go to end of document
Keystroke SHIFT+Home SHIFT+End Home End CTRL+Home CTRL+End
Miscellaneous Action Copyright symbol - © Insert current date Insert current time Go to footnotes Show/Hide ¶ Thesaurus
Keystroke ALT+CTRL+C ALT+SHIFT+D ALT+SHIFT+T ALT+CTRL+F CTRL+SHIFT+8 SHIFT+F7
Advanced – F1 to F12 Keystroke
Action F1 Help Alt+F1 Next field Alt+Shift+F1 Previous field Shift+F1 ‘What is This’ Help F2 Move text or graphic Alt+F2 Unassigned Alt+Shift+F2 File Save Ctrl+F2 File Print Preview Shift F2 Copy Text
F3 Edit AutoText Ctrl+F3 Store in Spike Ctrl+Shift+F3 Insert Spike and empty contents Shift+F3 Changes case F4 Edit Repeat frame Alt+F4 File Exit Ctrl+F4 File Close Shift+F4 Repeat a Go To or Find command This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information. Page 4
The Keyboard Shortcut Magic!
F5 Edit Go To Alt+F5 Previous application window size Ctrl+F5 Previous document window size Ctrl+Shift+F5 Edit bookmark Shift+F5 Previous position F6 Next pane Ctrl+F6 Next window Ctrl+Shift+F6 Previous window Shift+F6 Previous pane F7 Tools Spelling Ctrl+F7 Move window Ctrl+Shift+F7 Update link Shift+F7 Tools Thesaurus F8 Extend selection Ctrl+F8 Size window Ctrl+Shift+F8 Select column or display/hide tab and paragraph marks Shift+F8 Shrink selection F9 Update field Alt+Shift+F9 Go To/Macro button fields Ctrl+F9 Field characters Ctrl+Shift+F9 Unlink field Shift+F9 Switch field codes or results F10 Menu bar Alt+F10 Enlarge Application window Ctrl+F10 Enlarge Document window Shift+F10 Cut/Copy/Paste/Font/Paragraph/Bullets and Numbering menu bar F11 Next field Ctrl+F11 Lock field Ctrl+Shift+F11 Unlock field Shift+F11 Previous field F12 File Save As Ctrl+F12 File Open Ctrl+Shift+F12 File Print Shift+F12 File Save This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information. Page 5
The Keyboard Shortcut Magic!
Part II: Microsoft Excel Keyboard Shortcuts Spreadsheet Actions Action Open a workbook New workbook Close a workbook Open the Save As dialog box Save a workbook Print a workbook Help Open the Find tab of the Find and Replace dialog box Open the Replace tab of the Find and Replace dialog box Go to Quit/Exit Excel Insert a new worksheet Hide selected columns Display hidden columns Hide selected rows Display hidden rows
Keystroke CTRL+O CTRL+N CTRL+W F12 CTRL+S CTRL+P F1 CTRL+F CTRL+H CTRL+G / F5 ALT+F4 SHIFT + F11 CTRL + 0 CTRL + SHIFT + 0 CTRL + 9 CTRL + SHIFT + 9
Selecting & Navigating Action All cells left of current cell All cells right of current cell Entire column Entire row Entire worksheet One cell up One cell down One cell right One cell left Top of worksheet (cell A1) End of worksheet (last cell with data) End of row End of column Move to next worksheet Move to previous worksheet Cycle between open workbooks
Keystroke SHIFT+Left arrow SHIFT+Right arrow CTRL+Spacebar SHIFT+Spacebar CTRL+A Up arrow Down arrow Tab SHIFT+Tab CTRL+Home CTRL+End Home CTRL+Left arrow CTRL+PageDown CTRL+PageUp CTRL+F6
This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information. Page 6
The Keyboard Shortcut Magic!
Move between panes in a split worksheet Display the active cell Move up a cell in a selected range Move one cell left in a selected range Move from corner cell to corner cell in a selected range Select the current cell(s) to the beginning of the row Select the current cell(s) to the beginning of the worksheet Select all cells that contain a comment Select the data region surrounding the active cell
F6 CTRL + Backspace SHIFT + Enter SHIFT + Tab CTRL and . (period) SHIFT + Home CTRL + SHIFT + Home CTRL + SHIFT + O CTRL and *
Formatting Action Edit within an active cell Format as currency with 2 decimal places Format as percent with no decimal places Apply number format Apply date format Apply time format Apply general format Apply exponential number format Apply outline border to selection Remove outline border to selection Cut Copy Paste Undo Redo Bold Italics Underline Strikethrough Left alignment Center alignment Right alignment
Keystroke F2 CTRL + SHIFT +$ CTRL + SHIFT +% CTRL + SHIFT + ! CTRL + SHIFT + # CTRL + SHIFT + @ CTRL + SHIFT + ~ CTRL + SHIFT + ^ CTRL + SHIFT + & CTRL + SHIFT and _ CTRL + X CTRL + C CTRL + V CTRL + Z CTRL + Y CTRL + B CTRL + I CTRL + U CTRL + 5 CTRL + L CTRL + E CTRL + R
This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information. Page 7
The Keyboard Shortcut Magic!
CTRL + SHIFT + F + Up/down arrow – Enter CTRL + SHIFT + P + Up/down arrow – Enter CTRL + 1
Change font type Change font size Open Format Cells dialog box
Data & Formulas Action Begin a formula Enter a formula as an array Display Insert Function dialog box Paste a defined name into a formula Insert a AutoSum formula Copy a formula from the cell above the current cell into the current cell Calculate values for sheets in all open workbooks Calculate values for current worksheet Fill data down through selected cells Fill data through selected cells to the right Insert current date in the worksheet Insert current time in the worksheet Run a Spelling Check Run the Macros
Keystroke = CTRL + SHIFT + Enter SHIFT + F3 F3 ALT + = CTRL and ‘ F9 SHIFT + F9 CTRL + D CTRL + R CTRL + ; CTRL + : F7 ALT + F8
This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information. Page 8
The Keyboard Shortcut Magic!
Part III: Shortcuts
Microsoft
PowerPoint
Keyboard
Presentation Actions Action Open a presentation New presentation Save As Save Print Help Quit/Exit PowerPoint
Keystroke CTRL+O, CTRL+F12 CTRL+N F12 CTRL+S CTRL+P F1 ALT+F4
Formatting Action Select all Copy Cut Paste Undo Redo Bold Italics Underline Left justified Center justified Right justified Create hyperlink Format Painter (Copy) Format Painter (Paste) Increase font size Decrease font size Change font type Change font size Promote list item Demote list item Move selected item up Move selected item down Superscript Subscript Change Case
Keystroke CTRL+A CTRL+C CTRL+X CTRL+V CTRL+Z CTRL+Y CTRL+B CTRL+I CTRL+U CTRL+L CTRL+E CTRL+R CTRL+K CTRL+SHIFT+C CTRL+SHIFT+V CTRL+SHIFT+> CTRL+SHIFT+< CTRL+SHIFT+F+Up/down arrow - Enter CTRL+SHIFT+P+Up/down arrow - Enter ALT+SHIFT+Left arrow ALT+SHIFT+Right arrow ALT+SHIFT+Up arrow ALT+SHIFT+Down arrow ALT+CTRL+SHIFT+> ALT+CTRL+SHIFT+< SHIFT+F3
This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information. Page 9
The Keyboard Shortcut Magic!
Selecting & Navigating Action Character left Character right End of word Beginning of word Line up Line down Select all Character left Character right Line up Line down Word left Word right End of line Beginning of line Paragraph up Paragraph down End of text block Start of text block To previous object To next object Select all objects
Keystroke SHIFT+Left arrow SHIFT+Right arrow CTRL+SHIFT+Right Arrow CTRL+SHIFT+Left Arrow SHIFT+Up Arrow SHIFT+Down Arrow CTRL+A or F2 Left Arrow Right Arrow Up Arrow Down Arrow CTRL+Left Arrow CTRL+Right Arrow END HOME CTRL+Up Arrow CTRL+Down Arrow CTRL+END CTRL+HOME TAB SHIFT+TAB CTRL+A
Editing Action Delete character left Delete word left Delete character right Delete word right Find Replace Insert hyperlink New slide New slide like last one, no menu Spell checker Macros Move from Title to Text Move from Body text to Title of next slide
Keystroke Backspace CTRL+Backspace Delete CTRL+Delete CTRL+F CTRL+H CTRL+K CTRL+M CTRL+SHIFT+M F7 ALT+F8 CTRL+Enter CTRL+Enter
This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information. Page 10
The Keyboard Shortcut Magic!
Drawing & Formatting Action Grid and Guides dialog box Group Objects Ungroup Objects Regroup Objects Resize while maintaining proportions Resize from center Resize from center while maintaining proportions Rotate in 15 degree increments Rotate from Corner Rotate in 15 degree increments from Corner Extend Line along same angle Nudge object one grid unit Nudge object one pixel Temporarily release Grid/Guide Snap Show/Hide Guides (toggle) Show/Hide Grid (toggle)
Keystroke CTRL+G CTRL+SHIFT+G CTRL+SHIFT+H CTRL+SHIFT+J SHIFT+Resize CTRL+Resize CTRL+SHIFT+Resize SHIFT+Rotate tool CTRL+Rotate tool CTRL+SHIFT+Rotate tool SHIFT+Resize Arrow Key CTRL+Arrow Key ALT ALT+F9 SHIFT+F9
Slide Show Actions Action Begin slide show Next slide Previous slide Go to Slide Redisplay hidden pointer and/or change the pointer to an arrow Redisplay hidden pointer and/or change the pointer to a pen Hide the pointer and button immediately Hide the pointer and button in 15 seconds Erase on-screen annotations Go to next hidden slide Use mouse-click to advance while rehearsing Use original timings while rehearsing
Keystroke F5 ENTER, Spacebar, N, Right Arrow, Down Arrow, Page Down (or click the mouse) BACKSPACE, P, Left Arrow, Up Arrow, Page Up +Enter CTRL+A CTRL+P CTRL+H CTRL+U E H M O
This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information. Page 11
The Keyboard Shortcut Magic!
Set new timings while rehearsing Show/Hide black screen Show/Hide white screen Show/Hide pointer & button End slide show Go to the first or next hyperlink Go to the last or previous hyperlink
T B or Period W or Comma A or = ESC, CTRL+Break, Minus, END TAB SHIFT+TAB
Slide Show shortcuts Run the slide show and press the F1 key to view all keyboard shortcuts applicable when running a slide show.
This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information. Page 12
The Keyboard Shortcut Magic!
Part IV: Microsoft Outlook Keyboard Shortcuts
General Actions Action Send (post) a Message Reformat an email message from RTF to plain text Delete Message from message window New Contact Dialog New Office Document Read Warning Header To Save Non-Email Item in Current Folder Cancel the current operation Move up current level of treeview Move down current level of treeview Collapse current branch of treeview Expand current branch of treeview Open the Inbox Open the Outbox Launch go to folder dialog Save unfinished item in Drafts folder Move selected item to Deleted Items folder Open print dialog box To delete current item Mark message as unread or read Select all Copy highlighted items/text to clipboard Cut highlighted items/text to clipboard Paste items/text from clipboard Open application menu (to maximise, minimise etc) Create new item / Open or post a new message Undo Move cursor to top of email list Move cursor to end of email list Move edit cursor to top in new email message window Move edit cursor to end in new email message window
Keystroke Ctrl + Enter or Alt + S Ctrl + Shift + O Ctrl + D Ctrl + Shift + C Ctrl + Shift + H Ctrl + Insert + W Alt + S Escape Key Up Arrow Down Arrow Left Arrow Right Arrow Ctrl + I Ctrl + O Ctrl + Y Ctrl + S Delete Key Ctrl + P Ctrl + D Ctrl + Q or Ctrl + Enter Ctrl + A Ctrl + C Ctrl + X Ctrl + V Alt + Spacebar Ctrl + N Ctrl + Z Home End Ctrl + Home Ctrl + End
This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information. Page 13
The Keyboard Shortcut Magic!
Switch among Edit, Source, and Preview tabs Check Names Move cursor to Menu Bar Launch Advanced Find (find a message) Move to next Window pane Launch spell checker Insert signature Move directly to Inbox Move directly to Outbox Copy selected item(s) to a folder Create new folder dialog Move selected item to folder Create a new email message Create a new appointment item Create a new contact item Create a new task item Create a new note item Message options (from a new message window) Open address book Launch flag for follow up dialog box Reply to sender Reply to all Forward message
Ctrl + Tab Ctrl + K Alt + or F10 Ctrl + Shift + F or F3 F6 F7 Ctrl + Shift + S Ctrl + Shift + I Ctrl + Shift + O Ctrl + Shift + Y Ctrl + Shift + E Ctrl + Shift + V Ctrl + Shift + M Ctrl + Shift + A Ctrl + Shift + C Ctrl + Shift + K Ctrl + Shift + N Alt + P Ctrl + Shift + B Ctrl + Shift + G Ctrl + R Ctrl + Shift + R Ctrl + F
Calendar Week View Action Go to today’s date Go to a date Move to next date Down Arrow Move forward one week Move backwards one week Move to appointments on current date
Keystroke Alt + D Ctrl + G Down Arrow Up Arrow Page Down Page Up Tab (hit enter twice to open item)
Main Outlook Actions Action Say Line Say All
Keystroke Insert + Up Arrow Insert + Down Arrow
This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information. Page 14
The Keyboard Shortcut Magic!
Say Selected Text Move focus to attachments list In spellchecker read misspelled word and suggestion Read Header Field One Read Header Field Two Read Header Field Three Read Header Field Four Read Header Field Five Click Cc Button Click To Button Launch Global keystrokes listbox Close Office Assistant
Insert + Shift + Down Arrow Insert + A Insert + F7 Alt + 1 Alt + 2 Alt + 3 Alt + 4 Alt + 5 Alt + Shift + 4 Alt + Shift + 3 Insert + F8 Ctrl + Insert + F4
To access the free Excel 2007 tutorials, please visit http://www.msofficetutorial-training.com/excel-2007-tutorials.html Recommended Excel 2007 e-book:
The Ultimate Guide To Excel 2007! www.msoffice-tutorial-training.com/excel-2007-book.html To get more free Word 2007 tutorials, please visit http://www.msofficetutorial-training.com/word-2007-tutorials.html
This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information. Page 15
The Keyboard Shortcut Magic!
To access more free PowerPoint 2007 tutorials, please visit http://www.msoffice-tutorial-training.com/powerpoint-2007-tutorials.html Recommended PowerPoint 2007 e-book:
The Ultimate Guide to PowerPoint 2007! www.msoffice-tutorial-training.com/powerpoint-2007book.html
To Your Success! Wong Hing. www.msoffice-tutorial-training.com
This report provided by http://www.msoffice-tutorial-training.com. Visit the site for more FREE Office 2007 & 2003 tutorials and information. Page 16