Chapter 6. Viewing and Printing Worksheets

Last chapter gave you the tools to create multiple tables, worksheets, and workbooks. While this is all well and good, 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 those 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 large amounts of data are divided the way you want.