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
Excel Print Preview not matching the actual printed document
Gano1224 in Excel on
12 Replies
Setting up default formats
ALLBYAPRIL in Excel on
1 Replies
Print two areas
Hugh Delaney in Excel on
1 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies