Excel Hacks - Tips & Tools for Streamlining Your Spreadsheets - O'Reilly 2007.pdf

EXCEL
HACKSTM
Other resources from O’Reilly
Related titles Excel 2007: The Missing Writing Excel Macros with
Manual VBA
Office 2007: The Missing Windows XP Hacks
Manual Access Hacks
Excel Scientific and Engi- Word Hacks

neering Cookbook SQL Hacks
Hacks Series Home is munity 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.
is more than plete catalog of O’Reilly
books. You’ll also find links to news, events, articles, we-
blogs, sample chapters, and code examples.
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. for
our ing events.
Safari Bookshelf (safari.) 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.
SECOND EDITION
EXCEL
HACKSTM
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 (safa