P priya Mar 9, 2004 #1 if we enter more than 255 characters in the cell, all the characters r not seen even though the cell is wrapped
if we enter more than 255 characters in the cell, all the characters r not seen even though the cell is wrapped
P priya Mar 9, 2004 #3 Frank said: *Hi you have to manually enter some linebreaks (with ALT+ENTER) Click to expand... but still the cell width and height is not se
Frank said: *Hi you have to manually enter some linebreaks (with ALT+ENTER) Click to expand... but still the cell width and height is not se
D Dave Peterson Mar 9, 2004 #4 How many characters are there? For just a little over 255, you should be able to see them. Make sure you autofit the rowheight. (If you've ever manually set that row's height, then excel won't make it bigger automatically until you autofit it.) If your cell is merged, then the autofit won't work at all. You have to manually adjust it or use a macro. And if you'd like that macro solution: Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like: http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05 If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm === If you get over 1000, then the alt-enters work ok for me to see more characters.
How many characters are there? For just a little over 255, you should be able to see them. Make sure you autofit the rowheight. (If you've ever manually set that row's height, then excel won't make it bigger automatically until you autofit it.) If your cell is merged, then the autofit won't work at all. You have to manually adjust it or use a macro. And if you'd like that macro solution: Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like: http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05 If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm === If you get over 1000, then the alt-enters work ok for me to see more characters.
