Office 2007 All-in-One Desk Reference For Dummies®
Published by
Wiley Publishing, Inc.
111 River St.
Hoboken, NJ 07030-5774
Copyright © 2007 by Wiley Publishing, Inc., Indianapolis, Indiana
Published by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317) 572-3447, fax (317) 572-4355, or online at .
Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates in the United States and other countries, and may not be used without written permission. Microsoft is a registered trademark of Microsoft Corporation in the United States and/or other countries. All other trademarks are the property of their respective owners. Wiley Publishing, Inc., is not associated with any product or vendor mentioned in this book.
LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: The publisher and the author make no representations or warranties with respect to the accuracy or completeness of the contents of this work and specifically disclaim all warranties, including without limitation warranties of fitness for a particular purpose. No warranty may be created or extended by sales or promotional materials. The advice and strategies contained herein may not be suitable for every situation. This work is sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional services. If professional assistance is required, the services of a competent professional person should be sought. Neither the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Website is referred to in this work as a citation and/or a potential source of further information does not mean that the author or the publisher endorses the information the organization or Website may provide or recommendations it may make. Further, readers should be aware that Internet Websites listed in this work may have changed or disappeared between when this work was written and when it is read. FULFILLMENT OF EACH COUPON OFFER IS THE SOLE RESPONSIBILITY OF THE OFFEROR.
For general information on our other products and services, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002.
For technical support, please visit .
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in electronic books.
Library of Congress Control Number: 2006925911
ISBN: 978-0-471-78279-7
Manufactured in the United States of America
10 9 8 7 6 5
1B/RV/QS/QY/IN
Peter Weverka is the bestselling author of several For Dummies books, including PowerPoint 2007 All-in-One Desk Reference For Dummies and Microsoft Money For Dummies, as well as 30 other computer books about various topics. Peter’s humorous articles and stories — none related to computers, thankfully — have appeared in Harper’s, SPY, The Argonaut, and other magazines for grown-ups.
For Aiko Sofia and Henry Gabriel.
Many hard-working people at Wiley Publishing in Indiana had a hand in this book, and I would like to thank all of them. I am especially grateful to Steve Hayes for giving me the opportunity to write this and other For Dummies books.
Many thanks as well go to Jean Rogers, this book’s project editor, for her diligence and grace under pressure, and Jennifer Riggs and Mary Lagu for their copy editing skills. Technical editors Joyce Nielsen and Lee Musik made sure that all the explanations in this book are indeed accurate, and I would like to thank them for their excellent work and suggestions for improving this book. I would also like to give a special thanks to Joe Stockman for his work in Book VI about Access. I would also like to thank Rich Tennant for the witty cartoons you will find on the pages of this book and Richard Shrout for writing the index. Many other people at the Wiley office in Indianapolis gave their all to this book; their names are listed on the following page in the publisher’s acknowledgements.
Finally, I owe my family — Sofia, Henry, and Addie — a debt for tolerating my vampire-like working hours and eerie demeanor at the breakfast table. How will I ever repay you?
We’re proud of this book; please send us your comments through our online registration form located at .
Some of the people who helped bring this book to market include the following:
Acquisitions, Editorial, and Media Development
Associate Project Editor: Jean Rogers
Acquisitions Editor: Steven Hayes
Copy Editors: Jennifer Riggs, Mary Lagu
Technical Editors: Joyce Nielsen, Lee Musick
Editorial Manager: Kevin Kirschner
Media Development Specialists: Angela Denny, Kate Jenkins, Steven Kudirka, Kit Malone
Media Development Coordinator: Laura Atkinson
Media Project Supervisor: Laura Moss
Media Development Manager: Laura VanWinkle
Media Development Associate Producer: Richard Graves
Editorial Assistant: Amanda Foxworth
Sr. Editorial Assistant: Cherie Case
Cartoons: Rich Tennant ()
Composition Services
Project Coordinator: Erin Smith
Layout and Graphics: Claudia Bell, Joyce Haughey, Stephanie D. Jumper, Barbara Moore, Heather Ryan, Rashell Smith
Proofreaders: John Greenough, Sossity R. Smith, Melba Hopper, Brian H. Walls
Indexer: Richard Shrout
Anniversary Logo Design: Richard Pacifico
Publishing and Editorial for Technology Dummies
Richard Swadley, Vice President and Executive Group Publisher
Andy Cummings, Vice President and Publisher
Mary Bednarek, Executive Acquisitions Director
Mary C. Corder, Editorial Director
Publishing for Consumer Dummies
Diane Graves Steele, Vice President and Publisher
Joyce Pepple, Acquisitions Director
Composition Services
Gerry Fahey, Vice President of Production Services
Debbie Stailey, Director of Composition Services
This book is for users of Office 2007 who want to get to the heart of the program without wasting time. Don’t look in this book to find out how the different programs in the Office suite work. Look in this book to find out how you can get your work done better and faster with these programs.
I show you everything you need to make the most of the different Office programs. On the way, you have a laugh or two. No matter how much or how little skill you bring to the table, the guidance of this book will make you a better, more proficient, more confident user of the Office programs.
Office 2007 is radically different from its predecessors — you can tell as soon as you open your first Office 2007 program. Office has been given a facelift. The menus and toolbars that used to appear along the top of the program windows are gone and have been replaced by command tabs and a Ribbon. Instead of opening menus, you click buttons or make gallery choices. Behind the scenes, the makers of Office have made many features — charts, diagrams, shapes, and others — available to all or most of the programs. The Office suite offers more commands and features than ever before. It gives you many, many opportunities to exercise your creativity and computer prowess.
This book is your guide to making the most of the Office programs. It’s jampacked with how-to’s, advice, shortcuts, and tips. Here’s a bare outline of the eight parts of this book:
Book I: Common Office Tools: Looks into the many commands and features that are common to all or several of the Office programs. Master the material in Book I and you’re well on your way to mastering all the programs. Book I explains handling text, the proofing tools, charts, diagrams, and tables. It explores speed techniques that can make you more productive in most of the Office programs, as well as how to draw and manipulate lines, shapes, clip-art, and other so-called objects.
Book II: Word 2007: Explains the numerous features in Office’s word processor, including how to create documents from letters to reports. Use the techniques described here to turn Word into a desktop-publishing program and quickly dispatch office tasks such as mass-mailings. You also discover how to get Word’s help in writing indexes, bibliographies, and other items of interest to scholars.
Book III: Outlook 2007: Shows you how to send and receive e-mail messages and files, as well as track tasks, maintain an address book, and keep a calendar with Outlook. If you’re one of those people who receive numerous e-mail messages each day, you’ll be delighted to discover all the ways to track and manage e-mail — and junk e-mail — in Outlook.
Book IV: PowerPoint 2007: Demonstrates how to construct a meaningful presentation that makes the audience say, “Wow!” Included in Book IV are instructions for making a presentation livelier and more original, both when you create your presentation and when you deliver it.
Book V: Excel 2007: Shows the many different ways to crunch the numbers with the bean counter in the Office suite. Along the way, you find out how to design worksheets that are easy to read and understand, use data-validation rules to cut down on entry mistakes, and analyze your data. You find out just how useful Excel can be for financial analyses, data tracking, and forecasting.
Book VI: Access 2007: Describes how to create a relational database for storing information, as well as query the database for information and gather information into meaningful reports. Don’t be frightened by the word “database.” You’ll be surprised to discover how useful Access can be in your work.
Book VII: Publisher 2007: Shows how to create brochures, pamphlets, newsletters, and other publications with the “print shop in a can.”
Book VIII: Office 2007 — One Step Beyond: For people who want to take full advantage of Office, Book VIII delves into customizing the Office programs, recording and running macros, and collaborating with the SharePoint Services software. It looks into some auxiliary programs that come with Office, including OneNote, Picture Manager, and Clip Organizer. It also looks into alternative ways to distribute your work — in a blog or a Web page, for example.
You’re holding in your hands a computer book designed to make mastering the Office programs as easy and comfortable as possible. Besides the fact that this book is easy to read, it’s different from other books about Office. Read on to see why.
This book is a reference, which means that readers have to be able to find instructions quickly. To that end, I have taken great pains to make sure that the material in this book is well organized and easy to find. The descriptive headings help you find information quickly. The bulleted and numbered lists make following instructions simpler. The tables make options easier to understand.
I want you to be able to look down the page and see in a heading or list the name of the topic that concerns you. I want you to be able to find instructions quickly. Compare the table of contents in this book to the book next to it on the bookstore shelf. The table of contents in this book is put together better and presents topics so that you can find them in a hurry.
Most computer books describe what the software is, but this book explains how to complete tasks with the software. I assume that you came to this book because you want to know how to do something — print form letters, create a worksheet, or query a database. You came to the right place. This book describes how to get tasks done.
The screen shots in this book show only the part of the screen that illustrates what is being explained in the text. When instructions refer to one part of the screen, only that part of the screen is shown. I took great care to make sure that the screen shots in this book serve to help you understand the Office programs and how they work. Compare this book to the next one on the bookstore shelf. Do you see how clean the screen shots in this book are?
Please forgive me, but I made one or two foolish assumptions about you, the reader of this book. I assumed that:
You own a copy of Office 2007, the latest edition of Office, and you have installed it on your computer.
You use a Windows operating system, preferably either Windows XP or Windows Vista. All people who have the Windows operating system installed on their computers are invited to read this book, though.
You are kind to foreign tourists and small animals.
I want you to understand all the instructions in this book, and in that spirit, I’ve adopted a few conventions.
Where you see boldface letters or numbers in this book, it means to type the letters or numbers. For example, “Enter 25 in the Percentage text box” means to do exactly that: Enter the number 25.
To show you how to step through command sequences, I use the ⇒ symbol. For example, you can click the Office button and choose Print⇒Print Preview to see what the file you’re working on will look like when you print it. The ⇒ symbol is just a shorthand method of saying “Choose Print and then choose Print Preview.”
To give most commands, you can press combinations of keys. For example, pressing Ctrl+S saves the file you’re working on. In other words, you can hold down the Ctrl key and press the S key to save a file. Where you see Ctrl+, Alt+, or Shift+ and a key name or key names, press the keys simultaneously.
To help you get the most out of this book, I’ve placed icons here and there. Here’s what the icons mean:
.jpg)
If you have a comment about this book, a question, or a shortcut you would like to share with me, address an e-mail message to me at this address: weverka@sbcglobal.net. Be advised that I usually can’t answer e-mail right away because I’m too darned busy. I do appreciate comments and questions, however, because they help me pass my dreary days in captivity.
