shortcut
 

When you push the enter key, you move to the cell below. How do I program
the enter key, so when I push it, I move to a different cell of my choosing.
Thank you.
--
Robert Rogers

shortcut
 

You can configure Excel to move one cell in a direction of your choosing (or
not at all). Tools Options. Click on the Edit tab, check the 'Move
selection after Enter' box and use the drop-down to pick the direction.

"robert" wrote:

When you push the enter key, you move to the cell below. How do I program
the enter key, so when I push it, I move to a different cell of my choosing.
Thank you.
--
Robert Rogers

shortcut
 

The only choices are Down, Right,Up and Left one cell at a time.

Or don't move at all.

If you wanted to move from say A1 to D2 and over to F3 you must use another
method.

See Bob Phillips' site for methods.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is another method using VBA with worksheet event code.

Post back if you want to try that.


Gord Dibben Excel MVP

On Wed, 30 Nov 2005 16:46:03 -0800, robert
wrote:

When you push the enter key, you move to the cell below. How do I program
the enter key, so when I push it, I move to a different cell of my choosing.
Thank you.