Text in Cell Issue

[TypoAvoider]

I hope someone can help, i have an issue that i cant seem to find on Google and is hard to explain. But here goes.

I am preparing an investor report which has multiple pages. On many of these pages a large number of the cells have been merged to fit long paragraphs of text in them. However, when you double click into the cell to edit the paragraph the text seems to change so that the line ending are different (ie more text seems to fit in the cell), and when you select out of the cell it returns back to the way it was.

Basically more text fits in the cell on double clicking. And also when i PDF the spreadsheet it appears as if the cell has been double clicked into (showing more text).

It's almost as if there is some kind of padding that only activates when you are not in that cell, and disappears when you double click into the cell.

Any ideas?

Thanks for your help.

 

[mrshl9898]

Excel only displays 1024 characters in a cell.

Character Limits for Cells (Microsoft Excel)

Excel places limits on how much information you can enter into a cell and how much of that information it will display. This tip explains those limits, how you can work around them, and why upgrading your version of Excel may be beneficial. (Tips.Net)

excel.tips.net

 

[TypoAvoider]

Thanks for your reply. I don't think that is correct as I have over 2,500 characters in that cell.