Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 105
Default Word wrap problem - Merged cells

Good day,

Excel 2003, XP.

This is weird. I have merged 5 cells, typed in 324 words (1,884 characters
without space and 2,204 with space). This text is separated into 4
paragraphs.

Word wrap is activated.

The two last paragraphs do not fit in the cell. The last 5 words or so of
each line of these two paragraphs are exceeding the cell.

Try as I might, I cannot correct this unless I manually put in a couple of
Alt+Returns, which, to my knowledge, I shouldn't have to do since I did not
have to do it in the first two paragraphs.

Any idea why I have this problem? And I get this problem all the time.

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Word wrap problem - Merged cells

Helen, I encountered exactly the same problem on the same platform Excel
2003-WindowsXP. This is utterly weird. I had three merged cells and 2010
characters (with spaces) and 13 carriage returns. I then tried putting
everything in one cell with row height set to maximum (409) but the problem
still persisted. I noticed that text wrapping stops functioning after 1061
characters (with spaces). That's again very strange and contrary to what's in
Wikianswers
http://wiki.answers.com/Q/How_many_c...icrosoft_Excel
, the maximum characters can be seen in a cell is 1024. Well, in the end I
had to do the same - to fit in all text using ALT-Enter...very impractical
solution though. While looking for answers in the web for this problem, I
found out that there are many people out there frustrated by this word
wrapping issue in Excel and it's there since as long as 2005. Shouldn't it be
resolved by now???

"Helen" wrote:

Good day,

Excel 2003, XP.

This is weird. I have merged 5 cells, typed in 324 words (1,884 characters
without space and 2,204 with space). This text is separated into 4
paragraphs.

Word wrap is activated.

The two last paragraphs do not fit in the cell. The last 5 words or so of
each line of these two paragraphs are exceeding the cell.

Try as I might, I cannot correct this unless I manually put in a couple of
Alt+Returns, which, to my knowledge, I shouldn't have to do since I did not
have to do it in the first two paragraphs.

Any idea why I have this problem? And I get this problem all the time.

Thanks!

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
Getting word wrap to work in a merged cell Dave Couch Excel Discussion (Misc queries) 1 October 31st 07 11:17 PM
Why won't my text fully display with word-wrap and merged cells? Will DeLoach Excel Discussion (Misc queries) 9 November 14th 06 04:52 PM
word wrap in non-merged cells Arun Excel Discussion (Misc queries) 2 October 20th 06 05:55 AM
Can word wrap and merged cells auto row height properly in Excel wchernock Excel Discussion (Misc queries) 1 May 30th 06 03:04 PM
Autofit with Merged Cells/Wrap Text Macro Problem elfmajesty Excel Discussion (Misc queries) 3 May 25th 06 06:32 PM


All times are GMT +1. The time now is 05:15 PM.

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"