The text fits in a cell on the screen, but when I print part of it is omitted
because the cell box doesn't seem to be large enough. I can add a blank line
by using Alt-enter, but sometimes I need to add two lines. My text varies
from a few words to as many as 30. There has got to be a better way than
trying to guess if an additional line is needed an add it manually.
Sometimes worksheets have over 300 lines!!

Have you set the alignment for these cells to Wrap Text and the row height to
Auto?

On Fri, 25 Mar 2005 07:33:04 -0800, "MSUbully"
wrote:

The text fits in a cell on the screen, but when I print part of it is omitted
because the cell box doesn't seem to be large enough. I can add a blank line
by using Alt-enter, but sometimes I need to add two lines. My text varies
from a few words to as many as 30. There has got to be a better way than
trying to guess if an additional line is needed an add it manually.
Sometimes worksheets have over 300 lines!!

Thanks for responding. I have struggeled with this problem for years!! Yes,
I have set the cells to Wrap Text and the row height to AutoFit.

"Myrna Larson" wrote:

Have you set the alignment for these cells to Wrap Text and the row height to
Auto?

On Fri, 25 Mar 2005 07:33:04 -0800, "MSUbully"
wrote:

The text fits in a cell on the screen, but when I print part of it is omitted
because the cell box doesn't seem to be large enough. I can add a blank line
by using Alt-enter, but sometimes I need to add two lines. My text varies
from a few words to as many as 30. There has got to be a better way than
trying to guess if an additional line is needed an add it manually.
Sometimes worksheets have over 300 lines!!