6. Viewing and Printing Worksheets and Workbooks

What You'll Do

Set Up the Page

Adjust Page Margins

Add Headers and Footers

Insert Page Breaks

Customize Worksheet Printing

Set the Print Area

Preview a Worksheet

Print a Worksheet and Workbook

Create a PDF Document

Create an XPS Document

Introduction

When your Microsoft Office Excel worksheet is completed, you can preview and print its contents. While previewing the worksheet, you might find that rows of data might flow better on one page or the other. You can add page breaks to segment what you want to appear on a page. You can insert page breaks to control what you print on each page. You can change the orientation of the page from the default of portrait (vertical) to landscape (horizontal). ...

Get Microsoft Office Excel 2007 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.