ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why isn't Wordwrap not wrapping the last sentence? (https://www.excelbanter.com/excel-discussion-misc-queries/193783-why-isnt-wordwrap-not-wrapping-last-sentence.html)

RebeccaBeth

Why isn't Wordwrap not wrapping the last sentence?
 
I formatted my cell to wordwrap, and then I pasted a relatively large piece
of text. It did wordwrap over 20 lines, but then it stopped 10 words from
the end. The only way I could get all the text to show up was to put in
manual linefeeds. This doesn't happen all the time, just with a few cells.
Has anyone experienced this behavior, and do you know how to correct it?

Thanks very much,
Rebecca

Dave Peterson

Why isn't Wordwrap not wrapping the last sentence?
 
If you add alt-enters every 80-100 characters, then this problem should go away.

RebeccaBeth wrote:

I formatted my cell to wordwrap, and then I pasted a relatively large piece
of text. It did wordwrap over 20 lines, but then it stopped 10 words from
the end. The only way I could get all the text to show up was to put in
manual linefeeds. This doesn't happen all the time, just with a few cells.
Has anyone experienced this behavior, and do you know how to correct it?

Thanks very much,
Rebecca


--

Dave Peterson


All times are GMT +1. The time now is 09:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com