Microsoft Office 2013 Tips and Tricks


Microsoft Office 2013 Keyboard Shortcuts

Microsoft Office 2013 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 2013 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 2013 Ribbon Tabs

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

Microsoft Word 2013 Ribbon Tabs
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, Apps, Media, Links, Header & Footer, Text, and Symbols
Design Document Formatting and Page Background
Page Layout Page Setup, Paragraph, and Arrange
References Table of Contents, Footnotes, Citation & Bibliography, Captions, Index, and Table of Authorities
Mailings Create, Start Mail Merge, Write & Insert Fields, Preview Results, and Finish
Review Proofing, Language, Comments, Tracking, Changes, Compare, and Protect
View Views, Show, Zoom, Window, and Macros

 

Microsoft Excel 2013 Ribbon Tabs
Ribbon Tab Name Command Groups Dialog Box Shortcut Key
Home Clipboard, Font, Alignment, Number, Styles, Cells, and Editing Ctrl+Shift+F (Font)
Insert Tables, Illustrations, Apps, Charts, Reports, Spark lines, Filter, Links, Text, and Symbols
Page Layout Themes, Page Setup, Scale to Fit, Sheet Options, and Arrange
Formulas Function Library, Defined Names, Formula Auditing, and Calculation
Data Get External Data, Connections, Sort & Filter, Data Tools, and Outline
Review Proofing, Language, Comments, and Changes
View Workbook Views, Show, Zoom, Window, and Macros

 

 

Microsoft PowerPoint 2013 Ribbon Tabs
Ribbon Tab Name Command Groups
Home Clipboard, Slides, Font, Paragraph, Drawing, and Editing
Insert Slides, Tables, Images, Illustrations, Apps, Links, Comments, Text, Symbols, 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, Language, Comments, and Compare
View Presentation Views, Master Views, Show, Zoom, Color/Grayscale, Window, and Macros

 

Microsoft Outlook 2013 Ribbon Tabs
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, 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

 

Microsoft Access 2013 Ribbon Tabs
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

Office 2013 Top Tips and Tricks

Can I change the color or theme to black, blue or silver?

Microsoft Office 2013 has to be changed theme per application (Outlook, Word, Excel, etc) and contains the default (white) theme, a Light Grey, and Dark Grey theme. I would recommend running the Light Grey or Dark Grey theme for added contrast between items, especially in Outlook.

You can also change the decoration in the top right corner.  You then have 14 different backgrounds to choose from (and a “No Background” option).

How do I get back the full contact editing window?
By default, even when double clicking on a contact in the Contacts folder, you’ll open the Contact Card of that specific contact. While it does allow you to modify the primary properties of a contact, is doesn’t hold all the fields of the full contact window.

To open the full contact window, there are a couple of options:

  • Select the contact in the Contacts folder and in the Reading Pane, click on any of the links under the Profile section to open that specific contact item. To quickly switch to your Contacts folder, use CTRL+3 or press on the People link at the bottom.
  • Open the Contact Card first (for instance, by right clicking on the contact picture or email address of a received message in the Reading Pane and choosing “Open Contact Card) and then click on any of the links under the Profile section to open that specific contact item.
  • Switch the view of your Contacts folder from People to any of the other available views such as Business Cards, Phone or List.
  • There is also a Registry value to always open the traditional Contact Form when double clicking on a contact rather than the Contact Card.


How can I disable in-line reply in the Reading Pane?

To provide a more streamlined experience without the need of popping up extra message windows and dialogs anymore, Outlook 2013 introduces in-line reply which allows you to press reply and directly start writing your reply in the Reading Pane (which means that it is not really a Reading Pane anymore and they should have changed the name).

You can press POP OUT to open your message in a regular Message editor window which provides access to additional formatting options and features.

To always use the regular Message editor window instead of in-line reply, enable the option-
File-> Options-> Mail-> Replies and Forwards-> Open replies and forwards in a new window

In the Calendar section, how can I change or add locations to the weather information?

Click on the location name in the Calendar and select Add location. If your town/village/city can’t be found, try searching for a larger city near you instead. You can add up to 5 locations.

To remove a location, click on the location name to bring out a dropdown list with the configured location. Hover on a location name and you’ll see an X appear. Click on it to remove the location.
Where is the Notes folder?
Due to its limited usage, the Notes folder is a bit more hidden. You can still access it by clicking on the … indicator next to Tasks. To make it permanently visible, choose Navigation Options… and either move up the Notes module or increase the “Maximum number of visible items” from 4 to 5.

Note that you can also access the Notes folder via the keyboard shortcut CTRL+5

Why aren’t my folders sorted alphabetically?

Being able to sort your folders in a freehand order is a feature that was added by user request. If you rather have your folders sorted alphabetically, you can do so via- Tab: Folder-> button: Show All Folder A to Z

Note: that this only applies to subfolders and not to any default/special top-level folder such as Inbox, Drafts, Sent, etc.

When searching the Inbox folder, it searches the entire mailbox!
To change your search scope, you can use the dropdown list in the Search field or the options on the Search tab in the Ribbon.

To change the default search scope back to just the Inbox folder use- File-> Options-> Search-> Include results only from: Current folder

Can I put the Mail, Calendar, People and Tasks navigation back in the Navigation Pane?

Yes, you can do so by pressing the … indicator on the Navigation strip and choose Navigation Options. Then Check Compact Navigation.


Leave a Reply

Your email address will not be published. Required fields are marked *

Related Posts

Microsoft

Azure AD and Manual UPN Update

In Azure AD, the UserPrincipalName (UPN) can be manually updated using Set-MsolUserPrincipalName Power Shell cmdlet.  The details and syntax are explained here – https://msdn.microsoft.com/en-us/library/azure/dn194135.aspx One of the common issues you experience during this process is Read more…

Microsoft

Azure Password Reset – The Password you’ve selected does not meet your Active Directory password policy

This is a common error message when you try to reset a password from Azure management port or Self service portal.  The error message is very clear here – “The Password you’ve selected does not Read more…

Microsoft

Azure – Your account is temporarily locked to prevent unauthorized use

Here is the another common error message when dealing with directory and password synchronization.  Error Message: Your account is temporarily locked to prevent unauthorized use. Try again later. Contact Customer Support if the problem persists Read more…