Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you set up Excel to automatically add a standard footer?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you set up Excel to automatically add a standard footer?
James
Open a new workbook. Customize as you wish, including your footer. 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 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). Gord Dibben Excel MVP On Tue, 4 Apr 2006 14:04:05 -0700, James wrote: Gord Dibben MS Excel MVP |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you set up Excel to automatically add a standard footer?
What causes some of the original messages to be blank, such as in this case?
I can see the reply fine. I've noticed the same thing in several places. Obviously, the people who reply can read the original msg "Gord Dibben" wrote: James Open a new workbook. Customize as you wish, including your footer. 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 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). Gord Dibben Excel MVP On Tue, 4 Apr 2006 14:04:05 -0700, James wrote: Gord Dibben MS Excel MVP |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you set up Excel to automatically add a standard footer?
"Patricia Shannon" wrote in
message ... What causes some of the original messages to be blank, such as in this case? I can see the reply fine. I've noticed the same thing in several places. Obviously, the people who reply can read the original msg The original message was blank because the OP didn't put anything in the message body. The people who reply presumably read the question in the subject line, though many participants in newsgroups will ignore questions posed that way. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel file automatically opens - More Info | Excel Discussion (Misc queries) | |||
How do I automatically open linked documents in Excel? | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
PivotTables in Excel 2004 calculate incorrect standard deviations | Excel Worksheet Functions | |||
How do I automatically send daily email of updated Excel workbook. | Excel Discussion (Misc queries) |