You could consider using VBA, more specifically, a SelectionChange Event.
That traps where the cursor is going.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"bluesun" wrote:

Hi Hilberg, thanks for your feedback. Can the "wrap" be set like a rule, so
that it could not be disturbed by mouse click or function key.

"D Hilberg" wrote:

Select the data-entry rectangle of interest. Use the tab key to enter
values. The cursor will "wrap" within the highlighted area.

You can also set the cursor to move to the right after hitting enter,
if it currently moves downward.

On Jul 10, 10:58 pm, bluesun
wrote:
Suppose I have a worksheet with 5 columns by 3 rows ( The number of rows and
columns to use). Can the cursor be configured to move to the next row
automatically once the last row of the immediate column has an entered value?