Aug 02 2019 01:24 AM
I need to print the file name on all the workbooks, but i have to insert the same every time i open a new file. Is there any option by which i can put this setting in by default so that each and every excel file prints the file name. pl help
Aug 02 2019 02:44 AM
Hi @ashish0594
You can print file name on workbook by defining file name in the footer.
Click on print setup --> Header/Footer --> Custom Footer --> Click file name.
Aug 02 2019 02:54 AM
Aug 02 2019 03:30 AM
Hi
Here is a blog that explains how to deal with such situation in details
https://excel.tips.net/T002635_Default_Headers_and_Footers.html
Hope that helps
Nabil Mourad