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 this is happening. The only answer I've been getting is to widen the column or auto-format the height. (I can widen the column and get more words on the first line but I'd rather keep my column width.) Any help would be greatly appreciated.
2 Replies
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.
