Results when Enter Key is used

[Becky]

I need help in getting the cursor to move to the first
cell of the next row when I hit Enter Key to enter data.
Is there a way to do this? I can see in options that
will move the cursor to the left, right, down, up, but
nothing show it moving to the next row, first cell.

 

[Rob]

Tools... Options... Edit...

Make sure the check box next to move selection after
enter" is checked, then pick which direction you want it
to go after an enter.

 

[Charlie]

One way is to protect the worksheet. Unlock the cells
requiring data enter and then protect the worksheet. Now
the cursor will move between the unprotected cells and
skip the protected.

Charlie O'Neill

 

[RagDyer]

<<"getting the cursor to move to the first cell of the next row">>
Are you sure that you mean "row" and not "column"?

Does that mean that you're moving left to right in a single row, across
columns, and after, say starting in column A, and reaching column E, you
want to return to column A in the following row?
In that case, use <tab> to move right.
When you reach the desired column, hit <Enter>, and you'll return to where
you started, in the following row.
*Anywhere* (column) you *start* using <tab>, is where you'll return to when
you hit <Enter>.

If you mistakenly said "row", and you really mean "column", you can select
columns, and while they're still selected, enter your data, and the focus
will follow the selected cells.
For example, click in C5 and drag your selection to D15.
While the cells are *still* selected, hit <Enter> and *keep* it pressed.
See how the focus moves, but remains within the selection.
You could be entering data within the selection, and every <Enter> will move
you to the next cell in the selection.
Going a step farther, click in C5, hold down <Ctrl>, and then click in any
other *single*, random, five or ten cells.
Now, do the same thing and hold down <Enter>, and see that the focus will
follow the path that you mapped out, no matter what route you might have
randomly chosen.
You could even *save* this "random route" (which is really a range), by
naming it andcalling it up when needed.

This old post describes this procedure.

http://tinyurl.com/39vzv

If, after all this, you're talking about something else, post back with
specific cell and row directions that you're trying to access.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I need help in getting the cursor to move to the first
cell of the next row when I hit Enter Key to enter data.
Is there a way to do this? I can see in options that
will move the cursor to the left, right, down, up, but
nothing show it moving to the next row, first cell.

 

[Don Guillett]

Here is an automatic way to move down and back to the start. I use the right
arrow key starting at col B. After something is entered in col G I am
automatically sent back to col B but one row down.
Right click sheet tab> view code>copy paste this>modify to suit

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Row > 5 And Target.Column = 8 Then ActiveCell.Offset(1, -6).Select
End Sub

 

[Gord Dibben]

Becky

Assume starting in A1....

TAB to next cell which will be to the right.

Keep doing this until you get to last column you want data entered.

Now hit <ENTER> key.

You will be taken to A2.

The cursor goes goes back to whatever column you started from and down one
row.

Gord Dibben Excel MVP