How do you stay in cell and get to next line???

K

Kati eM.

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

bpeltzer

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.
 
K

Kati eM.

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

KonaAl

This is what works on a PC: Alt+Enter


Kati eM. said:
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??
Click to expand...
 
E

Elkar

Try Alt-Enter

HTH,
Elkar


Kati eM. said:
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??
Click to expand...
 
I

iamjbunni

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! :)
 
K

Kati eM.

Thanks everyone,

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