Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

hard returns within cells

Posted by Roni on October 03, 2001 9:30 AM
This might be pretty basic, but I can't remember...

I'm typing WORDS into a cell and need to insert a
hard return to start a new line in same cell. However,
whenever I hit ENTER, my cursor moves to next cell.

How do I start a new line within the same cell???

Thank you.


Re: hard returns within cells

Posted by Roni on October 03, 2001 9:34 AM

Ok, I figured it out... ALT ENTER.


Re: hard returns within cells

Posted by Juan Pablo on October 03, 2001 9:34 AM
Instead of just ENTER press ALT ENTER, that puts a new line in the cell

Juan Pablo


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.