• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Wrap text

J

jackmanjls

Member
I have a ss that has a series of a 2 row sequence. The top row has several column parameters while the row underneath has one long merged row where I type text. My question is about the second row. The second row is formatted to wrap text.


When I enter text beyond the second row I would expect the text to be wrapped and my text box would expand so that I could see the entire text entered. What I get is that the additional line is hidden and I have to go and make the row height larger.


Any ideas?
 
In short, it's because merged cells = major pain. I'd recommend selecting the cells the form the currently merged cell, then go to Format cells - Alignment. Uncheck the box for "merge cells" and instead change the Horizontal alignment dropdown to "Center across selection". This will give the same appearance, but will cause the row to increase in height automatically as you add text.
 
You must log in or register to reply here.
Back
Top