How To Do Everything With Microsoft Office

Microsoft Office
®

Excel 2003
Guy Hart-Davis

McGraw-Hill/Osborne
New York Chicago San Francisco Lisbon London Madrid Mexico City Milan New Delhi San Juan Seoul Singapore Sydney Toronto

McGraw-Hill/Osborne 2100 Powell Street, 10th Floor Emeryville, California 94608 U.S.A.
To arrange bulk purchase discounts for sales promotions, premiums, or fund-raisers, please contact McGraw-Hill/Osborne at the above address. For information on translations or book distributors outside the U.S.A., please see the International Contact Information page immediately following the index of this book.

How to Do Everything with Microsoft Office Excel 2003
Copyright © 2003 by The McGraw-Hill Companies. All rights reserved. Printed in the United …show more content…

. . . . . . . . . . . . . . . .
Improve Your View with Splits, Extra Windows, Hiding, Zooming, and Freezing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Split the Excel Window to Show Separate Parts at Once . . . . . . . . Open Extra Windows to Work in Different Areas of a Worksheet . . Arrange Open Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Hide a Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Zoom In and Out . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

25
26 26 27 28 30 30

iii

iv

How to Do Everything with Microsoft Office Excel 2003
Use Freezing to Keep Key Rows and Columns Visible . . . . . . . . . Set Options to Make Excel Easier to Use . . . . . . . . . . . . . . . . . . . . . . . . . Choose View Options to Customize Excel’s Visual Appearance . . Understand (and Maybe Choose) Calculation Options . . . . . . . . . Set Edit Options to Fine-Tune Editing Maneuvers . . . . . . . . . . . . . Choose General Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Choose Suitable Save Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . Choose Transition Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Set Spelling Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .