Simple Excel question!

dugweb

Diamond Member
Oct 17, 2002
3,935
1
81
In a cell I when I hit return I want to go to the next line, but not to the next cell. I would also like the text to wrap instead of just type into the next cell. There has to be an easy explanation for this. Please help!
 

NeoV

Diamond Member
Apr 18, 2000
9,504
2
81
ok, easy

you can't go to the next 'line' and still be in the same cell unless you are entering in a text box.

You can change the cell you move to after hitting enter in options-edit, the 'move selection after enter' part.

For the text wrap, go to format-cell ( or control-1), and hit the alignment button...wrap text is an option at the bottom