Just one cell in an Excel column won't text wrap.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kathleen - 21 Jan 2006 20:01 GMT

I'm using Excel for text entries. I selected one column, and formatted the
cell alignment to wrap text. This has been working just fine until the last
3 entries, which have reverted to hidden text. (I can see that the text is
there, but only a portion is showing.)

When I check the individual cells, they show the formatting to be for
wrapped text.

I've tried undoing the formatting for the entire column, and starting over
again. The cells that were wrapped revert to their wrapped state, and these
"unwrapped" cells go back to being unwrapped again as well.

I'm a beginner with Excel. Any ideas on an end-run or actual fix on this?
Thanks!

Reply to this Message

David McRitchie - 21 Jan 2006 20:28 GMT

Hi Kathleen,

Try changing the height of the row, sounds like the text is wrapped but
is below what you see.

Note: when you change the height of a row, then that height will stick
and Excel will not bother attempting to change the row height because
you specifically chose a row height.
http://www.mvps.org/dmcritchie/excel/fillhand.htm#autofit

Text that is not wrapped extends to the cell(s) to the right, and is stopped
by any content in the adjacent cell including a formula, space, or null string.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> I'm using Excel for text entries. I selected one column, and formatted the
> cell alignment to wrap text. This has been working just fine until the last
[quoted text clipped - 10 lines]
> I'm a beginner with Excel. Any ideas on an end-run or actual fix on this?
> Thanks!

Reply to this Message