Carriage return after last column

S

Steve

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?
 
P

Peo Sjoblom

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
 
R

RagDyer

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!
==============================================
 
W

widman

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.
 
Top