how do I modify and save a default footer?

B

Bob Umlas

Create a new workbook, put your desired footer in all sheets in it, save it
as a template (*.xlt), name it book.xlt in the XLSTART directory, exit
Excel. All NEW workbooks will be as desired.
 
Top