Save Header and Footer Format and Content in Excel

[PeterKelsch]

Can the default Header/Footer content be changed so that whenever I open a new workbook it comes with the following footer (or Header) in all worksheets:

[FileName, RPK] then centre [Current Date] then right [Page 1 of ?] all in Calibri/Regular/8point. 

I see there are "Built-Ins", prefer that every workbook I open had this already, but if not availalbe, then a built-in that could do it quickly. 

I like the fact that the date is 2020-05-19 but is there any way to format the date in a Footer/Header to be 2020-May-19 instead?

Thank you. 

[#2]

Hello,

You can have a Custom Header and Footers.

Kindly see the link below to guide you

https://www.lifewire.com/add-headers-and-footers-to-excel-worksheets-3124044

[#3]

@Abiola1 

Thanks for your response. I knew about making a Custom Header/Footer, I wanted to be able to have that custom footer appear automatically every time I started a new workbook, without going to the Page Layout launcher. 

Failing that, adding MY CUSTOM Footer to the launcher so that I can choose it everytime I need it. 

Do you have a suggestion for that? 

Thanks