S
SeeFar
Worksheet is cutting off portion of wrapped text, even when I use autofit. I
can manually expand each row, but should I have to?
can manually expand each row, but should I have to?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
drhayes
I am looking for a solution to this problem also. I am entering long
text entries in a large cell with wrapping turned on. After X
charachters, the wrapping stops in the display and enlarging the cell
height does nothing to help the situation. I can enter hard line feeds
(alt+enter) at the end of each line, but that is a pain.
Any solutions or suggestions? The only other way around this is to use
a text box, but then again that is a pain.
text entries in a large cell with wrapping turned on. After X
charachters, the wrapping stops in the display and enlarging the cell
height does nothing to help the situation. I can enter hard line feeds
(alt+enter) at the end of each line, but that is a pain.
Any solutions or suggestions? The only other way around this is to use
a text box, but then again that is a pain.
F
Frank Kabel
Hi
do you use merged cells?
do you use merged cells?
G
Gord Dibben
Excel Help on "limits" or "specifications" reveals that Excel will allow
32,767 characters to be entered in a cell.
However, it goes on to state that "only 1024 characters will be visible or can
be printed"
To work around this limitation, stick a few ALT + ENTERs in at appropriate
spots.
The ALT + ENTER forces a line-feed and expands the 1024 limit.
How far is not really known. Just experiment.
.........From Dave Peterson..........
I put this formula in A1:
="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy"
And adjusted the columnwidth, rowheight and font size and I got about 7300
characters to print ok.
.........End Dave P.................
Failing that, use a Text Box to store the text.
Gord Dibben Excel MVP
32,767 characters to be entered in a cell.
However, it goes on to state that "only 1024 characters will be visible or can
be printed"
To work around this limitation, stick a few ALT + ENTERs in at appropriate
spots.
The ALT + ENTER forces a line-feed and expands the 1024 limit.
How far is not really known. Just experiment.
.........From Dave Peterson..........
I put this formula in A1:
="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy"
And adjusted the columnwidth, rowheight and font size and I got about 7300
characters to print ok.
.........End Dave P.................
Failing that, use a Text Box to store the text.
Gord Dibben Excel MVP