Chapter 9: Printing Your Work

In This Chapter

Changing your worksheet view

Adjusting your print settings for better results

Preventing some cells from being printed

Using the Custom Views feature

Creating PDF files

Despite predictions of the “paperless office,” reports printed on paper remain commonplace, and office printers will be around for a long time. Many worksheets that you develop with Excel will eventually end up as hard-copy reports. You'll find that printing from Excel is quite easy and that you can generate attractive, well-formatted reports with minimal effort. In addition, Excel has many options that provide you with a great deal of control over the printed page. These options are explained in this chapter.

Basic Printing

If you want to print a copy of a worksheet with no fuss and bother, use the Quick Print option. One way to access this command is to choose File ⇒ Print (which displays the Print pane of Backstage view), and then click the Print button.

If you like the idea of one-click printing, take a few seconds to add a new button to your Quick Access toolbar: Click the downward-pointing arrow on the right of the Quick Access toolbar and then choose Quick Print from the drop-down list. Excel adds the Quick Print icon to your Quick Access toolbar.

Clicking the Quick Print button prints the current worksheet on the currently selected printer, using the default print settings. If you've changed any of the default print settings (by using the Page Layout tab), ...

Get Excel 2013 Bible 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.