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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies