Header and Footer

The header and footer will appear at the top and bottom, respectively, of each sheet that you print.

By default, the header will display the name of the sheet. The footer will display the page number. Both the header and footer will be centered on the page.  

To customize the header and footer:

  1. Go to the File2 menu, and click Page Setup.

  2. A Page Setup window will appear.

  3. Click the Header/Footer tab.

  4. In the Header box, type the text that you want to have appear at the top of each printed page. In the Footer box, type the text that you want to have appear at the bottom of each printed page. More experienced users may wish to use codes to adjust the font attributes and the alignment, or to add information such as the page number and date. See "Header and Footer Codes", below.

  5. When you are done, click OK.

  6. The header and footer you created will appear on each page that you print.

Note: To access the header and footer, you may instead go to the View menu, and click Header and Footer.     

 

Header and Footer Codes

Before using codes, note that:

To view a list of the header and footer codes, go to the View menu, and click Header and Footer Codes. The codes include:

Code

Description

Alignment

&L

left-aligns the characters that follow

&C

centers the characters that follow

&R

right-aligns the characters that follow

Font

&12

uses font size 12 (you can enter whatever size you'd like)

&B

bolds the characters that follow

&I  

italicizes the characters that follow

&U

underlines the characters that follow

&S

strikes out the characters that follow

Information

&D      

prints the current system date

&T

prints the current system time

&F

prints the workbook name

&A   

prints the worksheet name

&P

prints the page number

&N

prints the total number of pages to be printed out

Examples (for a two-page workbook):

Code

Header/Footer Print Out

Page &P of &N

Page 1 of 2

&B &12 &F / &A

Book1 / Sheet1

&R &I Page &P of &N

Page 1 of 2

&L &B Page &P

Page 1