Chapter 10. Printing and Protecting Your Workbook, Worksheets, and Charts

In this chapter

Previewing your worksheets to see how Excel plans to print them.
Formatting your worksheet to make it fit on one page.
Repeating column headings on every page.
Hiding inessential or confidential columns and rows.
Printing only the most essential blocks of data with print areas.
Preventing unauthorized changes to your worksheets and charts.

To distribute a workbook or worksheet or to keep a paper copy for your records, you can print your entire workbook or print only selected worksheets and charts. Because worksheets are often wider and longer than a single sheet of paper, printing worksheets in a way that makes them easy to follow can be quite a challenge. This chapter explains the manner in which Excel typically prints worksheets and shows you how to take control of the layout and printing of your worksheets. This chapter also shows you how to modify the properties of your workbook file to prevent unauthorized changes.