PC Review


Reply
Thread Tools Rate Thread

Default Footer in Excel

 
 
=?Utf-8?B?RGFuaWVsbGU=?=
Guest
Posts: n/a
 
      13th Sep 2007
Is there a way to set a default footer in Excel?
 
Reply With Quote
 
 
 
 
papou
Guest
Posts: n/a
 
      13th Sep 2007
Hello Danielle
Take a new workbook, set your footer, save your workbook as Book.XLT and
place it in the xlstart folder.

HTH
Cordially
Pascal

"Danielle" <(E-Mail Removed)> a écrit dans le message de
news: 75854286-91A0-41EA-96A8-(E-Mail Removed)...
> Is there a way to set a default footer in Excel?



 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      13th Sep 2007
Open a new workbook. Customize as you wish. To set a footer for each sheet,
select a sheet then right-click and "select all sheets".

Enter your footer on the active sheet and will be done to all. Ungroup sheets
when done.

File>Save As Type: scroll down to Excel Template(*.XLT) and select. Name your
workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for File>New or the Toolbar button File>New or
CTRL + n

WARNING................Do not use File>New...Blank Workbook or you will get the
Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default Insert>Sheet.

More can be found on this in Help under "templates"(no quotes).


Gord Dibben Excel MVP

On Thu, 13 Sep 2007 07:06:09 -0700, Danielle
<(E-Mail Removed)> wrote:

>Is there a way to set a default footer in Excel?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i default a footer in all the excel files i open Vikas Microsoft Excel Worksheet Functions 1 5th Feb 2009 04:33 PM
Excel footer default font size Rhiannon Thomas Microsoft Excel Worksheet Functions 1 26th Sep 2008 12:28 AM
default footer for all new Excel books? Hanne Microsoft Excel Misc 4 14th Jan 2008 06:07 PM
How do I set default footer setting on excel spreadsheets? =?Utf-8?B?TWFkaXNvbjEyMTY=?= Microsoft Excel Worksheet Functions 1 3rd Aug 2006 05:46 PM
How do I set up a default footer to be used in all Excel sheets =?Utf-8?B?Um9zc0M=?= Microsoft Excel Misc 1 30th May 2006 02:12 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:51 AM.