(Legacy) Microsoft Excel 2007: About the Page Setup Dialog Box

Last Updated

Note: This article is based on legacy software.

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

Accessing 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.

Page 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 (WinMac).

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 above, 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

OptionDescriptionOrientationDetermines if your document prints as a portrait (i.e., lengthwise) or as a landscape (i.e., widthwise).ScalingAdjust 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 sizeDetermines what size paper you will print on.Print qualityDetermines resolution.First page numberIndicates 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

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 (WinMac).

page setup

OptionDescriptionHeaderProvides several pre-written headers.FooterProvides 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 (WinMac).Custom Footer...Lets you create your own footer using the Footer dialog box. For more information, refer to Adding Headers and Footers (WinMac).Different odd and even pagesLets you create different headers or footers for odd and even pages.Different first pageLets you create a different header or footer for only the first page.Scale with documentAdjusts the header and footer font and scaling to match the rest of the document.Align with page marginsSets 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 (WinMac).

page setup

OptionDescriptionPrint areaSpecifies a range of cells to print.Print titlesSpecifies 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.PrintAllows you to print only certain elements of your worksheet. For more information, refer to Using Printing Options: Applying Additional Printing Options (WinMac).Page orderSets the order in which worksheet pages are numbered and printed.