In This Chapter
Previewing pages in the Worksheet and Backstage View
Using Page Break Preview to adjust the paging
Adding readymade and custom headers and footers to a report
Adjusting various Page and Print Settings
Printing all or portions of a workbook
Printing easy-to-read and well organized reports from your spreadsheets is one of the most important tasks you do in Excel. The exercises in this chapter give you a chance to practice printing many types of spreadsheet reports using Excel's Page Layout view, Page Break Preview, headers and footers, and print titles features. Don't worry if you don't have access to a printer while completing these exercises: In almost all cases, you can use Excel's Print Preview feature in the Print panel of the Backstage View to get an idea of how the report would appear on the printed page.
In the regular Worksheet View, Page Layout view is your first line of defense against wasting paper on useless reports that contain bad page breaks, one which separates columns and rows of the spreadsheet from data that needs to appear together on a page. When actually printing the document from the Excel Backstage View, the Print panel also shows you the pages of the report as well as enables you to change simple print settings before sending the report to your printer.
In Page Layout view in the regular worksheet, Excel turns on the display of the horizontal and vertical rulers ...