A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Selection after enter



 
 
Thread Tools Display Modes
  #1  
Old April 30th, 2010, 06:43 AM posted to microsoft.public.excel.newusers
Jeanette Caldwell
external usenet poster
 
Posts: 1
Default Selection after enter

After entering data into the active cell, pressing the tab key moves the
selection to the right, but pressing the enter key does not move the
selection at all. It stays at the cell where the data was just entered. Why?
  #2  
Old April 30th, 2010, 06:53 AM posted to microsoft.public.excel.newusers
JLatham
external usenet poster
 
Posts: 1,896
Default Selection after enter

The direction to move is probably not selected:
Excel 2003 & earlier:
Tools -- Options -- [Edit] tab, Check the box next to "Move selection
after Enter" and pick a direction (Down, Right, Left, Up -- your preference).

2007:
Office Button -- [Excel Options] button --Advanced group and check "After
pressing Enter, move selection" and choose the direction.

2010:
File -- Options -- Advanced and check "After pressing Enter, move
selection" and choose the direction.


"Jeanette Caldwell" wrote:

After entering data into the active cell, pressing the tab key moves the
selection to the right, but pressing the enter key does not move the
selection at all. It stays at the cell where the data was just entered. Why?

  #3  
Old April 30th, 2010, 07:02 AM posted to microsoft.public.excel.newusers
Jeanette Caldwell[_2_]
external usenet poster
 
Posts: 1
Default Selection after enter

That was indeed the problem. Thanks so much for the help.

"JLatham" wrote:

The direction to move is probably not selected:
Excel 2003 & earlier:
Tools -- Options -- [Edit] tab, Check the box next to "Move selection
after Enter" and pick a direction (Down, Right, Left, Up -- your preference).

2007:
Office Button -- [Excel Options] button --Advanced group and check "After
pressing Enter, move selection" and choose the direction.

2010:
File -- Options -- Advanced and check "After pressing Enter, move
selection" and choose the direction.


"Jeanette Caldwell" wrote:

After entering data into the active cell, pressing the tab key moves the
selection to the right, but pressing the enter key does not move the
selection at all. It stays at the cell where the data was just entered. Why?

  #4  
Old April 30th, 2010, 02:05 PM posted to microsoft.public.excel.newusers
Bernard Liengme
external usenet poster
 
Posts: 516
Default Selection after enter

There is an option to tell Excel which way to go when the Enter key is
pressed.
What version of Excel are you using? Access to Options changed when XL2007
was introduced.
Also check that do not have Transitions set (this makes Excel behave like
Louts123) - again this is is in the Options dialog.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Jeanette Caldwell" Jeanette wrote in
message ...
After entering data into the active cell, pressing the tab key moves the
selection to the right, but pressing the enter key does not move the
selection at all. It stays at the cell where the data was just entered.
Why?


  #5  
Old April 30th, 2010, 03:43 PM posted to microsoft.public.excel.newusers
JLatham
external usenet poster
 
Posts: 1,896
Default Selection after enter

And yet another slight change in the way you get to Options in 2010, although
this time it's an improvement (when compared to 2007).
I hadn't thought about the Transitions setting, so I got lucky because if
the "Action after Enter..." hadn't done it, it would have become a stumper
for me!

"Bernard Liengme" wrote:

There is an option to tell Excel which way to go when the Enter key is
pressed.
What version of Excel are you using? Access to Options changed when XL2007
was introduced.
Also check that do not have Transitions set (this makes Excel behave like
Louts123) - again this is is in the Options dialog.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Jeanette Caldwell" Jeanette wrote in
message ...
After entering data into the active cell, pressing the tab key moves the
selection to the right, but pressing the enter key does not move the
selection at all. It stays at the cell where the data was just entered.
Why?


.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.