Microsoft KB Archive/287482

= HOW TO: Add the Workbook Path to the Header and Footer in Excel =

Article ID: 287482

Article Last Modified on 10/23/2006

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q287482



For a Microsoft Excel 2000 version of this article, see 213615.

For a Microsoft Excel 98 version of this article, see 184507.

For a Microsoft Excel 97 version of this article, see 142140.

IN THIS TASK
SUMMARY
 * Add the Path

REFERENCES



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:  In Excel, click Header and Footer on the View menu. In the Page Setup dialog box, click Custom Header or Custom Footer, depending on whether you are adding to the header or the footer. Place the insertion point in the header or footer section that you want: left section, center section, or right section. Do one of the following:  Type the following line:

&[Path]

-or-

 Click the Path & File button (the fifth button from the right).</ul> </li> Click OK twice to close the dialog boxes and return to the worksheet.</li></ol>

back to the top