Excel 2016 Bible

Chapter 9Printing Your Work

IN THIS CHAPTER

1. Changing your worksheet view
2. Adjusting your print settings for better results
3. Preventing some cells from being printed
4. Using the Custom Views feature
5. 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 give you 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. ...