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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In excel I want the return key to move down a row not over a col 3
How do I change my documet so the tab key will go to the next line 4
HOw do I use enter to return to the first cell in the next row? 5
Enter doesn’t return to the cell below the starting point anymore 3
How do I create a macro to duplicate the current row? 3
Find a cell and return value of cell next to it 2
How do I return to the start of the next row - EXCEL 2002? 2
in excel: how to change the return key to go to the right instead 1

Top