Excel's Page Setup Dialog Box

The settings in Microsoft® Excel's Page Setup Dialog Box are grouped by tabs:

Tab

 

Description of the Settings

Page

 

Orientation (portrait or landscape), scaling, paper size, print quality (dpi), starting page number.

Margins

 

Distances between the data and the top, bottom, left, and right edges of the page. Distances between the header and the top of the page, and between the footer and the bottom of the page.

Header/Footer

 

Define the header and footer that appear at the top and bottom of the page.

Sheet

 

Only applies to worksheets. Worksheet range to print, row and column titles, features to print (gridlines, row and column headings), draft quality, color or black & white, location of comments, cell errors, page order.

Chart

 

Only applies to charts. Chart size (scale), draft quality, color or black & white.

Options Button

Click on the Options button to set parameters that are specific to your printer.