IN THIS CHAPTER
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, ...