Forum Discussion
PeterKelsch
May 20, 2020Copper Contributor
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.
2 Replies
Sort By
- 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- PeterKelschCopper Contributor
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