Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically insert footer
Hey I know you can insert the dir and name of the file as a footer in a sheet, but can this be set as standard? so when i make a new excel file it automatically adds the footer? thanks jimmyp -- jimmyp ------------------------------------------------------------------------ jimmyp's Profile: http://www.excelforum.com/member.php...o&userid=32217 View this thread: http://www.excelforum.com/showthread...hreadid=542056 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically insert footer
There is likely a Folder created in your Excel (Program) installation
called "XLStart". Find it (with your Explorer program) and see if you have a file Called Book.xlt. If you do: Open it with Excel - make any and all modifications you wish to it (meaning Doctor-it-up so that it appears exactly the way you want a new workbook to Look (including such as in the Page Setup, the Dir Name and the File name, etc). Now Do a File-SaveAs and make sure you save it to the same folder (XLStart) and the file extention is .xlt -- so "Book.xlt" Close Excel, and reopen -- your new "and improved" new wb should have the Characteristics you want. If you do not have: Create a new wb (from scratch) doing the doctor-up part and just save it The the existing XLStart folder as Book.xlt That should do it. HTH Jim May "jimmyp" wrote in message : Hey I know you can insert the dir and name of the file as a footer in a sheet, but can this be set as standard? so when i make a new excel file it automatically adds the footer? thanks jimmyp -- jimmyp ------------------------------------------------------------------------ jimmyp's Profile: http://www.excelforum.com/member.php...o&userid=32217 View this thread: http://www.excelforum.com/showthread...hreadid=542056 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically insert footer
cheers JimMay that did the trick jimmyp -- jimmyp ------------------------------------------------------------------------ jimmyp's Profile: http://www.excelforum.com/member.php...o&userid=32217 View this thread: http://www.excelforum.com/showthread...hreadid=542056 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically insert footer
The only downside is that it does this for ALL new workbooks, so
If you don't want it you'll have to remove it from your Page setup. Thanks for the feedback, Jim May "jimmyp" wrote in message : cheers JimMay that did the trick jimmyp -- jimmyp ------------------------------------------------------------------------ jimmyp's Profile: http://www.excelforum.com/member.php...o&userid=32217 View this thread: http://www.excelforum.com/showthread...hreadid=542056 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert picture and automatically size to cell? | Excel Worksheet Functions | |||
Automatically insert row between groups of records | Excel Discussion (Misc queries) | |||
Insert date automatically | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
How can I insert a cell reference in a footer (eg for variable foo | Excel Discussion (Misc queries) |