Insert file name in footer

[Dottie]

How do I change Excel so every document has this inserted
by default.

Thanks in advance.

 

[Dave Peterson]

How about a utility so you can add it whenever you want?

John Walkenbach has one at:
http://j-walk.com/ss/excel/files/addpath.htm

 

[Guest]

Hi Dottie,

How about creating a template, or if the sheets have
already been established, using the "Footer" option?
Click on View/Header and Footer, click on "Custom
Footer", click in the window where it would be placed
(Right Section, Center Section, Left Section), then click
on the Icon second from the right....a little page with a
curled top right corner with an "X" on it...that'll
insert the file name for you, even if you change the file
name. Haven't tried to make this into a template yet,
but that should work too.

HTH,

Don