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

Modifying Headers and Footers

Headers and footers can be extremely useful tools for organizing and identifying a document. After you have created a header or footer, Excel allows you to customize the header and footer information for a given worksheet. This document describes some options for modifying your headers and footers.

return to topAdjusting Margins

You may want to check your custom header or footer to ensure that it will print properly. If there are problems with the display of your header or footer, you may be able to fix them by adjusting the margins. You can adjust the margins in two ways: using the mouse option or the dialog box option.

Adjusting Margins: With the Mouse

  1. From the Office Button menuFile Menu button, select Print » Print Preview
    Your document is displayed in Print Preview mode.

  2. In the Preview group, select Show Margins
    The margin outlines appear.
    Margin outlines in Print Preview mode

  3. Using the mouse, click and drag the margin outlines to the desired position
    NOTE: The uppermost and bottommost margins are for the header and footer, respectively.

  4. Click CLOSE PRINT PREVIEWClose Print Preview button
    Excel returns to the work area.

Adjusting Margins: With the Page Setup Dialog Box

  1. From the Office Button menuFile Menu button, select Print » Print Preview
    Your document is displayed in Print Preview mode.

  2. In the Print group, click PAGE SETUPPage Setup button
    The Page Setup dialog box appears.

  3. Select the Margins tab
    The Page Setup dialog box refreshes to display the Margins options.
    Page Setup dialog box: Margins tab

  4. In the Top, Left, Right, Bottom, Header, and/or Footer text boxes, type the preferred margin size
    OR
    Use the nudge buttons to adjust the margins

  5. Click OK
    The Page Setup dialog box closes.

  6. Click CLOSE PRINT PREVIEWClose Print Preview button
    Excel returns to the work area.

return to topSetting a Custom Page Number

By default, page numbering starts with one. However, Excel allows you to begin numbering the first page with a number other than one.

  1. Add your header or footer

  2. From the Ribbon, select the Page Layout command tab

  3. In the Page Setup group, click PAGE SETUPPage Setup button
    The Page Setup dialog box appears.

  4. Select the Page tab
    The Page Setup dialog box refreshes to display the Page options.
    Page Setup dialog box: Page tab

  5. In the First page number text box, type the number that will begin the page numbering

  6. Click OK
    The Page Setup dialog box closes.

Excellence. Our Measure. Our Motto. Our Goal.