Manual

Using Headers and Footers
Enter header and
footertext in cells
thatare not part of
the main information
inyour spreadsheet.
Then, when you
print, select a print
range that excludes
the cells containing
the header and
footertext. Ifyou
includethe cell
containingrthe
header or footerin
the printrange of
cells, then the
header or footerwill
print twice. See page
120 forprintingyour
spreadsheeL
Headers and footers are the text that pdnts at the top or bottom of each
page. They can be as simple as the page number, or they can include more
descriptive information, such as the following:
To create pa£1e
numbers that
automatically number
themselves, type the
page number function
formula. See page
223. Be sure to type =
to start your page
formula.
• Date the document Was created or printed
• Page number
• Name of the document
• Your name or the name of your department, business, or school
• Graphics such as a logo or drawing
Header text size cannot exceed 24 points.
,To create a header or footer:
1. Enter the header or footer text in a cell or range of cells that is not part of
the main information. (See the sidenote on the left.)
2. Select the cell or range.
3. Select Header/Footer from the Cell menu. A submenu appears.
4. Select-either Set Header or Set Footer from the submenu. The selected
information will print at the top or bottom of the page, as you have
indicated.
-,To -_- -"_ _ " _"
number _ges consecutively:
1. Select the footer cell that you created above.
2. Select Insert Function from the Formula menu.
3. Select Print from the box on the left, and Page from the box on the right.
4. Select Paste. The formula is pasted in the text entry box.
5. Press ENTER. Yourpages will be automatically numbered.
6. Click on Close. Th£_ exits you from tbe footer Edit ba_.
Spreadsheet 79