| Home |
| Search |
| Today's Posts |
|
#1
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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get date/time to wrap (format - wrap text doesn't work)? | Excel Discussion (Misc queries) | |||
| Can not see text in Excel when cell format is set to wrap text | New Users to Excel | |||
| How do I view all text in a merged cell? Wrap text is activated. | Excel Discussion (Misc queries) | |||
| Why won't text in cell wrap. Cell format set to wrap. | Excel Discussion (Misc queries) | |||
| Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
Linear Mode
