KeyBoard Shortcuts for Microsoft Office

Keyboard access to the ribbon: Similar to the Vim-inspired add-ons for Chrome and  Firefox

Basic keyboard shortcuts in all Office Apps: , Office 2013 and 2016 have a feature called Key Tips. When Key Tips appears by pressing Alt the Ribbon menu is overlaid with letters. Pressing a letter launches the corresponding menu item.

Excel Keyboard Shortcuts

Ctrl +  PgDn: Switch between worksheet tabs, moving left to right.
Ctrl  + PgUp: Switch between worksheet tabs, moving right to left.
F12 : Display the “Save As” dialog.
Ctrl  + Shift + $: (Excel 2016) Current cell formatted as currency, with two decimal places and negative numbers in parentheses.
Ctrl  + Shift + %: (Excel 2016) Current cell formatted as percentage with no decimal places.
Ctrl  + Shift + #: (Excel 2016) Current cell formatted as date with day, month, year.
Ctrl  + Shift + “:”: Insert current time.
Ctrl + Shift + “;” :  Insert current date.
F4 : Repeats the last command or action, if possible.
Shift  + Arrow key: Extends your current cell selection by one addition cell in the direction specified.
Ctrl  + F1: Display or hide the Ribbon.
Alt  + Shift + F1: Insert a new worksheet tab.
Ctrl  + F4: Close the current workbook.

Word Keyboard Shortcuts

Ctrl + F1: Display or hide the Ribbon.
Ctrl + K: Insert a hyperlink for the selected text.
Ctrl + F: Open the search box in the navigation pane.
Alt + Ctrl + S: Split or remove split in the document window.
Ctrl + Backspace: Delete one word to the left.
Shift + F3: Change the case of the selected letters.
Alt + Shift + W:  Underline the selected words, but not the spaces included in the selection.
Ctrl + 1: Set single-line spacing.
Ctrl + 2: Set double-line spacing.
Ctrl + 5: Set 1.5-line spacing.
Ctrl + Y: Re-do the last action.
Ctrl + Enter: Insert page break.
Ctrl + W: Close the current document.
Alt + F4: Close the program

PowerPoint Keyboard Shortcuts

F6 : Move clockwise between panes in Normal view.
F4:  Repeat the last action.
Shift  + F6: Move counter-clockwise between panes.
Alt  + Shift + Left Arrow: Move one paragraph up.
Alt  + Shift + Right Arrow: Move one paragraph down.
Alt  + Shift + Down Arrow: Move selected paragraphs up.
Alt  + Shift + Down Arrow: Move selected paragraphs down
Ctrl  + Shift + >: Increase the font size.
Ctrl  + Shift + <: Decrease the font size.
CTRL  + M: Add a new slide.
Alt  + Shift + F9: Show/Hide the ruler
Shift  + F3: Cycle the case for the selected text.
Ctrl  + Home: Jump to the beginning of the first word in a text container
Ctrl  + End: Jump to the end of the last word in a text container
Alt  + Right Arrow: Rotate selected slide object by 15 degrees clockwise (Using this shortcut with the left arrow does the reverse)

 

AND THERE'S MORE...

500 Keyboard Shortcuts for Microsoft Office

Picture
 

Massively speed up your use of Microsoft Office with this comprehensive booklet of keyboard shortcuts for Excel, Word and PowerPoint.

 
SEND ME MY FREE COPY