Moving cursor down and to the left

**rgirardi** · 11-19-2011, 05:26 PM

Hi
I need to hit enter and have the cursor move down one cell and to the left one cell.

I have excel 2010

Thanks

**shg** · 11-19-2011, 05:34 PM

Not an option; it would require VBA.

Why do you want to do this?

**rgirardi** · 11-19-2011, 05:38 PM

Originally Posted by shg

Not an option; it would require VBA.

Why do you want to do this?

I am entering data into two col. I enter a number into A1 then B1 I want to hit enter and have the cursor to go to A2.

**shg** · 11-19-2011, 05:55 PM

Lock all the cells on the worksheet, unlock the cells in those two columns, then protect the worksheet, and you'll get that exact behavior.

**tom1977** · 11-19-2011, 05:57 PM

you can use such code

Please Login or Register  to view this content.

run sub start
if you want normal enter works run sub finish

Re: Moving cursor down and to the left