Home

how can i print file name by default for all excel sheets?

%3CLINGO-SUB%20id%3D%22lingo-sub-785320%22%20slang%3D%22en-US%22%3Ehow%20can%20i%20print%20file%20name%20by%20default%20for%20all%20excel%20sheets%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-785320%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20print%20the%20file%20name%20on%20all%20the%20workbooks%2C%20but%20i%20have%20to%20insert%20the%20same%20every%20time%20i%20open%20a%20new%20file.%20Is%20there%20any%20option%20by%20which%20i%20can%20put%20this%20setting%20in%20by%20default%20so%20that%20each%20and%20every%20excel%20file%20prints%20the%20file%20name.%20pl%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-785320%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFunctions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-785417%22%20slang%3D%22en-US%22%3ERe%3A%20how%20can%20i%20print%20file%20name%20by%20default%20for%20all%20excel%20sheets%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-785417%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F386236%22%20target%3D%22_blank%22%3E%40ashish0594%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20print%20file%20name%20on%20workbook%20by%20defining%20file%20name%20in%20the%20footer.%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3EClick%20on%20print%20setup%20--%26gt%3B%20Header%2FFooter%20--%26gt%3B%20Custom%20Footer%20--%26gt%3B%20Click%20file%20name.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125381i8364D39317DC1BEB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22File%20Name.JPG%22%20title%3D%22File%20Name.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-785420%22%20slang%3D%22en-US%22%3ERe%3A%20how%20can%20i%20print%20file%20name%20by%20default%20for%20all%20excel%20sheets%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-785420%22%20slang%3D%22en-US%22%3EYou%20can%20also%20make%20an%20excel%20template%20and%20define%20file%20name%20in%20the%20footer.%20Next%20time%20when%20you%20make%20new%20file%20open%20that%20template%20and%20save%20as%20with%20any%20desired%20name%20%2C%20it%20will%20automatically%20show%20new%20file%20name.%20Thanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-785475%22%20slang%3D%22en-US%22%3ERe%3A%20how%20can%20i%20print%20file%20name%20by%20default%20for%20all%20excel%20sheets%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-785475%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F386236%22%20target%3D%22_blank%22%3E%40ashish0594%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EHere%20is%20a%20blog%20that%20explains%20how%20to%20deal%20with%20such%20situation%20in%20details%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.tips.net%2FT002635_Default_Headers_and_Footers.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.tips.net%2FT002635_Default_Headers_and_Footers.html%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
ashish0594
Occasional Visitor

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 @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.

File Name.JPG

You 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

@ashish0594 

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