Defining Page Setup Options
Headers and footers can be added to any worksheet, although they are not required. A header is any information that appears at the top of each page, while a footer prints at the bottom of the page. If you want a header or footer inserted onto a page, you'll have to define them. Excel XP defaults to no header and no footer.
You can insert placeholder buttons into both the header and footer to format text and insert page numbers, dates, times, file names, and tab names. Excel replaces these placeholders with the information each represents when the worksheet is printed. Follow the instructions in the header and footer dialog boxes.