How do I change my return to the next row so not always right?

B

Benedict9

I simply want the old fashioned editing feature from Excel 2003 where you hit
return after tabbing over several rows you hit Return and it goes back to the
first column you were editing in.

Thanks
 
G

Gord Dibben

Make sure your ENTER key is set to move down after hitting.

Sounds like yours is set to move right.

You will find this in Options>Edit


Gord Dibben MS Excel MVP
 
B

Benedict9

Sorry, what I meant was that if you have 10 columns there is a way to type in
data in columns 3 through 6 for instance, and then you hit return and it
takes you back to the third column again.

Thanks
 
Top