Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 1 Getting Started with Excel 19

Table 1-4 describes the variety of options available to you from the Print

Preview tab in the Print Preview window.

Table 1-4 Print Preview Options

Button Description

Print Send the document to the printer

Page Setup Set up the properties of the printed page

Zoom Zoom in and out of the Preview window

Next Page View the next page in the print job

Previous Page View the previous page in the print job

Show Margins Display margins in the Preview window

Close Print Preview Close the Print Preview window

Setting Up the Page

The Preview window opens with the default print settings for the work-

book. You can change these settings for each print job. You may add a

header or footer to each page, change the orientation from portrait to land-

scape, and modify many other features. To see how this works, adjust the

settings for the current print job by adding a header and changing the page

layout.

To add a header to a print job:

1 Click the Page Setup button from the Print Preview tab.

2 Click the Header/Footer dialog sheet tab.

3 Excel provides a list of built-in headers that you can select from

the Header drop-down list. You can also write your own; you’ll do

this now.

4 Click the Custom Header button.

5 Type Yearly Usage Report in the Center section of the Header dialog

box as shown in Figure 1-14.