Page 54 - Excel Workbook for Dummies

07_798452 ch03.qxp 3/13/06 7:38 PM Page 37

Chapter 3

Printing Spreadsheet

Reports

In This Chapter
Previewing the printed report
Using Page Break Preview to adjust the paging
Adding ready-made and custom headers and footers to a report
Adjusting various Page and Print Settings
Printing all or portions of a workbook

rinting easy-to-read and well-organized reports from your spreadsheets is one of the
Pmost 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 Print Preview, Page
Break Preview, headers and footers, and print title features. Don’t worry if you don’t have
access to a printer while completing these exercises: In almost all cases, you can use the
Print Preview feature to get an idea of how the report would appear on the printed page.

Previewing the Printed Report

Print Preview is your first line of defense against wasting paper on useless reports that contain
bad page breaks, which separate columns and rows of the spreadsheet with data that need
to appear together on a page. In Print Preview, all the information, both text and graphics,
within the current Print Area (that is, the section of the worksheet included in the printout) is
displayed as it appears on the printed page. Along with this spreadsheet data, any headings
that you’ve assigned to the pages of the report also appear.

Always use Print Preview to check your report before sending it to the printer, unless it’s one
that you’ve already successfully printed from the spreadsheet.

Try It

Exercise 3-1: Previewing a Printed Report
Open the Spring Furniture Sale.xls workbook in your My Spreadsheets (or My Practice
Spreadsheets) folder inside the My Documents folder and use it to practice using Print
Preview:

1. Click the Print Preview button on the Standard toolbar to open it in the Print Preview
window.