Microsoft Office Excel 2007 Inside Out

Mark Dodge

Craig Stinson

PUBLISHED BY Microsoft Press A Division of Microsoft Corporation

One Microsoft Way Redmond, Washington 98052-6399

Copyright © 2007 by Craig Stinson and Mark Dodge

ISBN:9780735623217

All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher.

Library of Congress Control Number: 2006937709

Printed and bound in the United States of America.

1 2 3 4 5 6 7 8 9 QWT 2 1 0 9 8 7

Distributed in Canada by
H.B. Fenn and Company Ltd.

A CIP catalogue record for this book is available from the British Library.

Microsoft Press books are available through booksellers and distributors worldwide. For further information about international editions, contact your local Microsoft Corporation office or contact Microsoft Press International directly at fax [phone]. Visit our Web site at www.microsoft.com/mspress. Send comments to [e-mail].

Microsoft, Microsoft Press, Access, Active Accessibility, ActiveX, AutoSum, Calibri, Cambria, Excel, IntelliMouse, Internet Explorer, MSDN, MS-DOS, MSN, Outlook, PivotChart, PivotTable, PowerPoint, SharePoint, SQL Server, Visual Basic, Windows, Windows Live, Windows Server, and Windows Vista are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Other product and company names mentioned herein may be the trademarks of their respective owners.

The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred.

This book expresses the author's views and opinions. The information contained in this book is provided without any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.

Acquisitions Editor: Juliana Aldous Atkinson

Developmental Editor: Sandra Haynes

Project Editor: Melissa von Tschudi-Sutton

Project Management: Publishing.com

Compositor: Curtis Philips

Technical Reviewer: Rozanne Whalen

Copy Editor: Kim Wimpsett

Proofreader: Andrea Fox

Indexer: Wright Information Indexing Services

Body Part No. X12-65192

In memory of

Regina Dodge & Leroy W. Southers, Jr.

Acknowledgments

There is an old joke where a guy is beating himself on the head with a hammer. When asked why, he says "because it feels so good when I stop." We all can relate to this at times on book projects like this one, but when we get around to writing these acknowledgments, the beatings have subsided and the good feelings are already flowing. However, the hammer was soft and merciful during this particular project, due in large part to the efforts of a great team. Without them, we'd be lucky to publish a blog.

Thanks to Lucinda Rowley for presiding over the smoothly operating machine that is Microsoft Press, and thanks once again to Sandra Haynes for her masterful steerage of the good ship Inside Out. This book could never have existed without the patient and steady guidance of Curtis Philips of Publishing.com, as well as the unflinching eyes of Melissa von Tschudi-Sutton, Rozanne Murphy Whalen, Kim Wimpsett, and Andrea Fox. Sincere thanks to all those who had a hand in this (and related) endeavors, including but not limited to Juliana Aldous Atkinson, Linda Engelman, Bill Teel, Asa Noriega, Claudette Moore, Jensen Harris, John Pierce, and Sondra Scott. And a special serving of applause to Reed Jacobson and Gini Courter.

Musical props go to that woman who forced Mark to endure piano lessons at age 8, serving to "tune the instrument" for the next 46 years of a very musical life. Thanks, Mom.

About the Authors

Mark Dodge started using spreadsheet programs in a corporate accounting office in 1985, began working in computer publishing in 1988, and has since written or edited more than two dozen books for Microsoft Press. Mark, an accomplished musician and award-winning photographer, lives with his wife on a beautiful island in Puget Sound, Washington.

Craig Stinson, an industry journalist since 1981, was editor of Softalk for the IBM Personal Computer, one of the earliest machine-specific computer magazines. He is the author of more than 20 Microsoft Press books about Microsoft Windows and Excel. Craig lives with his wife and two children in Bloomington, Indiana.