Is there a limit to text in a cell?

[excelclutz]

When I try to print out my Excel spreadsheet all the data in my cells do not show up in the print out. How do I resolve this issue? Is there a certain limit as to how much text can be put in a cell and still have it show up when printed out?

[shg]

A cell can store up to 32K characters, and will display about 1K; more if there are line feeds interspersed.

[excelclutz]

Thanks shg for the information on how much a cell can hold. The other problem I am having is that all the text in one cell does not print when I print out my spreadsheet. Is this normal for a cell to actually hold more text than what can be printed out? Or am I doing something wrong to keep the printer from printing out all the text in the cell?

[shg]

Is this normal for a cell to actually hold more text than what can be printed out?

That depends on the user, I reckon.

How much text is printing out?

How much text is in the cell?

[oldchippy]

Hi,

More info here

http://excel.tips.net/Pages/T003163_...for_Cells.html

[excelclutz]

Thanks oldchippy for the links, they answered my question.