Preset Headers and Footers

Because a workbook can contain multiple worksheets, you might need to reference a cell in another worksheet, or even another workbook file. No problem! As long as you follow the proper syntax, you can type a formula that contains a reference to any file.
Click the Header down arrow, and a list of suggested header information appears. Scroll through the list to Detail, and then click it. The sample header appears centered at the top of the Header box.

By default, the footer (none) appears in the Footer text box. Click the Footer down arrow, and a list of suggested footer information appears. Scroll through and then click it. The sample footer appears centered at the bottom of the Footer box. Click OK.

To see the header and footer, click the Print Preview button on the Header/Footer tab of the Page Setup dialog box. It displays header and footer.
Printing