software

Hai all,
Any got any word about how can we edit or add quot;built inquot; footer and
header(dropdown list in header/footer tab from the page setup menu) in
Excel. So that any time we create a new file these newer footers are
availiable.
Thanks a lot
Itty--
itty
------------------------------------------------------------------------
itty's Profile: www.excelforum.com/member.php...foamp;userid=1259
View this thread: www.excelforum.com/showthread...hreadid=537970Hi Itty,

gt; Any got any word about how can we edit or add quot;built inquot; footer and
gt; header(dropdown list in header/footer tab from the page setup menu) in
gt; Excel. So that any time we create a new file these newer footers are
gt; availiable.

We'll build a custom template that will be used for all your new
workbooks:

- Create an empty workbook with all sheets you want
- Select all these sheets (shift-click their tabs)
- select that particular footer and edit it so it looks the way you like
- Change other printing options while you're at it.
- rightclick a sheet tab and select ungroup

Now it is time to save this file as the default template for Excel:

- Select File, Save-as.
- In the bottom dropdown, choose filetype quot;Template (*.xlt)quot;
- Now Excel has changed the folder. Make sure you select this folder to
save the file into:
c:\documents and settings\USERNAME\Application
Data\Microsoft\Excel\Xlstart\
- Name the file Book.xlt

You can also ensure any NEW worksheets are getting this header/footer:

- remove all sheets but one
- repeat the save process above, but name the file Sheet.xlt.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.comItty

One thing to note about BOOK.XLT............................

The Blank workbook that opens using File New...(note ellipsis)gt;Blank Workbook
is not the BOOK.XLT you stored in the XLSTART folder.

Use the other Filegt;New command(the one without the ellipsis...) or the New
File button on the Toolbar. Either of those will give you your default
BOOK.XLT directly from your XLSTART folder.

If not on your File Menu, go to Toolsgt;Customizegt;Commandsgt;File and drag the
quot;Newquot; command to the File Menu.

Check out the descriptions of the two quot;Newquot; commands while you're there. You
will see the difference between the two.

Also check out this search thread

snipurl.com/pxswGord Dibben MS Excel MVP

On Tue, 02 May 2006 10:32:02 0200, Jan Karel Pieterse gt;
wrote:

gt;Hi Itty,
gt;
gt;gt; Any got any word about how can we edit or add quot;built inquot; footer and
gt;gt; header(dropdown list in header/footer tab from the page setup menu) in
gt;gt; Excel. So that any time we create a new file these newer footers are
gt;gt; availiable.
gt;
gt;We'll build a custom template that will be used for all your new
gt;workbooks:
gt;
gt;- Create an empty workbook with all sheets you want
gt;- Select all these sheets (shift-click their tabs)
gt;- select that particular footer and edit it so it looks the way you like
gt;- Change other printing options while you're at it.
gt;- rightclick a sheet tab and select ungroup
gt;
gt;Now it is time to save this file as the default template for Excel:
gt;
gt;- Select File, Save-as.
gt;- In the bottom dropdown, choose filetype quot;Template (*.xlt)quot;
gt;- Now Excel has changed the folder. Make sure you select this folder to
gt;save the file into:
gt;c:\documents and settings\USERNAME\Application
gt;Data\Microsoft\Excel\Xlstart\
gt;- Name the file Book.xlt
gt;
gt;You can also ensure any NEW worksheets are getting this header/footer:
gt;
gt;- remove all sheets but one
gt;- repeat the save process above, but name the file Sheet.xlt.
gt;
gt;Regards,
gt;
gt;Jan Karel Pieterse
gt;Excel MVP
gt;www.jkp-ads.com