Microsoft Office Tutorials and References
In Depth Information
Chapter 5: Printing the Masterpiece
Printing the Masterpiece
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 2013.
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 2013, page the document only vertically; they won’t let you
create a document wider than the page size you’re using. Spreadsheet
programs like Excel 2013, however, often have to break up pages both vertically
and horizontally to print a worksheet document (a kind of tiling of the print
job, if you will).