HOW TO: Add the Workbook Path to the Header and Footer in Excel (287482)

SUMMARY

This article describes how to add the path of the Microsoft Excel workbook to the header of footer of the workbook.

The feature described in this article is not available in versions of Excel earlier than Excel 2002. In earlier versions, the only way to duplicate this feature is with a Visual Basic for Applications macro.

back to the top

Add the Path

To add the path of the workbook to the header or footer of the workbook, follow these steps:

1. In Excel, click Header and Footer on the View menu.
2. In the Page Setup dialog box, click Custom Header or Custom Footer, depending on whether you are adding to the header or the footer.
3. Place the insertion point in the header or footer section that you want: left section, center section, or right section.
4. Do one of the following:
   • Type the following line:

     &[Path]

     -or-
     
     
   • Click the Path & File button (the fifth button from the right).
5. Click OK twice to close the dialog boxes and return to the worksheet.

back to the top

REFERENCES

For more information about how to insert file names into the header or footer, click Microsoft Excel Help on the Help menu, type insert a file name in a header or footer in the Office Assistant or the Answer Wizard, and then click Search to view the topic.


back to the top