Chapter 7. Viewing and Printing Worksheets

The previous chapters have given you all the tools you need to create nicely formatted worksheets. That’s all well and good, but as you use those features to build intricate worksheets, you may quickly find yourself buried in an avalanche of data. If you want to see more than one part of your workbook at once, or if you want an overview of the entire worksheet, you must seize control of Excel’s viewing features.

These features include zooming, which lets you 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 (like column titles). This chapter teaches you how to use these tools, 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 get divided the way you want.

Controlling Your View

So far, most of the worksheets in this book have included only a small amount of data. But as you cram your worksheets with dozens of columns, and hundreds or even thousands of rows, editing becomes much trickier. The most challenging problems are keeping track of where ...

Get Excel 2013: The Missing Manual now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.