ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automatic or default footer? (https://www.excelbanter.com/excel-discussion-misc-queries/77572-automatic-default-footer.html)

Rainie

Automatic or default footer?
 
Is there a way to set up an automatic or default footer?

Dave Peterson

Automatic or default footer?
 
Start a new workbook. Do all the stuff you like for each worksheet in that
workbook.

Save it as a template file named book.xlt in your XLStart folder.

Each time you click on the new icon on the standard toolbar, that new workbook
will inherit all the settings from that template file.

If you want new worksheets added to existing workbooks to have these same
settings, set up another workbook template file (one sheet only???) and name it
sheet.xlt. Save it in the same XLStart folder.

Rainie wrote:

Is there a way to set up an automatic or default footer?


--

Dave Peterson


All times are GMT +1. The time now is 02:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com