R
ridergroov
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.
that I print from it. Is there a way to do that? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave O
If you mean "print the filename on all *print jobs*", you can set the
header or footer to include the filename, among other things.
header or footer to include the filename, among other things.
G
Gord Dibben
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.
File>Save 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 File>New or the Toolbar button File>New
Do not use File>New...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 Insert>Sheet.
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
Gord Dibben MS Excel MVP
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.
File>Save 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 File>New or the Toolbar button File>New
Do not use File>New...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 Insert>Sheet.
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
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
G
Gord Dibben
Thanks, Chuck
Gord
Gord Dibben MS Excel MVP
Gord
Very nice post Gord............
Vaya con Dios,
Chuck, CABGx3
Gord Dibben MS Excel MVP