Excel Hacks 2nd Edition.pdf

HACKS TM

EXCEL

Other resources from O’Reilly

Related titles Excel 2007: The Missing

Manual

Office 2007: The Missing

Manual

Excel Scientific and Engi-

neering Cookbook

WritingExcelMacroswith

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

HACKS TM

David and Raina Hawley

Beijing • Cambridge • Farnham • Köln • Paris • Sebastopol • Taipei • Tokyo

SECOND EDITION

Excel Hacks ™

by David and Raina Hawley

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, contact our

corporate/institutional sales department: (800) 998-9938 or corporate@oreilly.com .

Editors: Brian Sawyer and Brian Jepson

Technical Editor Tom Sgouros

Production Editor: Adam Witwer

Copyeditor: Derek Di Matteo

Proofreader: Tolman Creek Design

Indexer: Tolman Creek Design

Cover Designer: Hanna Dyer

Interior Designer: David Futato

Illustrators: Robert Romano

and Jessamyn Read

Printing History:

March 2004: First Edition.

June 2007:

NutshellHandbook,theNutshellHandbooklogo,andtheO’Reillylogoareregisteredtrademarks

of O’Reilly Media, Inc. The Hacks series designations, Excel Hacks , the image of a trowel, and

related trade dress are trademarks of O’Reilly Media, Inc.

Many of the designations used by manufacturers and sellers to distinguish their products are

claimedastrademarks.Wherethosedesignationsappearinthisbook,andO’ReillyMedia,Inc.was

aware of a trademark claim, the designations have been printed in caps or initial caps.

While every precaution has been taken in the preparation of this book, the publisher and authors

assume no responsibility for errors or omissions, or for damages resulting from the use of the

information contained herein.

Small print: The technologies discussed in this publication, the limitations on these technologies

thattechnologyandcontentownersseektoimpose,andthelawsactuallylimitingtheuseofthese

technologies are constantly changing. Thus, some of the hacks described in this publication may

notwork,maycauseunintendedharmtosystemsonwhichtheyareused,ormaynotbeconsistent

withapplicableuseragreements.Youruseofthesehacksisatyourownrisk,andO’ReillyMedia,

Inc.disclaimsresponsibilityforanydamageorexpenseresultingfromtheiruse.Inanyevent,you

should take care that your use of these hacks does not violate any applicable laws, including

This book uses RepKover ™ , a durable and flexible lay-flat binding.

ISBN-10: 0-596-52834-5

ISBN-13: 978-0-596-52834-8

[M]

Second Edition.

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: