Can't get Excel to print wrapped lines correctly

[Guest]

I have a spreadsheet with data in 10 or so columns and 20 or so rows. I have
found that lines don't wrap in the same place in Normal View as they do in
Print Preview (and the resulting hardcopy when you print). For example, in a
particular cell (a text cell formatted as General) containing several lines
of text, the text all appears OK in Normal view, but when I do Print Preview,
or print the page, it turns out that the bottom line of text in several of my
rows is either half-obscured or chopped off by the bottom cell border, or the
bottom line doesn't print at all. I have played with Autofit, etc. and I
have found so far the only way to fix this is to manually drag the bottom
cell border lower for each row where this happens. This results in a
non-uniform appearance, is tedious in a worksheet with many rows because you
have to manually tweak each row, and have to repeat this any time you edit
the text in the cell, and also results in extra white space at the bottom of
a cell in Normal view. There's gotta be a better way! I am somewhat of an
Excel novice, so I'm assuming there is a better way...

 

[Dave Peterson]

This doesn't always work, but sometimes I make sure that the last character in
the cell is alt-enter.

or as a formula:
=(Your existing formula) & char(10)

It may not look as pretty, but I don't usually have to worry about the "half
line" printing.