Chapter 5

Printing the Masterpiece


Previewing pages in Page Layout view and printouts in Backstage view

Quick printing from the Quick Access toolbar

Printing all the worksheets in a workbook

Printing just some of the cells in a worksheet

Changing page orientation

Printing the whole worksheet on a single page

Changing margins for a report

Adding a header and footer to a report

Printing column and row headings as print titles on every page of a report

Inserting page breaks in a report

Printing the formulas in your worksheet

For most people, getting data down on paper is what spreadsheets are all about (all the talk about a so-called paperless office to the contrary). Everything — all the data entry, all the formatting, all the formula checking, all the things you do to get a spreadsheet ready — is really just preparation for printing its information.

In this chapter, you find out just how easy it is to print reports with Excel 2016. Thanks to the program’s Print screen in Backstage view (Alt+FP), its Page Layout worksheet view, and its handy Page Layout tab on the Ribbon, you discover how to produce top-notch reports the first time you send the document to the printer (instead of the second or even the third time around).

The only trick to printing a worksheet is getting used to the paging scheme and learning how to control it. Many of the worksheets you create with Excel are not only longer than one printed page, but also wider. Word processors, such as Word 2016, ...

Get Excel 2016 For Dummies now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.