Pressing enter in merged cell

[beastiebill]

I have one large (merged) cell that is actually 11x15 cells. I would like to use this area like a word processor. (It's intended for an area on the form for people to decribe problems.) I have "Wrap Text' enabled on this cell, but I would like to be able to hit Enter to advance to a new line within this cell rather than advancing to the next row. Any suggestions?

 

[Zack Barresse]

Hi,

Keep the merged cells specific to their own row. Meaning only merge cells across a single row. Then drag down the merged cell 10 more rows. Then enter will perform a return and you will still be in the merged cells area. Format a box around the merged cells so it is more easily defined.

Also Alt + Enter will give you a return inside of a cell.

Those would be the two options I see right off hand. HTH

 

[beastiebill]

Thank You!