Couple of ways to do this.

1. Unlock columns A:D then protect the sheet. The Tab key will then do as you
wish or the Enter key will work if set to move right after entry.

2. With no protection, start in column A and Tab your way across to D then hit
Enter key to go back to A one row down.


Gord Dibben MS Excel MVP

On Sat, 16 Jun 2007 07:51:00 -0700, Kitti
wrote:

Hi, I am hoping someone can tell me how I can get the cursor to move from
column D after entering data in that cell, and when I hit enter, the cursor
will automatically go to column A of the next line. My sheet is only using
columns A thru D, which is the way I want it, but when I hit return or enter,
I would like the cursor to go to the next line below to start data entry in
column A again.