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

L

lksmith

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
 
B

Bryan Hessey

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

Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Merging from an Excel file with graphics 1
hit enter in any column and go to next row in first column 3
How do I unhide a row when ENTER is pressed in a certain cell? 6
data spans multiple rows within each cell is collapsed when FILTER is used 0
Automatic cell selection 12
Margin from bottom edge of a page to the last line of the last paragraph 1
Tabs and returns 2

Top