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????

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????

Thank you, but we're on a Mac and still unchecked that box and pressed OK,
but it still doesn't work. Any other suggestions??

"bpeltzer" wrote:

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????

Hi

Hold down ALT, then press enter.

Colin


--
Colin Vicary
------------------------------------------------------------------------
Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472
View this thread: http://www.excelforum.com/showthread...hreadid=535029

This is what works on a PC: Alt+Enter


"Kati eM." wrote:

Thank you, but we're on a Mac and still unchecked that box and pressed OK,
but it still doesn't work. Any other suggestions??

"bpeltzer" wrote:

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????

Try Alt-Enter

HTH,
Elkar


"Kati eM." wrote:

Thank you, but we're on a Mac and still unchecked that box and pressed OK,
but it still doesn't work. Any other suggestions??

"bpeltzer" wrote:

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????

Click "Format Cells" then Alignment and select wrap text. This will put your
text on another line in the same cell according to the width. This will
allow you to type a name, address, state and zip in the line you want. If
something is short and you want to go to the next line you can [space] until
you are on the next line.

Hope this helps! :)

"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????

Thanks everyone,

Apparently, pressing Open Apple + Alt + Enter works. Thanks for the hints!


"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????