This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?

Microsoft Excel 2007/2008

About the Page Setup Dialog Box

In addition to the Print dialog box, the Page Setup dialog box provides many options to help you print your Excel worksheets.

return to topAccessing the Page Setup Dialog Box

  1. Windows: From the Page Layout command tab, in the Page Setup group, click PAGE SETUP
    Macintosh: From the File menu, select the Page Setup
    The Page Setup dialog box appears.

return to topPage Setup Dialog Box Tabs

The Page Setup dialog box consists of four tabs: Page, Margins, Header/Footer, and Sheet. Each tab lets you customize elements of your Excel worksheet. For additional information, refer to Customizing Page Layout (Win | Mac).

NOTES:
The following buttons are found on all tabs: PRINT... (opens the Print dialog box), PRINT PREVIEW (opens Print Preview), OPTIONS... (opens the (printer name) on print Properties dialog box), OK, and CANCEL.

If you accessed the Page Setup dialog box differently than as described in Accessing the Page Setup Dialog Box, the PRINT... and PRINT PREVIEW buttons may not appear.

The options available in Page Setup dialog box will vary by operating system and printer model.

Page Setup Dialog Box Tabs: Page

The Page tab offers several options to help you specify how your worksheet(s) will print.

Page Setup dialog box, Page tab

Option Description
Orientation Determines if your document prints as a portrait (i.e., lengthwise) or as a landscape (i.e., widthwise)
Scaling Adjust to lets you to customize page scale by percentage. Fit to lets you specify how many pages it takes to print your worksheet
HINT: Print Preview lets you see the effects of scaling before you print.
Paper size Determines what size paper you will print on
Print quality Determines resolution
First page number Indicates what number appears on the first printed page. If you want the first page number to be 1, leave the selection as Auto


Page Setup Dialog Box Tabs: Margins

The Margins tab lets you set your margins and center your data vertically, horizontally, or both.

NOTE: All margin values are measured in inches.

Page Setup dialog box,  Margins tab


Page Setup Dialog Box Tabs: Header/Footer

Headers and footers are the text printed at the top and bottom of pages, such as the date, page number, the filename, or other text. The Header/Footer tab provides options to customize page headers or footers. For more information about headers and footers, refer to Modifying Headers and Footers (Win | Mac).

Page Setup dialog box, Header/Footer tab

Option Description
Header Provides several pre-written headers
Footer
Provides several pre-written footers
Custom Header... Lets you create your own header using the Header dialog box. For more information, refer to Adding Headers and Footers (Win | Mac)
Custom Footer... Lets you create your own footer using the Footer dialog box. For more information, refer to Adding Headers and Footers (Win | Mac)
Different odd and even pages Lets you create different headers or footers for odd and even pages
Different first page Lets you create a different header or footer for only the first page
Scale with document Adjusts the header and footer font and scaling to match the rest of the document
Align with page margins Sets headers and footers within the page margins
\


Page Setup Dialog Box Tabs: Sheet

The Sheet tab gives you several options for determining which elements of your workbook are printed. For more information, refer to Other Printing Options (Win | Mac).

Page Setup dialog box, Sheet tab

Option Description
Print area Specifies a range of cells to print
Print titles Specifies the rows or columns to print on each page. These rows or columns are likely to be the headings that define what the rest of the row or column's information is used for
Print Allows you to print only certain elements of your worksheet. For more information, refer to Using Printing Options: Applying Additional Printing Options (Win | Mac)
Page order Sets the order in which worksheet pages are numbered and printed
Excellence. Our Measure. Our Motto. Our Goal.