shortcut

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
Back
Top