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.
Adjusting 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
-
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.
Adjusting Margins: With the Page Setup Dialog Box
-
From the File menu, select Page Setup...
The Page Setup dialog box appears.
-
If the Margins tab is not selected, select it
-
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 -
Click OK
The Header/Footer margins adjust.
Setting 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.
-
From the File menu, select Page Setup...
The Page Setup dialog box appears.
-
If the Page tab is not selected, select it
-
In the First page number text box, type the number that will begin the page numbering
-
Click OK
The first page number is changed.
