Greg

Make sure your ToolsOptionsEdit "move selection after enter" is set for
"down".

Assume you start in A1.

Tab your way across to column J.

When leaving column J hit the ENTER key to go back to A2.


Gord Dibben MS Excel MVP



On Sun, 18 Mar 2007 04:00:03 -0700, Greg wrote:

lets say I have 10 colums in a worksheet, when in colum 10 of row, i want to
automatically go to colum 1 of row 2