Excel help with formatting - need an expert

%3CLINGO-SUB%20id%3D%22lingo-sub-2956629%22%20slang%3D%22en-US%22%3EExcel%20help%20with%20formatting%20-%20need%20an%20expert%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2956629%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESomething%20weird%20is%20going%20on%20with%20a%20workbook%20I%20am%20using.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20text%20within%20cells%2C%20when%20I%20print%20preview%2C%20the%20page%20seems%20to%20add%20a%20little%20on%20to%20the%20row%2C%20which%20is%20maing%20some%20words%20appear%20on%20the%201st%20row%2C%20rather%20than%20where%20it%20should%20be%2C%20i.e.%20on%20the%20second.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20I%20am%20using%20calibri%20font%20size%2012%2C%20and%20auto%20height%20adjust%2C%20which%20changes%20to%2015.75%2C%20when%20I%20am%20in%20print%20preview%2C%20not%20all%20of%20the%20the%20top%2Fbottom%20of%20text%20can%20be%20seen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20unable%20to%20produce%20a%20sample%20workbook%2C%20however%20when%20I%20add%20the%20same%20text%20within%20a%20merged%20cell%2C%20everything%20looks%20as%20it%20should.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETherefore%20I%20am%20assuming%20it%20is%20somehting%20with%20how%20this%20workbook%20is%20set%20up%3F%20I%20know%20it%20was%20created%20many%20years%20ago%2C%20and%20I%20use%20365%20for%20business%2C%20not%20sure%20if%20that%20%2F%20some%20weird%20formatting%20has%20anything%20to%20do%20with%20it%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2956629%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2957734%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20help%20with%20formatting%20-%20need%20an%20expert%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2957734%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F981308%22%20target%3D%22_blank%22%3E%40Robert1290%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%E2%80%99re%20looking%20to%20ask%20a%20question%20or%20start%20a%20conversation%20about%20Excel%2C%20you%E2%80%99re%20in%20the%20right%20place!%3C%2FP%3E%3CP%3EPlease%20include%20your%20%3CSTRONG%3EExcel%20version%3C%2FSTRONG%3E%2C%20%3CSTRONG%3Esample%20file%3C%2FSTRONG%3E%2C%20and%20a%20bit%20of%20%3CSTRONG%3Econtext%3C%2FSTRONG%3E%20to%20help%20others%20answer%20your%20question.%3C%2FP%3E%3CP%3ELink%20with%20more%20Information%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3E%3CSPAN%20class%3D%22%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%20%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2957986%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20help%20with%20formatting%20-%20need%20an%20expert%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2957986%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%3CBR%20%2F%3EI%20have%20attached%20a%20sample%20workbook%2C%20which%20shows%20text%20being%20chopped%20off%20vertically.%20I%20do%20not%20know%20if%20I%20can%20get%20a%20sample%20across%20of%20the%20other%20problem%2C%20if%20I%20can%20I%20will.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20need%20to%20get%20this%20to%20a%20pdf%2C%20with%20all%20the%20text%20showing.%20I%20would%20like%20to%20use%20auto%20height%20if%20possible.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%2C%3CBR%20%2F%3E%3CBR%20%2F%3ERob%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2958043%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20help%20with%20formatting%20-%20need%20an%20expert%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2958043%22%20slang%3D%22en-US%22%3EPerhaps%20I%20am%20not%20the%20most%20suitable%20to%20give%20you%20an%20answer%20to%20your%20problem%2C%3CBR%20%2F%3EI%20realy%20don't%20know%20...but%20please%20allow%20me%20to%20help%20you%20so%20that%20you%20can%20come%20to%20an%20answer.%3CBR%20%2F%3EIn%20order%20not%20to%20annoy%20you%20any%20more%2C%20I'll%20keep%20it%20short%20%3A).%3CBR%20%2F%3EPlease%20attach%20a%20file%20(without%20sensitive%20data)%20with%20the%20given%20problem.%3CBR%20%2F%3EExplain%20the%20problem%20step%20by%20step%2C%20based%20on%20the%20inserted%20file.%3CBR%20%2F%3EInclude%20information%20about%20your%20Excel%20version%20(365%20for%20business%20-%20is%20known%20already)%3CBR%20%2F%3Eand%20operating%20system.%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20you%20could%20get%20an%20answer%20much%20faster%20and%20more%20precisely%20from%20the%20helpers%20present.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20patience%20and%20time.%3C%2FLINGO-BODY%3E
Contributor

Hi,

 

Something weird is going on with a workbook I am using.

 

I have text within cells, when I print preview, the page seems to add a little on to the row, which is maing some words appear on the 1st row, rather than where it should be, i.e. on the second.

 

Also, I am using calibri font size 12, and auto height adjust, which changes to 15.75, when I am in print preview, not all of the the top/bottom of text can be seen.

 

I am unable to produce a sample workbook, however when I add the same text within a merged cell, everything looks as it should.

 

Therefore I am assuming it is somehting with how this workbook is set up? I know it was created many years ago, and I use 365 for business, not sure if that / some weird formatting has anything to do with it??

 

Please help.

 

Regards,

 

Rob

6 Replies

@Robert1290 

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!

Please include your Excel version, sample file, and a bit of context to help others answer your question.

Link with more Information

Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

@NikolinoDE
I have attached a sample workbook, which shows text being chopped off vertically. I do not know if I can get a sample across of the other problem, if I can I will.

I need to get this to a pdf, with all the text showing. I would like to use auto height if possible.

Thanks,

Rob
Perhaps I am not the most suitable to give you an answer to your problem,
I realy don't know ...but please allow me to help you so that you can come to an answer.
In order not to annoy you any more, I'll keep it short :).
Please attach a file (without sensitive data) with the given problem.
Explain the problem step by step, based on the inserted file.
Include information about your Excel version (365 for business - is known already)
and operating system.

So you could get an answer much faster and more precisely from the helpers present.

Thank you for your patience and time.

@NikolinoDE 

Thanks, I have attached the sample workbook, If I could just get a hand with the height of text being chopped off for now that would be great. No need to know about previous versions of Excel for this, as in my current version I come up with this problem.

 

Thanks in advance.

 

Rob

@Robert1290 

 

Align or justify text

 

Go to the area with the mouse.

Press the right mouse button.

 

Window opens and below you will find

click on the command “Format rows…“.

 

A new window will appear, click on "Alignment" at the top.

 

Then change the "Text alignment"

in the drop down menu of "Horizontal:"

from "justified" to "standard",

or whichever setting you want.

 

So the text should be what you want it to be again.

 

*These steps were created with and for Excel 2016, for all newer Excel versions go to the link above. 

 

If this does not solve the problem, please let us know so that we can look for a different approach.

 

@NikolinoDE

This can now be closed, I have raised a separate question and it seems that as I am merging both horizontally and vertically I need to make amendments manually.

Rob