Excel visual basic

Microsoft®

Excel® 2010 Plain & Simple

Curtis D. Frye

Published with the authorization of Microsoft corPoration by: o’reilly Media, inc. 1005 Gravenstein highway north sebastopol, california 95472 copyright © 2010 curtis d. frye. complying with all applicable copyright laws is the responsibility of the user. all rights reserved. without limiting the rights under copyright, no part ofthis document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without express written permission of o’reilly Media, inc. Printed and bound in the united states of america. 1 2 3 4 5 6 7 8 9 wct 5 4 3 2 1 0 Microsoft Press books are available throughbooksellers and distributors worldwide. for further information about international editions, contact your local Microsoft corporation office or contact Microsoft Press international directly at fax (425) 936-7329. Visit our web site at www. microsoft.com/mspress. send comments to mspinput@microsoft.com. Microsoft, Microsoft Press, activeX, excel, frontPage, internet explorer, PowerPoint, sharePoint,webdings, windows, and windows 7 are either registered trademarks or trademarks of the Microsoft group of companies. 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 causedor alleged to be caused either directly or indirectly by this book. Acquisitions and Developmental Editor: Kenyon brown Production Editor: Kristen borg Editorial Production: online training solutions, inc. Proofreader: nancy sixsmith Technical Reviewer: Mark reddin Compositor: nellie McKesson Illustrator: robert romano Indexer: Ginny Munroe isbn: 978-0-7356-2727-7

To Virginia

ContentsAcknowledgments. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii

1 2 3

Introduction: About This Book

1

No Computerese! . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Useful Tasks…  . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 …And the Easiest Way to Do Them . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 A Quick Overview  . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 A Few Assumptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 A Final Word (or Two) . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

What’s New and Improved in Excel 2010

5

Managing Excel Files and Settings in Backstage View . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 Previewing Data Using Paste Preview . . . . . . . . . . . . . . . . . . . . . . . . . . ....