View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
KonaAl
 
Posts: n/a
Default How do you stay in cell and get to next line???

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