Excel® 2010 Workbook for Dummies®

Chapter 4. Printing Spreadsheet Reports

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.

Previewing Pages in the Worksheet and Backstage View

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 ...