Making a cell self contained.
 

I am making a label template in excel. When I enter data I cannot hit return
between address lines, because of course it then moves to the next cell. Is
there a way to hit return and get to the next line in that cell, then move to
the next cell when

Use ALT+ENTER to insert a new line in an Excel cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"dogangel" wrote in message
...
I am making a label template in excel. When I enter data I
cannot hit return
between address lines, because of course it then moves to the
next cell. Is
there a way to hit return and get to the next line in that
cell, then move to
the next cell when

Hi
ALT+ENTER

--
Regards
Frank Kabel
Frankfurt, Germany
"dogangel" schrieb im Newsbeitrag
...
I am making a label template in excel. When I enter data I cannot hit
return
between address lines, because of course it then moves to the next cell.
Is
there a way to hit return and get to the next line in that cell, then move
to
the next cell when