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 2008

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. Using the mouse, click and drag the margin outlines located on the ruler to the desired position
    NOTE: The uppermost and bottommost margins are for the header and footer, respectively.
    Header margin with labels

Adjusting Margins: With the Page Setup Dialog Box

  1. From the File menu, select Page Setup...
    The Page Setup dialog box appears.
    Page Setup dialog box: Margin tab

  2. If the Margins tab is not selected, select it

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

  4. Click OK
    The Header/Footer margins adjust.

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. From the File menu, select Page Setup...
    The Page Setup dialog box appears. Page Setup dialog box

  2. If the Page tab is not selected, select it

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

  4. Click OK
    The first page number is changed.

Excellence. Our Measure. Our Motto. Our Goal.