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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|