Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Issues with Word Wrapping in cells after a number of characters
I am using Excel 2000. I have word wrapping turned on in Excel for a cell
and after reaching a certain amount of characters, word wrapping stops working. Does anyone know of a fix for this? Thanks, Jig. |
#2
|
|||
|
|||
What is the number of characters? Look in help for specifications, excel can
only display about 1024 characters in a cell Regards, Peo Sjoblom "Jig Bhakta" wrote: I am using Excel 2000. I have word wrapping turned on in Excel for a cell and after reaching a certain amount of characters, word wrapping stops working. Does anyone know of a fix for this? Thanks, Jig. |
#3
|
|||
|
|||
It seems that at around 1077 characters (could be less), Excel wont wrap the
text...is there any fix to this? New version of Excel? "Peo Sjoblom" wrote: What is the number of characters? Look in help for specifications, excel can only display about 1024 characters in a cell Regards, Peo Sjoblom "Jig Bhakta" wrote: I am using Excel 2000. I have word wrapping turned on in Excel for a cell and after reaching a certain amount of characters, word wrapping stops working. Does anyone know of a fix for this? Thanks, Jig. |
#4
|
|||
|
|||
That 1024 limit can be extended by adding alt-enters (to force a new line in the
cell) every 80-100 characters. And it usually fixes the problem that the text just seems to disappear.... (But you may have to adjust the rowheight manually.) Jig Bhakta wrote: It seems that at around 1077 characters (could be less), Excel wont wrap the text...is there any fix to this? New version of Excel? "Peo Sjoblom" wrote: What is the number of characters? Look in help for specifications, excel can only display about 1024 characters in a cell Regards, Peo Sjoblom "Jig Bhakta" wrote: I am using Excel 2000. I have word wrapping turned on in Excel for a cell and after reaching a certain amount of characters, word wrapping stops working. Does anyone know of a fix for this? Thanks, Jig. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how 2 Count number of cells that have specific condition format? | Excel Worksheet Functions | |||
Return number of cells filled | New Users to Excel | |||
Counting the number cells between two dates | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
only include cells beginning with specified character or number | Excel Worksheet Functions |