HOw do I use enter to return to the first cell in the next row?

G

Guest

I'm entering data into columns, left to right. When finished with the cell in
the last column(H), how do I get to the first cell in the first column(A),
next row down? Just like entering text in Word and using the Enter key as a
carriage return to start the next line.
The only way it works now is to use the left arrow key. If I hit return I
simply drop down to the next lower cell in same columm.
 
P

Pete_UK

When you have moved down to the blank row below where you have just
entered data, press the <Home> key - this will take you to column A.

Hope this helps.

Pete
 
G

Guest

In Tools, Options, Edit is 'Move selection after Enter', direction can be
left, right, up or down, but this moves only to the adjacent cell.
To return to column A use CTRL and left arrow.
 
J

John James

If you have unlocked only your target cells and protect the worksheet
(with "select unlocked cells" only), then the cursors moves the way you
want it to.

There is also a way of achieving a similar result through setting up a
particular type of range name which selects cells in a user-specified
order, but this is more fiddly and less robust.
 

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

hit enter in any column and go to next row in first column 3
Hit Enter - cursor to beginning of next row? 4
"Enter" moves the screen, not to next cell(excel07) help! 1
in excel when i hit return, the cursor does not drop down 1 cell 2
Tabs and returns 2
go to fitst column of next row when enter (or other key) is presse 1
auto return to column A but of next row 1
"Move selection after Enter" 3

Top