Creating headers and footers
Headers and footers are lines of text that print at the top and bottom of each page. Adding headers and footers provides a place to include such information as page numbers, title, date, time, and filename on each notebook page.
Using links, you can even enter the contents of a cell in a header or footer.
You can change the distance between a header or footer and the first or last row of data.
After creating a header or footer, you can edit it as required.
To add a header or footer |
1.
|
|
Click View Page.
|
2.
|
|
Right-click the top or bottom margin, and click one of the following:
|
•
|
Create header
|
•
|
Create footer
|
3.
|
|
Type the header or footer text.
|
4.
|
|
Click Format Selection properties.
|
5.
|
|
Choose a font face from the Face list.
|
6.
|
|
Choose a font size from the Size list box.
|
7.
|
|
Enable any of the following check boxes in the Appearance area:
|
•
|
Bold
|
•
|
Italics
|
•
|
Underline
|
•
|
Strikeout
|
To link the contents of a cell to a header or footer |
1.
|
|
Click File Page setup.
|
2.
|
|
Click the Header/footer tab.
|
3.
|
|
In the Header or Footer area, enable the Create check box.
|
4.
|
|
Type the cell address preceded by a back slash.
|
For example, \A:A1.
|
•
|
|
You cannot enter text or insert positioning characters on the same line as the cell content.
|
To adjust the space above or below a header or footer |
1.
|
|
Click File
ddle"> Page setup.
|
2.
|
|
Click the Header/footer tab.
|
3.
|
|
Type a height value in the Height box.
|
•
|
|
You can also adjust the space between the header or footer and the first or last row of data by dragging the dotted line that borders the top or bottom of the spreadsheet data.
|
To edit a header or footer |
1.
|
|
Click View Page.
|
2.
|
|
Double-click in the header or footer dotted area.
|
3.
|
|
Make any change.
|
4.
|
|
Click outside the header or footer.
|
To edit the font and font attributes in a header or footer |