Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set up Excel to ALWAYS on put a footer?
I am always using excel for different things during the day, and would like
excel to 'always' put the file name as the Footer? That way - I can always go back to the right file later without having to remember where i saved it. |
#2
|
|||
|
|||
What version of excel are you using?
If you're using xl2002+, you can create a template workbook (save it as book.xlt in your XLStart folder). Include the path in the footer for each worksheet in that template workbook. When you click on the new icon on the standard toolbar, excel will use that book.xlt as the template for the new workbook. You can also create a new template named Sheet.xlt (also in XLStart) that will be used as the template when adding new sheets to existing workbooks. === If you're using xl2k or earlier, you could use an John Walkenbach's addin that does the work for you. http://j-walk.com/ss/excel/files/addpath.htm Belinda wrote: I am always using excel for different things during the day, and would like excel to 'always' put the file name as the Footer? That way - I can always go back to the right file later without having to remember where i saved it. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - Footer Left/Right Margins | Excel Discussion (Misc queries) | |||
How do I start Excel Footer on 2nd page? | Excel Worksheet Functions | |||
Can I put a footer in Excel on first page of a worksheet only. | Excel Discussion (Misc queries) | |||
How to insert a picture in the Footer (not the Header) in Excel 20 | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |