copying Footer

[zhj23]

Hello! Friends

I have two questions related to Footer:

1. I have a customised Footer in WORDS, how can I copy and paste to EXCEL?

2. How can I copy and paste Footer from one EXCEL BOOK to another, other
than deleting the contents of the source book?

Thanks.


zhj23

 

[Gord Dibben]

Footers/Headers are the property of the workbook.

Copying would have to be done simply by copy and paste.

For all new workbooks create a new default workbook with the footer and any
other customizing you wish.

Open a new workbook. Customize as you wish with your custom footer.

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 MS Excel MVP

 

[zhj23]

Hello! Thank for the reply.

What about copying a customised Footer from WORDS and Paste to EXCEL?
Possible to accomplish that?

zhl23

-------------------------------------------------

 

[Gord Dibben]

In Word with the View>Headers/Footers open, CTRL + C to copy.

In Excel with View>Headers/Footers open select Custom Footer then CTRL + V to
paste.


Gord

 

[zhj23]

Thanks. I was right clicking the EXCEL Footer to get the "Paste" command,
but it wasn't there. I didn't know I must use CTRL+V.

Sorry for asking stupid question.


zhj23
---------------------------------------