J:

I suspect that you have created a form with several cells unlocked and that
you have protected the sheet.

It is my understanding that the TAB order in Excel cannot be altered.
However, the cursor will automatically advance from cell to cell when the
user presses ENTER. The ENTER order can be altered from the menu by
selecting Tools, Options, Edit, Move selection after Enter, DOWN. This is
the default setting in Excel, so the cursor should move exactly as you
desire from the outset.

If you are entering data in an unprotected sheet, just highlight the range
into which you want to enter data, and then press ENTER as you fill in each
of the cells. The cursor will advance from cell to cell after pressing
ENTER. The range(s) need not be contiguous cells for this approach to work.
The direction of the cursor will depend on the aforementioned setting in the
Tools, Options dialog box.

HTH,

=Mac=

L. A. McClelland



"jhells" wrote in message
...
I have three colums. I need the tab order to go down colum one, three
rows.
Then wrap up the three rows in colum two, and then back down three rows
again
(in colum two). Same thing in colum three. I have done programming in
Access, but I'm really stumped on how to do this in Excel!?!?! Please
help
me if you can. Thanks