On the menu bar, select Tools, then Options. Click on the Edit tab. There's
a checkbox labeled 'Move selection after Enter'. Clear that checkbox and
click OK.

"Kati eM." wrote:

How do you stay in the same cell and get to the next line? When I press
enter, it jumps to the next cell. I'd like to stay in the cell for an
address format,... any suggestions????