Nov 11 2021 01:12 PM
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
Nov 11 2021 11:46 PM
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)
Nov 12 2021 01:40 AM
Nov 12 2021 02:03 AM
Nov 12 2021 10:50 AM
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
Nov 13 2021 12:52 AM - edited Nov 13 2021 12:54 AM
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.
Nov 13 2021 01:03 AM