Carriage return after last column

After filling in a row of information, is there a way to tell Excel to drop
down a line and go back to the first column without hitting the back arrow
numerous times?

If you use the tab key to move to the right in the row you are working in it
will return one row below in the first column you started working, another
way would be to use data>form in which you will work in a form but the cells
will be filled the same way as if you were working directly in the cells


--

Regards,

Peo Sjoblom



"Steve" <Steve@discussions.microsoft.com> wrote in message
news:E120E574-6F1E-4431-8598-8CFDA03AD2AA@microsoft.com...
> After filling in a row of information, is there a way to tell Excel to
drop
> down a line and go back to the first column without hitting the back arrow
> numerous times?

If you move "right" after data entry by using the <Tab> key every time, AND
then hit <Enter> after the last entry,
XL will *automatically* move the focus to the cell directly under the cell
that you started using the <Tab> key on.

--
HTH,

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


"Steve" <Steve@discussions.microsoft.com> wrote in message
news:E120E574-6F1E-4431-8598-8CFDA03AD2AA@microsoft.com...
> After filling in a row of information, is there a way to tell Excel to
drop
> down a line and go back to the first column without hitting the back arrow
> numerous times?

You can also unprotect the the cells that you want to work in, then protect
the sheet. The right arrow after every entry will carry you across and back
to the next line again. Enter will take you down one column, then the next.

"RagDyer" wrote:

> If you move "right" after data entry by using the <Tab> key every time, AND
> then hit <Enter> after the last entry,
> XL will *automatically* move the focus to the cell directly under the cell
> that you started using the <Tab> key on.
>
> --
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Steve" <Steve@discussions.microsoft.com> wrote in message
> news:E120E574-6F1E-4431-8598-8CFDA03AD2AA@microsoft.com...
> > After filling in a row of information, is there a way to tell Excel to
> drop
> > down a line and go back to the first column without hitting the back arrow
> > numerous times?
>
>