Cheat Sheet

Microsoft Office 2008 for Mac All-in-One For Dummies Cheat Sheet

From Office 2008 for Mac All-in-One For Dummies

By Geetesh Bajaj, Jim Gordon

Get the most out of Microsoft Office 2008 for Mac with handy tips for working in Office in general as well as word-processing in Word, making spreadsheets in Excel, creating PowerPoint slides, and e-mailing with Entourage.

Tips that Work throughout Office 2008 for Mac

Use these common commands and features throughout all of Office 2008 for Mac’s applications.

Command/Feature How to Access It
Undo Look for the Undo button on the Standard toolbar or press the
keyboard combination Command-Z.
Multiple Undo Click the tiny triangle next to the Undo button to see a pop-up
menu of available Undo actions.
Select All Choose Edit→Select All or press Command-A to select
everything in your document, including tables, charts, pictures,
and other objects.
Help Free training movies and online courses are now available in
Office 2008 Help. Click the Help button on any of the toolbars and
explore topics under Popular Training. You’ll also find them in
Help search results.
Pop-up menus Right-click or Control-click just about anywhere on the screen
to get context-sensitive menus.
Copy Press Command-C.
Cut Press Command-X.
Paste Press Command-V.
Menu bar Press Control-F2 to activate the menu bar. Then use the arrow
keys to navigate the menu and press the spacebar to activate a menu
item.
Dock Press Control-F3 to activate the Dock. Then use the arrow keys
to navigate the menu and press the spacebar to activate a menu
item.

Tips and Tools for Working with Word 2008 for Mac

Improve word-processing efficiency in Word 2008 for Mac with these handy commands and tools.

Print Layout view Choose View→Print Layout to work with word processing
documents the traditional way.
Notebook Layout view Choose View→Notebook Layout for taking typed notes and
recording audio notes of meetings and classes.
Publishing Layout view Choose View→Publishing Layout to make newsletters and
other publications.
Customize keyboard shortcuts Choose Tools→Customize Keyboard to set up keyboard
shortcuts.
Customize menus and toolbars Choose View→Customize Menus and Toolbars to create and
fine-tune your menus and toolbars.
Change font sizes Use the slider bar on the Formatting Palette.
Display Reference Tools Press Option-Command-R to display Reference Tools on the Object
Palette.

Tips and Tricks for Excel 2008 for Mac

How to stay in charge of spreadsheets in Excel 2008 for Mac? Use these quick steps for your most common activities.

Rename a worksheet Double-click a sheet tab to change its name.
Edit cells Double-click a cell to edit the cell formula or cell contents
on the worksheet.
File timesaver Save your files as Excel Binary Workbook (.xlsb) to get a much
smaller file that opens and saves faster.
Create table rows and columns Choose Insert→List to start the List Wizard, which helps
you create row and column tables for your data.
Alternative menu options Hold down the Shift key while navigating Excel’s menus to
see alternative options.

Perfecting PowerPoint 2008 for Mac Presentation Skills

Learn how to spruce up your slide presentations with these handy PowerPoint 2008 for Mac features.

Cross-platform presentations To play your presentations on other platforms, install
Flip4Mac, a free QuickTime codec that enables you to play
Windows Media Video format in QuickTime.
Print handouts To print handouts with lines for taking notes, choose
File→Print. Look for the Print What pop-up menu and choose
Handouts (3 Slides per Page).
Create a PowerPoint package To create a package that has all DRM-free media properly
linked, choose File→Save As. In the Format pop-up menu, choose
PowerPoint Package.
Notes Page View Choose View→Notes Page to work in a special view that
allows you to see your slide and create extensive notes.

Entourage 2008 for Mac Basics

Manage and manipulate your e-mail, calendar, and contacts with these Entourage 2008 for Mac tips.

Customize toolbars Choose View→Customize Toolbar.
Work offline If you lose your Internet connection, choose
Entourage→Work Offline. Choose the same menu option again when
you can reconnect. Entourage records all your actions while
you’re away so you can even create and queue mail messages
and Calendar invitations.
Search Press Command-F to initiate a powerful search within
Entourage.
Start a new project Choose New→Project from the File menu.
Create rules Choose Tools→Rules to make all sorts of rules to automate
Entourage.