Microsoft Office Tutorials and References
In Depth Information
Chapter 5: Printing the Masterpiece
Chapter 5
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).
Search JabSto ::




Custom Search