5/11/2019

Excel 2016 Shortcuts Pdf

82
Excel 2016 Shortcuts Pdf 4,5/5 1127 votes

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!

  1. Excel Shortcuts 2016 Pdf Free Download
  2. Excel Shortcuts Keys 2016 Pdf Download
  3. Excel 2016 Shortcut Keys

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!

Excel Shortcuts 2016 Pdf Free Download

FunctionKeystroke
CopyCtrl+C
CutCtrl+X
FindCtrl+F
Go ToCtrl+G
HelpF1
HyperlinkCtrl+K
NewCtrl+N
OpenCtrl+O
PasteCtrl+V
PrintCtrl+P
ReplaceCtrl+H
SaveCtrl+S
Select AllCtrl+A
Spell CheckF7
UndoCtrl+Z
RedoCtrl+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 UsedActionPurpose
Left mouse buttonClickMoves the cursor, highlights an object, pulls down a menu, or
chooses a menu command
Left mouse buttonDouble-clickHighlights a word or edits an embedded object
Left mouse buttonTriple-clickHighlights a paragraph
Left mouse buttonDragMoves an object, resizes an object, highlights text, or
highlights multiple objects
Wheel mouse buttonClickAutomatically scrolls a document when you move the mouse up or
down
Wheel mouse buttonRollScrolls a document up or down
Right mouse buttonRight-clickDisplays a shortcut pop-up menu
Excel 2016 Shortcuts Pdf

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 NameCommand GroupsDialog Box Shortcut Key
HomeClipboard, Font, Paragraph, Styles, and EditingCtrl+D (Font)
Alt+Ctrl+Shift+S (Styles)
InsertTables, Illustrations, Add-ins, Media, Comments, Header &
Footer, and Text
DesignDocument Formatting and Page Background
LayoutPage Setup, Paragraph, and Arrange
ReferencesTable of Contents, Footnotes, Citations & Bibliography,
Captions, Index, and Table of Authorities
MailingsCreate, Start Mail Merge, Write & Insert Fields, Preview
Results, and Finish
ReviewProofing, Insights, Language, Comments, Tracking, Changes, and
Compare
ViewViews, Show, Zoom, Window, and Macros
Download

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

Ribbon Tab NameCommand GroupsDialog Box Shortcut Key
HomeClipboard, Font, Alignment, Number, Styles, Cells, and
Editing		Ctrl+Shift+F (Font)
InsertTables, Charts, Tours, Sparklines, Filter, and Links
Page LayoutThemes, Page Setup, Scale to Fit, Sheet Options, and
Arrange
FormulasFunction Library, Defined Names, Formula Auditing, and
Calculation
DataGet & Transform, Connections, Sort & Filter, Data
Tools, Forecast, and Outline
ReviewProofing, Insights, Language, Comments, and Changes
ViewWorkbook Views, Show, Zoom, Window, and Macros

Excel Shortcuts Keys 2016 Pdf Download

Here are the Microsoft PowerPoint commands that you should know.

Excel 2016 Shortcut Keys

Ribbon Tab NameCommand Groups
HomeClipboard, Slides, Font, Paragraph, Drawing, and Editing
InsertSlides, Tables, Images, Illustrations, Links, Comments, Text,
and Media
DesignThemes, Variants, and Customize
TransitionsPreview, Transition To This Slide, and Timing
AnimationsPreview, Animation, Advanced Animation, and Timing
Slide ShowStart Slide Show, Set Up, and Monitors
ReviewProofing, Insights, Language, Comments, Compare and Ink
ViewPresentation Views, Master Views, Show, Zoom, Color/Grayscale,
Window, and Macros

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

Ribbon Tab NameCommand 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 NameCommand Groups
HomeViews, Clipboard, Sort & Filter, Records, Find, and Text
Formatting
CreateTemplates, Tables, Queries, Forms, Reports, and Macros &
Code
External DataImport & Link and Export
Database ToolsTools, Macro, Relationships, Analyze, Move Data, and
Add-Ins