I can't get my head around this. I have a cell that contains text that is too long to fit on a single line. I've wrapped the text and set the row to autofit. It looks fine in Normal view, but when I look at the page in Print Preview more text fits on a line. Hence I'm left with unnecessary white space in the print out.

I've done some searching and made sure the worksheet is at 100% and that I'm using the "Normal" style font; Calibri 9pt.

I've already found that if the text extends over 4 lines then auto-fit gives me an unnecessary line, so I've reduced the height of these rows accordingly.

However, I have a cell that contains 2.5 rows in Normal view but squeezes onto 2 lines in Print Preview, leaving me with a blank line in the print out.

Can anyone help me figure out either how to prevent this from happening, or determining when it will happen so that I can fix it accordingly?

Thanks