Forum Discussion
Wrap Text Not Wrapping Correctly
I'm using Wrap Text in a few different columns but I only have one where it will start wrapping after the first word even if there's room for the next word. I have not been able to figure out why thi...
Unfortunately, Excel's algorithm for wrapping text is not perfect. It will wrap lines too early quite often.
Also, the algorithm for wrapping text in printed output frequently produces a different result than that for the on-screen display.
You'll have to live with it, and use trial-and-error to get it to look the way you want.
And to add baffle to confusion you can try zoom in and zoom out because I have found that to cause word wrapping to change also. When I'm reviewing documents where word wrapping may matter I have tried using 160% or 140% zoom as that seemed to be more 'true' to the print to pdf word wrap but that is probably dependant on the font and who knows what else.