ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Just one cell in an Excel column won't text wrap. (https://www.excelbanter.com/new-users-excel/66625-just-one-cell-excel-column-wont-text-wrap.html)

Kathleen

Just one cell in an Excel column won't text wrap.
 
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!

David McRitchie

Just one cell in an Excel column won't text wrap.
 
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...nd.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

"Kathleen" wrote in message ...
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!





All times are GMT +1. The time now is 03:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com