Microsoft Excel 2008: Modifying Headers and Footers (Mac)

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
• Setting a Custom Page Number

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

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.
   

Adjusting Margins: With the Page Setup Dialog Box

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

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.

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

Make sure to let me know in the comments below or on our Facebook page how you've got with it or Do you have any questions