Forum Discussion

PeterKelsch's avatar
PeterKelsch
Copper Contributor
May 20, 2020

Save Header and Footer Format and Content in Excel

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. 

excel

2 Replies

    • PeterKelsch's avatar
      PeterKelsch
      Copper Contributor
      May 20, 2020

      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

       

Resources