I
ianatmerri
Can anyone help me with this?
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.
Can I set up a default footer that will appear in every spreadshee
M
Max
Try clicking File > Page Setup > "Header/Footer" tab > Custom Footer
(Options are there)
(Options are there)
Re: Can I set up a default footer that will appear in every spreadsheetianatmerri said:Can anyone help me with this?
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).
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).
Gord Dibben Excel MVP
Can anyone help me with this?
Gord Dibben MS Excel MVP
M
Max
Sorry, think I misread earlier. Pl dismiss my response.
See Gord's response ..
See Gord's response ..
J
jibwench
That addresses part of my issue, but I want the footer to appear on sheets as
a user adds them. I did as you suggested, and opened a new workbook, using
the template, and there were 3 tabs, as I expected. But when I use "insert
new sheet" the footer is not there. Is the only way (to bring the footer
along to each new sheet) to copy one of the sheets? We are trying to push a
standard footer out to all users, and it would be great if the footer
appeared on inserted sheets as well as copied ones! Thanks,
a user adds them. I did as you suggested, and opened a new workbook, using
the template, and there were 3 tabs, as I expected. But when I use "insert
new sheet" the footer is not there. Is the only way (to bring the footer
along to each new sheet) to copy one of the sheets? We are trying to push a
standard footer out to all users, and it would be great if the footer
appeared on inserted sheets as well as copied ones! Thanks,
G
Gord Dibben
Did you also create a SHEET.XLT as instructed?
That will be the default Insert>Worksheet.
Re-read my post. Specifically.....
That will be the default Insert>Worksheet.
Re-read my post. Specifically.....