Enter the cell value without leaving the cell

[Chris Hedlund]

Is there a way to use the keyboard to enter a cell value without exiting the
cell when you press the ENTER key? I use the mouse to click the green check
mark in the formula bar, but I would prefer to use the keyboard to
accomplish the same task.

Thanks,

 

[Chris Hedlund]

CRTL - ENTER

thanks

 

[Dave Peterson]

Maybe just turning off:

tools|options|Edit tab
Uncheck Move selection after enter

would make it work the way you want.

 

[Chris Hedlund]

cool - I didn't know that was there - thanks!

Maybe just turning off:

tools|options|Edit tab
Uncheck Move selection after enter

would make it work the way you want.

 

[R.VENKATARAMAN]

if you hit control+enter then also it will not move.

cool - I didn't know that was there - thanks!