A couple of methods.

Start in A1 and Tab your way across to E1.

ENTER key out of E1 and go to A2.

Method 2.................

Select the cells and FormatCellsProtection

Unlock these cells then protect the worksheet with "select locked cells"
disabled.

You can move only across using the Tab key oir ENTER key if set to move right.

When you get to column E and hit Tab or ENTER you will go to A2.


Gord Dibben MS Excel MVP

On Tue, 10 Jul 2007 19:58:02 -0700, 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?