|
| 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
March 10th, 2010, 07:23 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wrap text in cell
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
March 12th, 2010, 07:19 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Wrap text in cell
You can enter 32767 characters in a cell.
In Excel 2003 and earlier, only 1024 of these will be visible or printed. I believe Excel 2007 will show 8192 characters. If you add an Alt + Enter linefeed every 100 or so characters you can increase this 1024 limit. Gord Dibben MS Excel MVP On Wed, 10 Mar 2010 11:23:03 -0800, 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
