Forum Discussion
ashish0594
Aug 02, 2019Copper Contributor
how can i print file name by default for all excel sheets?
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
3 Replies
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
- tauqeeracmaIron Contributor
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.
- tauqeeracmaIron ContributorYou can also make an excel template and define file name in the footer. Next time when you make new file open that template and save as with any desired name , it will automatically show new file name. Thanks