software

I want all my new worksheets to default to a footer that includes the path
and file name. How can I accomplish that in Excel?

Create a new file with the footer in it, and save it as book.xlt in your
XLSTART directory. Close Excel and reopen. The blank file should have the
footer.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;Frank Youngerquot; lt;Frank gt; wrote in message
...
gt;I want all my new worksheets to default to a footer that includes the path
gt; and file name. How can I accomplish that in Excel?
It worked like a charm. I also set the default number format that I like to
use in the file and that appears in the new file each time as well.
Incredibly helpful. Thanks!

quot;Anne Troyquot; wrote:

gt; Create a new file with the footer in it, and save it as book.xlt in your
gt; XLSTART directory. Close Excel and reopen. The blank file should have the
gt; footer.
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt;
gt; quot;Frank Youngerquot; lt;Frank gt; wrote in message
gt; ...
gt; gt;I want all my new worksheets to default to a footer that includes the path
gt; gt; and file name. How can I accomplish that in Excel?
gt;
gt;
gt;

You're welcome!
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;Frank Youngerquot; gt; wrote in message
...
gt; It worked like a charm. I also set the default number format that I like
gt; to
gt; use in the file and that appears in the new file each time as well.
gt; Incredibly helpful. Thanks!
gt;
gt; quot;Anne Troyquot; wrote:
gt;
gt;gt; Create a new file with the footer in it, and save it as book.xlt in your
gt;gt; XLSTART directory. Close Excel and reopen. The blank file should have the
gt;gt; footer.
gt;gt; ************
gt;gt; Hope it helps!
gt;gt; Anne Troy
gt;gt; www.OfficeArticles.com
gt;gt;
gt;gt; quot;Frank Youngerquot; lt;Frank gt; wrote in
gt;gt; message
gt;gt; ...
gt;gt; gt;I want all my new worksheets to default to a footer that includes the
gt;gt; gt;path
gt;gt; gt; and file name. How can I accomplish that in Excel?
gt;gt;
gt;gt;
gt;gt;