Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 857
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto fit and text wrapping problem LyleB_Austin Excel Worksheet Functions 1 January 22nd 09 04:39 PM
Wrapping text leaves blank line when printing [email protected] Excel Discussion (Misc queries) 1 November 19th 08 04:06 PM
Text to Columns with Line Breaks. eSite Excel Discussion (Misc queries) 3 May 2nd 08 02:44 PM
No wrapping, but keep line breaks Paul Excel Discussion (Misc queries) 2 April 1st 08 10:47 PM
Problem: Copying a cell that contains line breaks adds extra quotes [email protected] Excel Discussion (Misc queries) 0 November 2nd 06 07:58 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"