Print file name on every excel spreadsheet I print.

R

ridergroov

Hello folks. I am trying to make a setting somewhere in excel that
will print the file name of the file I am working in on the page
somewhere every time I print from excel. Thanks.
 
A

ah

Do the following:
view: header and footer
custom header (or footer if you want it at the bottom of the page)
click on the open button, you'll see &[Path]&[File]
remove the &[Path], just leave the &[File]
click OK

Hope this helps.
 
O

Og

You can place the file name or/and file path in a Header or in a Footer.
By default, new workbooks do not have any headers or footers.
Unfortunately, you have to create the header/footer 'manually' for each and
every Sheet in a Workbook.
If you have a need to automate the process of inserting a header of footer,
try John Walkenbach's free 'J-Walk AddPath to Header or Footer" located
here:
http://www.j-walk.com/ss/excel/files/addpath.htm

Also ask in one of the many Excel-specific newsgroups for other automation
suggestions.
Steve
 
Top