IN THIS CHAPTER
Changing your worksheet view
Adjusting your print settings for better results
Preventing some cells from being printed
Using Custom Views
Despite predictions of the "paperless office," reports printed on paper remain commonplace, and they will be around for a long time. Many worksheets that you develop with Excel can probably serve as printed 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 so that you can make your printed reports even better. 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.
Issuing that command with a mouse takes three clicks, though. A slightly more efficient method is to press Ctrl+P and then click the Print button (or press Enter).
But 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 ...