I would like to always put a standard footer on my Excel spreadsheets in
Office 2007. How can that be done?

You could record a macro of yourself putting in the footer you want on
your spreadsheet, then use it in the Workbook_Open event for your
personal.xlsb workbook.


HTH,
JP

On Apr 7, 1:01*pm, Hellmut <Hell...@discussions.microsoft.com> wrote:
> I would like to always put a standard footer on my Excel spreadsheets in
> Office 2007. How can that be done?

Can't you put the standard footer on each worksheet in your book.xlt template
workbook and store it in the XLStart folder?

Same as previous versions of excel????

Hellmut wrote:
>
> I would like to always put a standard footer on my Excel spreadsheets in
> Office 2007. How can that be done?

--

Dave Peterson

Dave do you not use 2007 either?

--JP

On Apr 7, 2:15*pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> Can't you put the standard footer on each worksheet in your book.xlt template
> workbook and store it in the XLStart folder?
>
> Same as previous versions of excel????
>
> Hellmut wrote:
>
> > I would like to always put a standard footer on my Excel spreadsheets in
> > Office 2007. How can that be done?
>
> --
>
> Dave Peterson

I have it installed on a Virtual PC. If I want to run it, I have to start the
VPC and then start xl2007. And for the most part, that's just too much work
<vbg>.

I use xl2003 for almost everything.

JP wrote:
>
> Dave do you not use 2007 either?
>
> --JP
>
> On Apr 7, 2:15 pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> > Can't you put the standard footer on each worksheet in your book.xlt template
> > workbook and store it in the XLStart folder?
> >
> > Same as previous versions of excel????
> >
> > Hellmut wrote:
> >
> > > I would like to always put a standard footer on my Excel spreadsheets in
> > > Office 2007. How can that be done?
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

You need to create a new, default workbook template and/or a new, default
worksheet template.
Open a new blank workbook and set up the footer for all of the worksheets
(and whatever else you find yourself changing for every workbook – in my own
I have also switched the layout to landscape, for example). Click Save as
and change the file type to Excel Template (*.xltx). Change the file name to
book.xltx and save it in the XLSTART folder under your office installation
folder. (Usually C:\Program Files\Microsoft Office\Office12\XLSTART). This
will take care of any new workbooks you open, if you also want it to apply to
new worksheets added to a workbook, however, delete all but the first sheet
in a new blank workbook, set that sheet up as desired and save it as
sheet.xltx in the same folder.


"Hellmut" wrote:

> I would like to always put a standard footer on my Excel spreadsheets in
> Office 2007. How can that be done?

Yes, you can. Tho it's book.xltx. :-)

"Dave Peterson" wrote:

> Can't you put the standard footer on each worksheet in your book.xlt template
> workbook and store it in the XLStart folder?
>
> Same as previous versions of excel????
>
> Hellmut wrote:
> >
> > I would like to always put a standard footer on my Excel spreadsheets in
> > Office 2007. How can that be done?
>
> --
>
> Dave Peterson
>

Or book.xltm????

Depending on if your template contains macros???

BoniM wrote:
>
> Yes, you can. Tho it's book.xltx. :-)
>
> "Dave Peterson" wrote:
>
> > Can't you put the standard footer on each worksheet in your book.xlt template
> > workbook and store it in the XLStart folder?
> >
> > Same as previous versions of excel????
> >
> > Hellmut wrote:
> > >
> > > I would like to always put a standard footer on my Excel spreadsheets in
> > > Office 2007. How can that be done?
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

Yes - but if you have both - book.xltx will be the one used.

"Dave Peterson" wrote:

> Or book.xltm????
>
> Depending on if your template contains macros???
>
> BoniM wrote:
> >
> > Yes, you can. Tho it's book.xltx. :-)
> >
> > "Dave Peterson" wrote:
> >
> > > Can't you put the standard footer on each worksheet in your book.xlt template
> > > workbook and store it in the XLStart folder?
> > >
> > > Same as previous versions of excel????
> > >
> > > Hellmut wrote:
> > > >
> > > > I would like to always put a standard footer on my Excel spreadsheets in
> > > > Office 2007. How can that be done?
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>

Thank you all who answered -- the detailed answer by BoniM was the most
useful one. It works fine.