Skip to Main Content
Excel 2003 for Starters: The Missing Manual
book

Excel 2003 for Starters: The Missing Manual

by Matthew MacDonald
October 2005
Beginner content levelBeginner
400 pages
8h 53m
English
O'Reilly Media, Inc.
Content preview from Excel 2003 for Starters: The Missing Manual

Chapter 6. Viewing and Printing Worksheets

Last chapter gave you the tools you need to create multiple tables, worksheets, and workbooks. While this is all well and good—and absolutely essential, depending on what you plan to use Excel for—these features can quickly bury you in an avalanche of data. If you want to see more than one part of the workbook at once, or if you want an overview of the entire worksheet, you have to seize control of Excel's viewing features.

These features include zooming (which lets you magnify cells or just fit more information into your Excel window), panes (which let you see more than one part of a worksheet at once), and freezing (which lets you keep certain cells visible at all times). This chapter teaches you how to use these features, store a custom view, and even save a workspace (a configuration that lets you edit multiple files in one window).

No matter what your worksheets look like on a screen, sometimes the best way to review them is in print. The second half of this chapter tackles printing your worksheets. You'll learn Excel's basic printing options and a few tricks that can help you preview page breaks and make sure Excel divides large amounts of data the way you want.

Controlling Your View

So far, most of the sample worksheets in this book have included only a small amount of data. But as you expand your real-life data with dozens of columns, and hundreds or even thousands of rows, editing becomes much trickier. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Show Me Microsoft® Office Excel 2003

Show Me Microsoft® Office Excel 2003

Steve Johnson - Perspection, Inc.

Publisher Resources

ISBN: 0596101546Supplemental ContentErrata Page