Hi ,
Can i use an auto text wrap on a number of cells, as there are lengthy of texts on each row.
I like the row expand as i enter/type the text.
Your help is appreciated. Thanks!
Hi ,
Can i use an auto text wrap on a number of cells, as there are lengthy of texts on each row.
I like the row expand as i enter/type the text.
Your help is appreciated. Thanks!
If you format the text with Wrap Text, it should do what you want.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I did that, however the row doesn't expand! I need to manually expand the row length to fit all text.
Some row does have one liner and some row has 5 liners. I am wondering is there anything dynamic which would allow this?
I was not able to replicate your situation When I typed in a long string of text into a pre-formatted word-wrap cell, the row height adjusted. When I typed the same thing into a general-format cell, and then word-wrapped it, it again auto-adjusted.
Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks