Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Cheat Sheet

Office 2007 For Dummies

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 down
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 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, Comments, Tracking, Changes, Compare, and Protect
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 Editing
Insert Shapes, Tables, Illustrations, Charts, Links, and Text
Page Layout Themes, Page Setup, Scale to Fit, Sheet Options, and Arrange
Formulas Function Library, Named Cells, Formula Auditing, and Calculation
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 Editing
Insert Shapes, Slides, Tables, Illustrations, Links, Text, and Media Clips
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 Window


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 Administrator
Datasheet (Only visible when you have a datasheet open) Views, Fields and Columns, Data Type and Formatting, and Relationships
  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!