Text not wrapping, wrap and autofit both on

caroleary

New Member
Joined
Jun 11, 2007
Messages
3
My coworker has a large spreadsheet she updates monthly. One column has text description that doesn't quite wrap-- but only a letter or so will overlap into the next cell.
There is plenty of room in the last line in the cell for the text to fit into, it just doesn't wrap where it should.
Now, if she prints an old spreadsheet saved from months ago, that wraps fine. If she prints her current spreadsheet to a different printer, again, it wraps fine. But she needs it to be on ledger size paper and in color, which limits her to the HP Laserjet 5500, and on that printer the new one doesn't wrap correctly. (Remember it does print her old spreadsheet fine).
What is that!!!
She has autofit on, wrap text is on, and there is room for the text to wrap and push into the last line of text in the cell.
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Okay, I solved it. I don't know why the old one prints correctly, but I do know the new one prints just fine to a PCL driver vs. the PS driver she was using. It was probably changed somewhere along the way and since then she's had the problem.
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,192
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top