If you select your range first (say A2:E99) and have
Tools|Options|Edit|Move Selection after Enter set to go to the right

it may work nicely for you.

(I like to use the tab key and I can keep my MSAE the way I normally like--off.)

alphadog47 wrote:

Hi,
New to using Excel version 2000, have setup a form and after entering data
in the frist row I want to do a hard carriage return in the last data column
to go down to the next row and to the left.

I hope I made that clear.

falcon

--

Dave Peterson