text wrap

[TimBCC]

Is it possible to wrap text to the next cell down?

 

[Shane Devenshire]

Hi,

Yes, but you need to merge the two cells. Suppose your text is in A1 and
you want it the wrap to A2

Select A1:A2 and choose Merge & Center. Then choose Format, Cells,
Alignment, and check Wrap Text. Change the center to left if you want.

 

[Gord Dibben]

Sure.

Stop typing at some point.............hit ENTER key then type some more in
next cell.

Seriously, Excel won't know when you have finished typing until you exit the
cell in some manner........Enter........Tab.........Arrow out.

You could get it done using event code but not without VBA


Gord Dibben MS Excel MVP

 

[TimBCC]

Thanks for the responses. What I have is a "form" written in Excel. It was
originally made to print and fill out. I'm trying to tweak it so that you
can just type in the lines on the computer (things like making check boxes
actually check when you click them). I have it all figured out except for
our 'Remarks' section on the "form". This section has six lines to it. Each
line is a page in width (merged cells) and "underlined" by use of a border
line. I was just trying to find an easy way to bump down to the next line
while typing without having to hit enter, or merge columns, or creating a
text box. Is this possible? Thanks for the help.

 

[Gord Dibben]

I was just trying to find an easy way to bump down to the next line

while typing without having to hit enter, or merge columns, or creating a
text box. Is this possible? Thanks for the help.

Same response as my first reply.

You must let Excel know you have finished entering data in that cell.


Gord

 

[TimBCC]

Thanks for the replies guys. I was just trying to take the easy/lazy way out
by removing a step (hitting enter, down arrow, etc) to get to the next cell
down while typing. I guess it can't be done. Again, thanks for the replies.

Tim