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 dataform 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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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?