Displaying / printing large amounts of cell text

[lyano]

A cell that contains a large amount of text does sometimes not display or print the full contents even after I set row height to auto fit. I must manually increase the row size to show all the text. Any help is appreciated.

 

[vconfused]

How much text are we talking? There is a limit of about 1024 characters that will print, which includes spaces. If using spaces to get text to the next line, try using Alt+Enter instead.

From Excel Help:

Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

If this doesn't help, can you use the len() formula to determine the actual length in the cell?

 

[lyano]

The cells I have trouble with do contain more than 1024 characters. Is it true that Row / Autofit will not adjust the row height to display the total amount of text? Although making the column wider seems to help display more of the text. Is there a maximum row height within a column that I should be aware of when trying to fit more than 1024 characters of text? I found some additional related help that gave instructions to run a macro but I've never worked with macros before.

 

[vconfused]

I believe it is more trial and error. I wouldn't get any hopes up in trying to continuously display more than 1024 characters. Can you break the data up into multiple cells? Perhaps insert a Word object?

Going back to Excel Help:

Column width 255 characters
Row height 409 points