| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop spilling the text to the adjoining cell | Excel Discussion (Misc queries) | |||
| how to see the whole text in merged cells? | New Users to Excel | |||
| text spilling over text and colums | Excel Discussion (Misc queries) | |||
| merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
| retrieve text from merged cells | Excel Worksheet Functions | |||
Linear Mode
