Full cell not printing
 

I have a cell with 1370 characters. It shows all the text in the formula
bar, but when I print preview or print, only the first 1060 (I think)
characters are shown.

Is this a known limitation, and is there any way around it?

Thanks in advance
Daniel

Hi Daniel,

The Excel help somewhere states a maximum of 32,767 characters per
cell but only 1,024 'visible'.

Solution perhaps: split your story over multiple cells by using Left, Mid
and
Right functions.

Frans


"Daniel Bonallack" wrote in
message ...
I have a cell with 1370 characters. It shows all the text in the formula
bar, but when I print preview or print, only the first 1060 (I think)
characters are shown.

Is this a known limitation, and is there any way around it?

Thanks in advance
Daniel

Excel only puts about 1000 characters on one line. Use ALT + Enter to
create line breaks as you type and make sure the cell is formatted to
allow multiple lines.

Bill

"Daniel Bonallack" wrote in
message ...
I have a cell with 1370 characters. It shows all the text in the
formula
bar, but when I print preview or print, only the first 1060 (I think)
characters are shown.

Is this a known limitation, and is there any way around it?

Thanks in advance
Daniel