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


"Chris Hedlund" <[email protected]> wrote in message
news:[email protected]...
> 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,
>

[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 wrote:
>
> 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,

--

Dave Peterson

[Chris Hedlund]

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


"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Maybe just turning off:
>
> tools|options|Edit tab
> Uncheck Move selection after enter
>
> would make it work the way you want.
>
> Chris Hedlund wrote:
>>
>> 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,
>
> --
>
> Dave Peterson

[R.VENKATARAMAN]

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

"Chris Hedlund" <[email protected]> wrote in message
news:[email protected]...
> cool - I didn't know that was there - thanks!
>
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > Maybe just turning off:
> >
> > tools|options|Edit tab
> > Uncheck Move selection after enter
> >
> > would make it work the way you want.
> >
> > Chris Hedlund wrote:
> >>
> >> 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,
> >
> > --
> >
> > Dave Peterson
>
>