Cheat Sheet

Microsoft Office 2010 For Dummies

From Office 2010 For Dummies by Wallace Wang

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

Microsoft Office 2010 Keyboard Shortcuts

Microsoft Office 2010 provides hundreds of commands, but you’ll likely only use a handful of those commands on a regular basis. To save time, use these 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 2010 Mouse Button Functions

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

Microsoft Office 2010 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 you the commands grouped under each ribbon tab for each of the four programs.

Word 2010 Ribbon Tabs
Ribbon Tab Name Command Groups Dialog Box Shortcut
Home Clipboard, Font, Paragraph, Styles, and Editing Ctrl+D (Font) or Alt+Ctrl+Shift+S (Styles)
Insert Pages, Tables, Illustrations, Links, Header and Footer, Text, and Symbols *
Page Layout Themes, Page Setup, Page Background, Paragraph, and Arrange *
References Table of Contents, Footnotes, Citation and Bibliography, Captions, Index, and Table of Contents *
Mailings Create, Start Mail Merge, Write and Insert Fields, Preview Results, and Finish *
Review Proofing, Language, Comments, Tracking, Changes, Compare, and Project *
View Document Views, Show, Zoom, Window, and Macros *
Excel 2010 Ribbon Tabs
Ribbon Tab Name Command Groups Dialog Box Shortcut
Home Clipboard, Font, Alignment, Styles, Cells, and Editing Ctrl+Shift+F (Font)
Insert Tables, Illustrations, Charts, Sparklines, Filter, Links, Text, and Symbols *
Page Layout Themes, Page Setup, Scale to Fit, Sheet Options, and Arrange *
Formulas Function Library, Defined Names, Formula Editing, and Calculation *
Data Get External Data, Connections, Sort and Filter, Data Tools, and Outline *
Review Proofing, Language, Comments, and Changes *
View Workbook Views, Show, Zoom, Window, and Macros *
PowerPoint 2010 Ribbon Tabs
Ribbon Tab Name Command Groups
Home Clipboard, Slides, Font, Paragraph, Drawing and Editing
Insert Tables, Images, Illustrations, Links, Text, Symbols, and Media
Design Page Setup, Themes, and Background
Transitions Preview, Transition to This Slide, and Timing
Animations Preview, Animation, Advanced Animation, and Timing
Slide Show Start Slide Show, Comments, and Compare
Review Proofing, Language, Comments, and Compare
View Presentation Views, Master Views, Show, Zoom, Color/Grayscale, Window, and Macros
Outlook 2010 Ribbon Tabs
Ribbon Tab Name Command Groups
Home (Mail) New, Delete, Respond, Quick Steps, Move, Tags, and Find
Send/Receive (Mail) Send and Receive, Download, Server, and Preferences
Folder (Mail) New, Actions, Clean Up, Favorites, and Properties
View (Mail) Current View, Arrangement, Layout, People Pane, and Window
Home (Calendar) New, Go To, Arrange, Manage Calendars, Share, and Find
Send/Receive (Calendar) Send and Receive, Download, 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 and 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 and Receive, Download, and Preferences
Folder (Tasks) New, Actions, Clean Up, Share, and Properties
View (Tasks) Current View, Arrangement, Layout, People Pane, and Window
Access 2010 Ribbon Tabs
Ribbon Tab Name Command Groups
Home Views, Clipboard, Sort and Filter, Records, Find, and Text Formatting
Create Templates, Tables, Forms, Reports, and Macros and Code
External Data Import and Link, Export, and Collect Data
Database Tools Macro, Relationships, Analyze, Move Data, and Add-Ins
  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.