0

I have one excel sheet

Width of Column A is 70 and the word wrap property is ON.

And the content in the cell is of 287 words/1950 characters. Now when i try the row autofit function, its not working properly. Some of the content is still not visible. How to solve this issue.

Improve this question
1
  • Does it work with less (shorter) content ?
    – Ruskes
    Apr 26, 2013 at 8:41

2 Answers 2

Reset to default
2

The maximum row height is 409.

You are over that limit.

Pending the formatting of your text, including (CR) (LF) ect.

Improve this answer
0

You answered your own question, there is no autofit when you have word wrap on. If your text is too long then it just gets wrapped, there is nothing to fit!

If you are wondering where the rest of your text is gone then you probably need to increase your row height and you will see it.

Improve this answer
1
  • This doesn't explain how to make a cell display all text and changing its height accordingly. Typically that's what you want in a document and on the web even more.
    – MiB
    Sep 24, 2018 at 12:17

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .