Cheat Sheet

Microsoft Office 2016 For Dummies Cheat Sheet

From Office 2016 For Dummies

By Wallace Wang

Microsoft Office 2016 comes jam-packed with features. See shortcuts and tips for using the keyboard, mouse, and ribbon to get fast access to the most commonly used commands. You’ll master Office 2016 in no time!

Microsoft Office 2016 Keyboard Shortcuts

Microsoft Office 2016 provides hundreds of commands, but you’ll likely only use a handful of those commands on a regular basis. To save time, use these Office 2016 keyboard shortcuts. With little effort, you can open files, find content, edit that content, and more!

Function Keystroke
Copy Ctrl+C
Cut Ctrl+X
Find Ctrl+F
Go To Ctrl+G
Help F1
Hyperlink Ctrl+K
New Ctrl+N
Open Ctrl+O
Paste Ctrl+V
Print Ctrl+P
Replace Ctrl+H
Save Ctrl+S
Select All Ctrl+A
Spell Check F7
Undo Ctrl+Z
Redo Ctrl+Y

Microsoft Office 2016 Mouse Button Functions

You can control Microsoft Office 2016 with your mouse or your keyboard. The mouse actions in this table work whether you’re using Word, Excel, Access, PowerPoint, or Outlook.

Mouse Button Used Action Purpose
Left mouse button Click Moves the cursor, highlights an object, pulls down a menu, or
chooses a menu command
Left mouse button Double-click Highlights a word or edits an embedded object
Left mouse button Triple-click Highlights a paragraph
Left mouse button Drag Moves an object, resizes an object, highlights text, or
highlights multiple objects
Wheel mouse button Click Automatically scrolls a document when you move the mouse up or
down
Wheel mouse button Roll Scrolls a document up or down
Right mouse button Right-click Displays a shortcut pop-up menu

Microsoft Office 2016 Ribbon Tabs

Microsoft Office 2016 displays commands in a series of icons stored on different tabs. This combination of icons and tabs is known as the Ribbon interface, which appears in Word, PowerPoint, Excel, Outlook, and Access. The following tables show the commands grouped under each ribbon tab for each of the five programs.

Here are the commands for Microsoft Word 2016.

Ribbon Tab Name Command Groups Dialog Box Shortcut Key
Home Clipboard, Font, Paragraph, Styles, and Editing Ctrl+D (Font)
Alt+Ctrl+Shift+S (Styles)
Insert Tables, Illustrations, Add-ins, Media, Comments, Header &
Footer, and Text
Design Document Formatting and Page Background
Layout Page Setup, Paragraph, and Arrange
References Table of Contents, Footnotes, Citations & Bibliography,
Captions, Index, and Table of Authorities
Mailings Create, Start Mail Merge, Write & Insert Fields, Preview
Results, and Finish
Review Proofing, Insights, Language, Comments, Tracking, Changes, and
Compare
View Views, Show, Zoom, Window, and Macros

Here are the useful things you should know for Excel 2016.

Ribbon Tab Name Command Groups Dialog Box Shortcut Key
Home Clipboard, Font, Alignment, Number, Styles, Cells, and
Editing
Ctrl+Shift+F (Font)
Insert Tables, Charts, Tours, Sparklines, Filter, and Links
Page Layout Themes, Page Setup, Scale to Fit, Sheet Options, and
Arrange
Formulas Function Library, Defined Names, Formula Auditing, and
Calculation
Data Get & Transform, Connections, Sort & Filter, Data
Tools, Forecast, and Outline
Review Proofing, Insights, Language, Comments, and Changes
View Workbook Views, Show, Zoom, Window, and Macros

Here are the Microsoft PowerPoint commands that you should know.

Ribbon Tab Name Command Groups
Home Clipboard, Slides, Font, Paragraph, Drawing, and Editing
Insert Slides, Tables, Images, Illustrations, Links, Comments, Text,
and Media
Design Themes, Variants, and Customize
Transitions Preview, Transition To This Slide, and Timing
Animations Preview, Animation, Advanced Animation, and Timing
Slide Show Start Slide Show, Set Up, and Monitors
Review Proofing, Insights, Language, Comments, Compare and Ink
View Presentation Views, Master Views, Show, Zoom, Color/Grayscale,
Window, and Macros

This list wouldn’t be complete without these useful Outlook 2016 commands.

Ribbon Tab Name Command Groups
Home (Mail) New, Delete, Respond, Move, Tags, Find, and Send/Receive
Send/Receive (Mail) Send & Receive, Download, Server, and Preferences
Folder (Mail) New, Actions, Clean Up, Favorites, IMAP, and Properties
View (Mail) Current View, Messages, Arrangement, Layout, People Pane, and
Window
Home (Calendar) New, Go To, Arrange, Manage Calendars, Share, and Find
Send/Receive (Calendar) Send & Receive, Download, and Preferences
Folder (Calendar) New, Actions, Share, and Properties
View (Calendar) Current View, Arrangement, Color, Layout, People Pane, and
Window
Home (Contacts) New, Delete, Communicate, Current View, Actions, Share, Tags,
and Find
Send/Receive (Contacts) Send & Receive, Download, and Preferences
Folder (Contacts) New, Actions, Share, and Properties
View (Contacts) Current View, Arrangement, Layout, People Pane, and Window
Home (Tasks) New, Delete, Respond, Manage Task, Follow Up, Current View,
Actions, Tags, and Find
Send/Receive (Tasks) Send & Receive, Download, and Preferences
Folder (Tasks) New, Actions, Share, and Properties
View (Tasks) Current View, Arrangement, Layout, People Pane, and Window

And finally, don’t forget these handy Microsoft Access 2016 commands.

Ribbon Tab Name Command Groups
Home Views, Clipboard, Sort & Filter, Records, Find, and Text
Formatting
Create Templates, Tables, Queries, Forms, Reports, and Macros &
Code
External Data Import & Link and Export
Database Tools Tools, Macro, Relationships, Analyze, Move Data, and
Add-Ins