Cheat Sheet

Microsoft Office 2019 For Dummies Cheat Sheet

From Office 2019 For Dummies

By Wallace Wang

Microsoft Office 2019 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 2019 in no time!

Microsoft Office 2019 Keyboard Shortcuts

Microsoft Office 2019 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 2019 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 2019 Mouse Button Functions

You can control Microsoft Office 2019 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 2019 Ribbon Tabs

Microsoft Office 2019 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 2019.

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 Pages, Tables, Illustrations, Add-ins, Media, Links, Comments, Header & Footer, Text, and Symbols
Draw Tools, Pens, and Convert
Design Document Formatting and Page Background
Layout Page Setup, Paragraph, and Arrange
References Table of Contents, Footnotes, Research, Citations & Bibliography, Captions, Index, and Table of Authorities
Mailings Create, Start Mail Merge, Write & Insert Fields, Preview Results, and Finish
Review Proofing, Speech, Accessibility, Language, Comments, Tracking, Changes, Compare, Protect, and OneNote
View Views, Immersive, Page Movement, Show, Zoom, Window, Macros, and SharePoint

 

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

Ribbon Tab Name Command Groups Dialog Box Shortcut Key
Home Clipboard, Font, Alignment, Number, Styles, Cells, and Editing Ctrl+Shift+F (Format Cells)
Insert Tables, Illustrations, Add-ins, Charts, Tours, Sparklines, Filter, Links, and Symbols
Draw Tools, Pens, and Convert
Page Layout Themes, Page Setup, Scale to Fit, Sheet Options, and Arrange
Formulas Function Library, Defined Names, Formula Auditing, and Calculation
Data Get & Transform, Queries & Connections, Sort & Filter, Data Tools, Forecast, and Outline
Review Proofing, Accessibility, Insights, Language, Comments, and Protect
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, Add-ins, Links, Comments, Text, Symbols, and Media
Draw Tools, Pens, Stencils, and Convert
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, Accessibility, Insights, Language, Comments, Compare and OneNote
View Presentation Views, Master Views, Show, Zoom, Color/Grayscale, Window, and Macros

 

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

Ribbon Tab Name Command Groups
Home (Mail) New, Delete, Respond, Quick Steps, 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, Skype Meeting, 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 2019 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