Can you put a standard footer on Excel 2007 spreadsheets?
 

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

Can you put a standard footer on Excel 2007 spreadsheets?
 

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 wrote:
I would like to always put a standard footer on my Excel spreadsheets in
Office 2007. How can that be done?

Can you put a standard footer on Excel 2007 spreadsheets?
 

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

Can you put a standard footer on Excel 2007 spreadsheets?
 

Dave do you not use 2007 either?

--JP

On Apr 7, 2:15*pm, 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

Can you put a standard footer on Excel 2007 spreadsheets?
 

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 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

Can you put a standard footer on Excel 2007 spreadsheets?
 

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?

Can you put a standard footer on Excel 2007 spreadsheets?
 

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

Can you put a standard footer on Excel 2007 spreadsheets?
 

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

Can you put a standard footer on Excel 2007 spreadsheets?
 

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

Can you put a standard footer on Excel 2007 spreadsheets?
 

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

Can you put a standard footer on Excel 2007 spreadsheets?
 

LOL sorry to hear it!


--JP

On Apr 7, 2:33*pm, Dave Peterson wrote:
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.