If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Why does my text in a cell with wrap text and auto height get cut
It seems that wrap text and autofit row width and row height have a limit.
Any idea where to change this limit? I have quite a large text in a cell and when I do wrap text and autofit, then parts of the text get cut of. The text is still there, but it is not shown in the cell and it is cut off when printing. |
#2
|
|||
|
|||
Why does my text in a cell with wrap text and auto height getcut
HerbertB wrote:
It seems that wrap text and autofit row width and row height have a limit. Any idea where to change this limit? I have quite a large text in a cell and when I do wrap text and autofit, then parts of the text get cut of. The text is still there, but it is not shown in the cell and it is cut off when printing. From he http://office.microsoft.com/en-us/ex...992911033.aspx I found this: Length of cell contents (text): 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. Does this explain your problem? |
#3
|
|||
|
|||
Why does my text in a cell with wrap text and auto height get
Yes, this explains it, but it doesn't solve my issue.
Any way around it? "Glenn" wrote: HerbertB wrote: It seems that wrap text and autofit row width and row height have a limit. Any idea where to change this limit? I have quite a large text in a cell and when I do wrap text and autofit, then parts of the text get cut of. The text is still there, but it is not shown in the cell and it is cut off when printing. From he http://office.microsoft.com/en-us/ex...992911033.aspx I found this: Length of cell contents (text): 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. Does this explain your problem? . |
#4
|
|||
|
|||
Why does my text in a cell with wrap text and auto height get
Well, two ideas come to mind:
Break up your text into multiple cells with no more than 1,024 characters each. Use Word for the text. Then insert the document into your worksheet as an object. HerbertB wrote: Yes, this explains it, but it doesn't solve my issue. Any way around it? "Glenn" wrote: HerbertB wrote: It seems that wrap text and autofit row width and row height have a limit. Any idea where to change this limit? I have quite a large text in a cell and when I do wrap text and autofit, then parts of the text get cut of. The text is still there, but it is not shown in the cell and it is cut off when printing. From he http://office.microsoft.com/en-us/ex...992911033.aspx I found this: Length of cell contents (text): 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. Does this explain your problem? . |
#5
|
|||
|
|||
Why does my text in a cell with wrap text and auto height get
Add an Alt + Enter linefeed every 100 or so characters.
Gord Dibben MS Excel MVP On Thu, 11 Mar 2010 06:50:10 -0800, HerbertB wrote: Yes, this explains it, but it doesn't solve my issue. Any way around it? "Glenn" wrote: HerbertB wrote: It seems that wrap text and autofit row width and row height have a limit. Any idea where to change this limit? I have quite a large text in a cell and when I do wrap text and autofit, then parts of the text get cut of. The text is still there, but it is not shown in the cell and it is cut off when printing. From he http://office.microsoft.com/en-us/ex...992911033.aspx I found this: Length of cell contents (text): 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. Does this explain your problem? . |
Thread Tools | |
Display Modes | |
|
|