Print file name to all files from excel?
 

Hi folks. I want to setup excel to print the file name on all the files
that I print from it. Is there a way to do that? Thanks.

Print file name to all files from excel?
 

If you mean "print the filename on all *print jobs*", you can set the
header or footer to include the filename, among other things.

Print file name to all files from excel?
 

Open a new workbook. Customize as you wish.
Note: you can set all sheet footers at the same time by "grouping" the sheets.
Right-click on a sheet tab and "select all sheets". Set up a footer on the
active sheet and will be done to all. Ungroup when setup is complete.

FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name your
workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for FileNew or the Toolbar button FileNew

Do not use FileNew...Blank Workbook or you will get the Excel default workbook.

Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default InsertSheet.

More can be found on this in Help under "templates"(no quotes).

Or you could use a macro which you could store in Personal.xls file so it is
available for all open workbooks.

Sub PathInFooter()
ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.Name
End Sub


Gord Dibben Excel MVP

On 20 Dec 2006 07:03:48 -0800, "ridergroov" wrote:

Hi folks. I want to setup excel to print the file name on all the files
that I print from it. Is there a way to do that? Thanks.

Gord Dibben MS Excel MVP

Print file name to all files from excel?
 

Very nice post Gord............

Vaya con Dios,
Chuck, CABGx3



"Gord Dibben" wrote:

Open a new workbook. Customize as you wish.
Note: you can set all sheet footers at the same time by "grouping" the sheets.
Right-click on a sheet tab and "select all sheets". Set up a footer on the
active sheet and will be done to all. Ungroup when setup is complete.

FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name your
workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for FileNew or the Toolbar button FileNew

Do not use FileNew...Blank Workbook or you will get the Excel default workbook.

Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default InsertSheet.

More can be found on this in Help under "templates"(no quotes).

Or you could use a macro which you could store in Personal.xls file so it is
available for all open workbooks.

Sub PathInFooter()
ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.Name
End Sub


Gord Dibben Excel MVP

On 20 Dec 2006 07:03:48 -0800, "ridergroov" wrote:

Hi folks. I want to setup excel to print the file name on all the files
that I print from it. Is there a way to do that? Thanks.

Gord Dibben MS Excel MVP

Print file name to all files from excel?
 

Thanks, Chuck

Gord

On Wed, 20 Dec 2006 10:03:01 -0800, CLR wrote:

Very nice post Gord............

Vaya con Dios,
Chuck, CABGx3



"Gord Dibben" wrote:

Open a new workbook. Customize as you wish.
Note: you can set all sheet footers at the same time by "grouping" the sheets.
Right-click on a sheet tab and "select all sheets". Set up a footer on the
active sheet and will be done to all. Ungroup when setup is complete.

FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name your
workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for FileNew or the Toolbar button FileNew

Do not use FileNew...Blank Workbook or you will get the Excel default workbook.

Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default InsertSheet.

More can be found on this in Help under "templates"(no quotes).

Or you could use a macro which you could store in Personal.xls file so it is
available for all open workbooks.

Sub PathInFooter()
ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.Name
End Sub


Gord Dibben Excel MVP

On 20 Dec 2006 07:03:48 -0800, "ridergroov" wrote:

Hi folks. I want to setup excel to print the file name on all the files
that I print from it. Is there a way to do that? Thanks.

Gord Dibben MS Excel MVP


Gord Dibben MS Excel MVP