ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Text Cuts Off (https://www.excelbanter.com/excel-discussion-misc-queries/773-text-cuts-off.html)

Jeff

Text Cuts Off
 
When typing text in the cell, no matter whether I have "WRAP TEXT" on or not,
the text is cut off. I read an earlier posting response saying there is a
limit of 1024 characters and to use "ALT-ENTER" to get around this. It does
not work. Is there anything else I can do?

Thank you.

Richard Neville

Try using a text box from the Drawing toolbar. You can align the box with
the cell by holding down the Alt key while you move the borders.

"Jeff" wrote in message
...
When typing text in the cell, no matter whether I have "WRAP TEXT" on or
not,
the text is cut off. I read an earlier posting response saying there is a
limit of 1024 characters and to use "ALT-ENTER" to get around this. It
does
not work. Is there anything else I can do?

Thank you.




Dave Peterson

Maybe just increasing the row height will fix the problem.

Jeff wrote:

When typing text in the cell, no matter whether I have "WRAP TEXT" on or not,
the text is cut off. I read an earlier posting response saying there is a
limit of 1024 characters and to use "ALT-ENTER" to get around this. It does
not work. Is there anything else I can do?

Thank you.


--

Dave Peterson

David McRitchie

Once you manually change the row height then Excel expects
you to continue to adjust it to what you want. I expect that is
the cause of the problem. There is a macro by Jim Rech to
to autofit due to merged cells that may actually be your problem
and solution see
http://google.com/groups?threadm=uGM...40TK2MSFTNGP10
---
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

"Dave Peterson" wrote in message ...
Maybe just increasing the row height will fix the problem.

Jeff wrote:

When typing text in the cell, no matter whether I have "WRAP TEXT" on or not,
the text is cut off. I read an earlier posting response saying there is a
limit of 1024 characters and to use "ALT-ENTER" to get around this. It does
not work. Is there anything else I can do?

Thank you.


--

Dave Peterson





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

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