EXCEL
HACKSTM
Other resources from O’Reilly
Related titles Excel 2007: The Missing
Manual
Office 2007: The Missing
Manual
Excel Scientific and Engi-
neering Cookbook
Writing Excel Macros with
VBA
Windows XP Hacks
Access Hacks
Word Hacks
SQL Hacks
Hacks Series Home
hackszine.com is a community site for developers and
power users of all stripes. Readers learn from each other
as they share their favorite tips and tools for Mac OS X,
Linux, Google, Windows XP, and more.
oreilly.com
oreilly.com is more than a complete catalog of O’Reilly
books. You’ll also find links to news, events, articles, we-
blogs, sample chapters, and code examples.
oreillynet.com is the essential portal for developers inter-
ested in open and emerging technologies, including new
platforms, programming
languages,
and operating
systems.
Conferences O’Reilly brings diverse innovators together to nurture
the ideas that spark revolutionary industries. We special-
ize
in documenting the latest
tools and systems,
translating the innovator’s knowledge into useful skills
for those in the trenches. Visit conferences.oreilly.com for
our upcoming events.
Safari Bookshelf (safari.oreilly.com) is the premier online
reference library for programmers and IT professionals.
Conduct searches across more than 1,000 books. Sub-
scribers can zero in on answers to time-critical questions
in a matter of seconds. Read the books on your Book-
shelf from cover to cover or simply flip to the page you
need. Try it today with a free trial.
EXCEL
HACKSTM
SECOND EDITION
David and Raina Hawley
Beijing • Cambridge • Farnham • Köln • Paris • Sebastopol • Taipei • Tokyo
Excel Hacks™
by David and Raina Hawley
Copyright © 2007 O’Reilly Media, Inc. All rights reserved.
Printed in the United States of America.
Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North,
Sebastopol, CA 95472.
O’Reilly books may be purchased for educational, business, or sales promotional use. Online
editions are also available for most titles (safari.oreilly.com). For more information, con