I have a spreadsheet where a column of cells can easily contain 1500
characters or more.

Problem comes when viewing it on screen or printing. We can put more
characters per cell in Excel 2007, but it still limits the row height and
width.

Worse, I can't seem to tell from the monitor what it's gonna look like when
it prints. That's very un-WYSIWYG.

When I tried double-clicking to autofit the row height, it worked
sometimes... and didn't work sometimes.

So I manually change the row height and use print preview. I'm not sure if
print preview is the way to go, however. Maybe, I should test print each row
change -- but that's very onerous.

Is there a way I can reliably tell if all the text in a cell is going to be
displaying or printing? Or a way I can quickly get the row height to be set
properly to print/display its contents?

--
JohnTheTemp