Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 29th 05, 01:38 AM
Belinda
 
Posts: n/a
Default 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   Report Post  
Old September 29th 05, 02:30 AM
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 - Footer Left/Right Margins Laura J Excel Discussion (Misc queries) 3 October 4th 05 10:46 PM
How do I start Excel Footer on 2nd page? dicfor Excel Worksheet Functions 3 September 3rd 05 07:59 PM
Can I put a footer in Excel on first page of a worksheet only. Tanya Excel Discussion (Misc queries) 1 June 16th 05 05:08 PM
How to insert a picture in the Footer (not the Header) in Excel 20 jmon Excel Worksheet Functions 2 March 17th 05 05:59 AM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM


All times are GMT +1. The time now is 07:19 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017