ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I turn on "pressing enter goes to the next cell" option? (https://www.excelbanter.com/excel-discussion-misc-queries/61208-how-do-i-turn-pressing-enter-goes-next-cell-option.html)

Hollywood

How do I turn on "pressing enter goes to the next cell" option?
 
This is going to sound terribly dumb, but I used to be able to press the
"enter" key and the next cell in the column would become the active one.
Randomly however this ceased to happen. Can anyone please advise as to how I
can re-activate this option?

RagDyeR

How do I turn on "pressing enter goes to the next cell" option?
 
<Tools <Options <Edit tab,

Check "Move Selection After Enter",
And choose direction.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Hollywood" wrote in message
...
This is going to sound terribly dumb, but I used to be able to press the
"enter" key and the next cell in the column would become the active one.
Randomly however this ceased to happen. Can anyone please advise as to how
I
can re-activate this option?



DNA

How do I turn on
 
Tools Options Edit

Check the section "Move Selection After Enter Direction"

HTH


Marvin P. Winterbottom

How do I turn on "pressing enter goes to the next cell" option?
 
tools/options/edit/move selection after enter

"Hollywood" wrote:

This is going to sound terribly dumb, but I used to be able to press the
"enter" key and the next cell in the column would become the active one.
Randomly however this ceased to happen. Can anyone please advise as to how I
can re-activate this option?


David Billigmeier

How do I turn on "pressing enter goes to the next cell" option?
 
Go into Tools-Options-'Edit' Tab-Make sure "Move selection after Enter" is
selected

--
Regards,
Dave


"Hollywood" wrote:

This is going to sound terribly dumb, but I used to be able to press the
"enter" key and the next cell in the column would become the active one.
Randomly however this ceased to happen. Can anyone please advise as to how I
can re-activate this option?


bpeltzer

How do I turn on "pressing enter goes to the next cell" option?
 
From the menu bar, Tools Options, click the Edit tab and check the 'Move
selection after enter' box, then use the drop-down to choose which direction
to move.
--Bruce

"Hollywood" wrote:

This is going to sound terribly dumb, but I used to be able to press the
"enter" key and the next cell in the column would become the active one.
Randomly however this ceased to happen. Can anyone please advise as to how I
can re-activate this option?


Hollywood

How do I turn on "pressing enter goes to the next cell" option?
 
Thanks to all who wrote in the response! =)

"Hollywood" wrote:

This is going to sound terribly dumb, but I used to be able to press the
"enter" key and the next cell in the column would become the active one.
Randomly however this ceased to happen. Can anyone please advise as to how I
can re-activate this option?



All times are GMT +1. The time now is 05:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com