Cheat Sheet

Office 2007 For Dummies Cheat Sheet

From Office 2007 For Dummies

By Wallace Wang

The new, big thing in Microsoft Office 2007 is the command ribbon that lets you access menus and accomplish tasks with speed and agility. You also have the usual assortment of keyboard shortcuts that save time and effort; plus, you can use the mouse in combination with keys and actions to do what you need to do.

Keyboard Shortcuts for Microsoft Office 2007

Microsoft Office 2007 is full of timesaving keyboard shortcuts. Zip through components of Office 2007 — Word, Excel, Outlook, PowerPoint, and Access — by using handy shortcut keys from the following table. 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 2007 Mouse Button Functions

With Microsoft Office 2007, your mouse takes on an active role in helping you navigate through all the Office 2007 programs. 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
Wheel mouse button Roll Scrolls a document up or down
Right mouse button Right-click Displays a shortcut pop-up menu

How to Use Ribbon Tabs in Microsoft Office 2007 Programs

Microsoft Office 2007 boasts a new navigation tool — the command ribbon that runs through Word, PowerPoint, Excel, and Access. Use the tabs on the ribbon in each program to work with and within files in every component. The following tables show the commands grouped under each ribbon tab for each of the four programs:

Microsoft Word 2007 Ribbon Tabs
Ribbon Tab Name Command Groups
Home Clipboard, Font, Paragraph, Styles, and Editing
Insert Shapes, Pages, Tables, Illustrations, Links, Header &
Footer, Text, and Symbols
Page Layout Themes, Page Setup, Page Background, Paragraph, and
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, Comments, Tracking, Changes, Compare, and
View Document Views, Show/Hide, Zoom, and Window
Microsoft Excel 2007 Ribbon Tabs
Ribbon Tab Name Command Groups
Home Clipboard, Font, Alignment, Number, Styles, Cells, and
Insert Shapes, Tables, Illustrations, Charts, Links, and Text
Page Layout Themes, Page Setup, Scale to Fit, Sheet Options, and
Formulas Function Library, Named Cells, Formula Auditing, and
Data Get External Data, Manage Connections, Sort & Filter, Data
Tools, and Outline
Review Proofing, Comments, and Changes
View Workbook Views, Show/Hide, Zoom, and Window
Microsoft PowerPoint 2007 Ribbon Tabs
Ribbon Tab Name Command Groups
Home Clipboard, Slides, Font, Paragraph, WordArt Styles, and
Insert Shapes, Slides, Tables, Illustrations, Links, Text, and Media
Design Page Setup, Themes, Background, and Arrange
Animations Preview, Animations, and Transition To This Slide
Slide Show Start Slide Show, Set Up, and Monitors
Review Proofing and Comments
View Presentation Views, Show/Hide, Zoom, Color/Grayscale, and
Microsoft Access 2007 Ribbon Tabs
Ribbon Tab Name Command Groups
Home Views, Clipboard, Font, Rich Text, Records, Sort & Filter,
Window, and Find
Create Tables, Forms, Reports, and Other
External Data Import, Export, Collect Data, and SharePoint Lists
Database Tools Macro, Show/Hide, Analyze, Move Data, Database Tools, and
Datasheet (Only visible when you have a datasheet open) Views, Fields and Columns, Data Type and Formatting, and