Donate SIGN UP

Excel cells

Avatar Image
dml54 | 16:27 Sun 31st Dec 2006 | Computers
5 Answers
Is there a limit to the amount of text I can enter in an Excel cell? The information I typed in is there, but doesn't show in the cell. Is there any way of adjusting it?
Gravatar

Answers

1 to 5 of 5rss feed

Best Answer

No best answer has yet been selected by dml54. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Question Author
Thanks for the link. Unfotunately it doesn't answer my question. I do know how to adjust rows.columns etc. I have since found out that there is an actual limit to the height of each cell so that once the text fills that cell more cannot be entered unless the width of the box is extended.
Go to FORMAT CELLS and tick the box that says text wrap
Question Author
Thanks Yvonne, that is already checked. There is a maximum height of 409 for any cell, so no more text will show in the cell once this maximum is reach - the cell has to be widened to get round the problem. And no doubt there will be a max width!
Could you add a Comment box attached to the cell or even a LINK to a word document

1 to 5 of 5rss feed

Do you know the answer?

Excel cells

Answer Question >>