ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Text in merged cells is spilling over (https://www.excelbanter.com/excel-discussion-misc-queries/232738-text-merged-cells-spilling-over.html)

rrcd124

Text in merged cells is spilling over
 
I have 11 rows and 13 columns merged (and Wrapped Text).....the text entered
is 2683 characters long. THe text wraps fine until character 1242 then the
rest spills out to the right so it is not visible. If I go in and edit I can
see all the text....how can I get this to fit. I tried Alt Enter to move to
next line that did not work


Dave Peterson

Text in merged cells is spilling over
 
Did you try adding alt-enters every 80-100 characters?



rrcd124 wrote:

I have 11 rows and 13 columns merged (and Wrapped Text).....the text entered
is 2683 characters long. THe text wraps fine until character 1242 then the
rest spills out to the right so it is not visible. If I go in and edit I can
see all the text....how can I get this to fit. I tried Alt Enter to move to
next line that did not work


--

Dave Peterson

rrcd124

Text in merged cells is spilling over
 
Thanks.....that will work............ but is pain. Any other thoughts as to
why this is happening in the first place??

"Dave Peterson" wrote:

Did you try adding alt-enters every 80-100 characters?



rrcd124 wrote:

I have 11 rows and 13 columns merged (and Wrapped Text).....the text entered
is 2683 characters long. THe text wraps fine until character 1242 then the
rest spills out to the right so it is not visible. If I go in and edit I can
see all the text....how can I get this to fit. I tried Alt Enter to move to
next line that did not work


--

Dave Peterson


Dave Peterson

Text in merged cells is spilling over
 
It's a common long standing problem. I don't have any insight why that's so.

rrcd124 wrote:

Thanks.....that will work............ but is pain. Any other thoughts as to
why this is happening in the first place??

"Dave Peterson" wrote:

Did you try adding alt-enters every 80-100 characters?



rrcd124 wrote:

I have 11 rows and 13 columns merged (and Wrapped Text).....the text entered
is 2683 characters long. THe text wraps fine until character 1242 then the
rest spills out to the right so it is not visible. If I go in and edit I can
see all the text....how can I get this to fit. I tried Alt Enter to move to
next line that did not work


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 08:02 PM.

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