Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto fit and text wrapping problem | Excel Worksheet Functions | |||
Wrapping text leaves blank line when printing | Excel Discussion (Misc queries) | |||
Text to Columns with Line Breaks. | Excel Discussion (Misc queries) | |||
No wrapping, but keep line breaks | Excel Discussion (Misc queries) | |||
Problem: Copying a cell that contains line breaks adds extra quotes | Excel Discussion (Misc queries) |