software

Is it possible to insert a footer in an Excel document so that it appears on
all new worksheets I open?

Start a new workbook. Do all the stuff you like for each worksheet in that
workbook.

Save it as a template file named book.xlt in your XLStart folder.

Each time you click on the new icon on the standard toolbar, that new workbook
will inherit all the settings from that template file.

If you want new worksheets added to existing workbooks to have these same
settings, set up another workbook template file (one sheet only???) and name it
sheet.xlt. Save it in the same XLStart folder.SUE R wrote:
gt;
gt; Is it possible to insert a footer in an Excel document so that it appears on
gt; all new worksheets I open?

--

Dave Peterson

Start a new workbook
Enter the details needed in Footer
Save workbook as SHEET.XLT in the XLStart folder
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;SUE Rquot; lt;SUE gt; wrote in message
...
gt; Is it possible to insert a footer in an Excel document so that it appears
gt; on
gt; all new worksheets I open?
Where do I find the XL Start folder?

quot;SUE Rquot; wrote:

gt; Is it possible to insert a footer in an Excel document so that it appears on
gt; all new worksheets I open?

Possible place if you have Excel 2003
C:\Documents and Settings\username\Application Data\Microsoft\Excel
C:\Program Files\Microsoft Office\Office11
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from emailquot;SUE Rquot; gt; wrote in message
...
gt; Where do I find the XL Start folder?
gt;
gt; quot;SUE Rquot; wrote:
gt;
gt;gt; Is it possible to insert a footer in an Excel document so that it appears
gt;gt; on
gt;gt; all new worksheets I open?
One way is let excel tell you:

Open excel
hit alt-f11 (to get to the VBE)
hit ctrl-g (to see the immediate window)

type this and hit enter.
?application.startuppath

For me (xl2003 and winXP):
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART
SUE R wrote:
gt;
gt; Where do I find the XL Start folder?
gt;
gt; quot;SUE Rquot; wrote:
gt;
gt; gt; Is it possible to insert a footer in an Excel document so that it appears on
gt; gt; all new worksheets I open?

--

Dave Peterson