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.
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), ...