Dave,

I thought about doing that, but I don't know how to "automatically" add
alt-enter to all of these cells. As I mentioned, I will have a total of over
3,000 cells like this - all with different text. I definitely don't want to
have to manually add the alt-enter. I wasn't sure how to write a VBA code for
it or if there was a simpler way to add alt-enter to all of the cells.

Stacy

"Dave Peterson" wrote:

Maybe you could add an alt-enter as the last character in the cell.

You'll see an "extra" line on some printers, but at least the last line being
chopped won't matter.

stacyjean622 wrote:

I am having an issue printing text that is wrapped. It is NOT a merged cell;
the column has a fixed width; the cell has wrap text turned on and it is set
to auto fit. (This is important as I have a workbook with over 150
worksheets; each worksheet has 27 rows with text in this column and each row
in each sheet is different; some have several sentences and some have two
words. So I cannot take the time to manually adjust these rows.)

When I look at the text on my screen it shows up perfectly. When I print on
one printer it comes out fine; on another printer it cuts off the bottom line
on some rows and cuts into the bottom line on many others. I assume this is
some kind of printer problem. Is there a way I can fix it for ANY printer? I
am going to have to send this workbook to someone else when it is finished
and I have no idea what that person's printer will do.

Any help is much appreciated. Thanks!

Stacy

--

Dave Peterson