File path in a header/footer

[Nia]

Does anyone know how to include the file path in a custom
header/footer without manually typing it in? Is there a
button like there is for 'file name' or 'worksheet tab'?
Our office uses Excel 2000.

Thank you,
Nia

 

[one_answer]

Nia;

Select File -> Page Setup (or View -> Header and Footer).

Click the Header/Footer tab.

Use the drop-down list in either the Header or Footer
area and you'll see several listings for diplaying the
file name.

***
If all else fails, click 'Custom Header' and type &[File]
in the desired area.