software

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 datagt;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
quot;Stevequot; gt; wrote in message
...
gt; After filling in a row of information, is there a way to tell Excel to
drop
gt; down a line and go back to the first column without hitting the back arrow
gt; numerous times?
If you move quot;rightquot; after data entry by using the lt;Tabgt; key every time, AND
then hit lt;Entergt; after the last entry,
XL will *automatically* move the focus to the cell directly under the cell
that you started using the lt;Tabgt; key on.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;Stevequot; gt; wrote in message
...
gt; After filling in a row of information, is there a way to tell Excel to
drop
gt; down a line and go back to the first column without hitting the back arrow
gt; 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.

quot;RagDyerquot; wrote:

gt; If you move quot;rightquot; after data entry by using the lt;Tabgt; key every time, AND
gt; then hit lt;Entergt; after the last entry,
gt; XL will *automatically* move the focus to the cell directly under the cell
gt; that you started using the lt;Tabgt; key on.
gt;
gt; --
gt; HTH,
gt;
gt; RD
gt; ==============================================
gt; Please keep all correspondence within the Group, so all may benefit!
gt; ==============================================
gt;
gt;
gt; quot;Stevequot; gt; wrote in message
gt; ...
gt; gt; After filling in a row of information, is there a way to tell Excel to
gt; drop
gt; gt; down a line and go back to the first column without hitting the back arrow
gt; gt; numerous times?
gt;
gt;