Same footer in all Excel workbooks

  • Thread starter Thread starter Carol Sitea
  • Start date Start date
C

Carol Sitea

Is there a way to add a custom footer to be included in all new Excel
workbooks. The users wants to be able to select the same custom footer
to use in new worksheets.

Thanks
Carol
 
Create a New Workbook

Apply pagesetup as you say Constant Footer to all New Books to all Sheets in
the workbook

Then choose file /save as
then
Select Template in Save as Type list

then Select XLSTART Folder on your system

it is programme files/Microsoft office/office/XLSTART

Give filename as Book

save the file

close the

then
Do same things with only one sheet in the Workbook

and give filename as sheet

this will do foe your problem

tha xlstart path varies for versions of office

Rajan
 
Back
Top