Microsoft Office 2008 for Mac All-in-One For Dummies Cheat Sheet
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.
|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
|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
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
|Customize keyboard shortcuts||Choose Tools→Customize Keyboard to set up keyboard
|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
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
|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
|Start a new project||Choose New→Project from the File menu.|
|Create rules||Choose Tools→Rules to make all sorts of rules to automate