General discussion

Locked

Truncated text in Excel

By kasey.levine ·
I can't the text in my cell to show up after typing a lot of text. I have the Column formatted to wrap text. At a certain point the text at the bottom of the cell is being hidden. I have selected the cell and went to format, row, autofit - nothing, I have adjusted the height manually-nothing. The text is there, because when I click in the cell it is all in the formula bar. I am finding one solution is to click somewhere in the text and hit ALT+Enter and then adjust the cell height. This iscrazy. Any suggestions?

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Truncated text in Excel

by jhickman In reply to Truncated text in Excel

The solution is two part (and the first you've already stumbled on). Cell size (height) can be a factor. The other thing I've used is to adjust the font size in a particular cell to a smaller size. In my experience, the font resizing has more impact than the cell resizing.

Collapse -

Truncated text in Excel

by kasey.levine In reply to Truncated text in Excel
Collapse -

Truncated text in Excel

by brookslewis In reply to Truncated text in Excel

I too have had this problem. I solved it the easy way. I used Edit-Clear-All and retyped the info. However, I am looking forward to learning the correct solution.

Collapse -

Truncated text in Excel

by kasey.levine In reply to Truncated text in Excel
Back to IT Employment Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums