CHAPTER 7Printing Your Work

Despite predictions of the “paperless office,” paper remains an excellent way to carry information around and share it with others, particularly if there's no electricity or Wi-Fi where you're going. Some of the worksheets that you develop with Excel will end up as hard-copy reports, and you'll want them to look as good as possible. 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.

Doing 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. The keyboard shortcut Ctrl+P has the same effect as File ⇨ Print. When you use Ctrl+P to show the Backstage view, the Print button has the focus, so you can simply press Enter to print.

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

Get Excel 2019 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.