I am entering row after row of data. When I hit the Enter key, how do I get
the cursor to return to the beginning of the next row?

Tools, Options, Edit, Move selection after Enter, Down

Baldrick wrote:

I am entering row after row of data. When I hit the Enter key, how do I get
the cursor to return to the beginning of the next row?

In addition to Bob I's reply, you can also select the rows and columns you're
entering data into, starting at the first cell and selecting down to the last
cell.

Typing and pressing enter moves the cell pointer one cell left to right
until the last column has been encountered, at that point it moves to the
first cell on the next row. Upon reaching the last selected cell, pressing
enter moves you to the start of the selected range.

Use <Shift + Enter to move from right to left
--
Kevin Backmann


"Baldrick" wrote:

I am entering row after row of data. When I hit the Enter key, how do I get
the cursor to return to the beginning of the next row?

Baldrick,

Make sure to follow Bob I's advice, but also, this behavior only works when
you move from cell to cell in the same row with the [Tab] key.

If you enter data in a cell, move to the next cell with the right arrow key,
then enter data, when you hit the enter key, the cell directly below the
current cell will become active.

This can also cause problems when you make a mistake and need to back up a
cell or 2 to make corrections. If you back up using the left arrow key, the
left-most column you backed up to will become the "home" column. When you
hit the enter key at the end of this row, the cell in the next row down in
that "home" column you backed up to will become active.

If I remember correctly, you can use [Shift] + [Tab] to back up and make
corrections to keep the desired behavior in tact.

HTH,

Conan




"Baldrick" wrote in message
...
I am entering row after row of data. When I hit the Enter key, how do I
get
the cursor to return to the beginning of the next row?

Start in A1, type in your data then Tab to B1 to C1 to D1 filling data as you
go.

When leaving D1 hit the ENTER key to go to A2.

The rule is.........you will go back to the column from which you started and
one row down.


Gord Dibben MS Excel MVP

On Wed, 27 Feb 2008 13:25:01 -0800, Baldrick
wrote:

I am entering row after row of data. When I hit the Enter key, how do I get
the cursor to return to the beginning of the next row?

To move the cursor to the beginning of the next row after hitting Enter, you can simply press the Tab key. This will move the cursor to the first cell in the next row. Alternatively, you can use the arrow keys to move the cursor to the beginning of the next row.

If you want to change the default behavior of the Enter key in Excel, you can do so by going to File Options Advanced. Under the Editing options section, you will see a checkbox for "After pressing Enter, move selection". You can select the "Down" option to move the cursor to the beginning of the next row when you hit Enter.

1. Go to File tab
2. Click on Options
3. Click on Advanced
4. Under Editing options, select "After pressing Enter, move selection"
5. Select "Down" option