Excel > Excel 2003 Foundation > Printing a Worksheet

Add a Header and Footer

Data can be added to the top (header) or bottom (footer) of a page in the margin area to appear when printed.

Any text or picture such as a logo can be added. Fields, information that updates automatically, such as the date or page number can also be added.

1. Click View > Header and Footer

The Header/Footer tab of the Page Setup dialogue box is displayed



2. Click the list arrow on the Header: or Footer: boxes to insert automatically generated text

Or

3. Click the Custom Header or Custom Footer buttons to create your own entry

The Header or Footer dialogue box is displayed



Three sections are shown for aligning the data to the left, centre or right of the header or footer

4. Click in the required section and either type in the text you want to use, or click one of the buttons to insert an automatic entry such as the date or page number

Button	Action
	Format the font of the header or footer text
	Insert a page number
	Insert the total number of pages
	Insert the current date
	Insert the current time
	Add the full filepath to the location of the spreadsheet including dive, folders and the filename
	Insert the name of the file
	Insert the name of the worksheet as shown on the sheet's tab
	Insert a picture such as the company logo
	Format the picture such as the brightness, contrast and size

5. Click Ok

The custom header or footer is displayed in the preview panel

6. Click Ok

Changing the page setup Setting the print area

Guides