Putting Spreadsheet Names in Headers or Footers

When you print your spreadsheet, it is often a good idea to include the spreadsheet name in the header or footer. This allows you, at a later date, to recall the name of the file in which the spreadsheet is stored. In fact, some of the headers and footers predefined in Excel include the spreadsheet file name. To include spreadsheet file names in your custom header or footer, follow these steps:

1. Choose Page Setup from the File menu. This displays the Page Setup dialog box.
2. Make sure the Header/Footer tab is selected. (Click here to see a related figure.)
3. Click on either Custom Header or Custom Footer, depending on where you want the spreadsheet file name to appear. This displays either the Header or Footer dialog box. (Click here to see a related figure.)
4. Position the insertion point in the Left, Center, or Right box, depending on where in the header or footer you want the spreadsheet file name placed.
5. Click on the file name tool (it looks like a piece of paper with the Excel logo on it). This places the characters &[File] at the insertion point. This is where the spreadsheet file name will be located.
6. Click on OK to close the Header or Footer dialog box.
7. Click on OK to close the Page Setup dialog box.