ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Wrapping text with line breaks problem (https://www.excelbanter.com/excel-discussion-misc-queries/223723-wrapping-text-line-breaks-problem.html)

CC91884

Wrapping text with line breaks problem
 
When using the wrap text command in a cell that has text which includes
multiple line breaks, it doesn't work properly. The first three paragraphs
are fine and wrap in the cell as desired. However every additional line
break causes the following paragraph to fail to wrap and the text to extend
out of the cell (invisibly) leaving the only visible remnant of that
paragraph as the first few words in that para contained on a single line and
nothing more.

I've tried to illustrate it below where ':' represents part of the right
hand side cell wall.

This paragraph wraps correctly :
and every word can be seen. :
~line break~ :
This paragraph also wraps :
correctly. :
~line break~ :
The third paragraph is the final :
one that wraps correctly. :
~line break~ :
Now the wrap fails and the wor: (ds extend invisibly out the cell)
~line break~ :
Only a single line of text can be : (seen regardless of how long the
paragraph is)
~line break~ :

Etc.

This occurs in merged and single cells alike. I can't find any way round it.

Shane Devenshire

Wrapping text with line breaks problem
 
Hi,

How are you making your line breaks? You should be using Alt+Enter at every
point where you want a line break.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"CC91884" wrote:

When using the wrap text command in a cell that has text which includes
multiple line breaks, it doesn't work properly. The first three paragraphs
are fine and wrap in the cell as desired. However every additional line
break causes the following paragraph to fail to wrap and the text to extend
out of the cell (invisibly) leaving the only visible remnant of that
paragraph as the first few words in that para contained on a single line and
nothing more.

I've tried to illustrate it below where ':' represents part of the right
hand side cell wall.

This paragraph wraps correctly :
and every word can be seen. :
~line break~ :
This paragraph also wraps :
correctly. :
~line break~ :
The third paragraph is the final :
one that wraps correctly. :
~line break~ :
Now the wrap fails and the wor: (ds extend invisibly out the cell)
~line break~ :
Only a single line of text can be : (seen regardless of how long the
paragraph is)
~line break~ :

Etc.

This occurs in merged and single cells alike. I can't find any way round it.



All times are GMT +1. The time now is 05:49 AM.

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