I assume you're entering data left to right, top to bottom.

Click TOOLS in the menu and select OPTIONS. Click on the EDIT tab and
verify that the MOVE SELECTION AFTER ENTER check box has a check mark. In
the drop-down combo box labelled DIRECTION, drop down the list and select
RIGHT.

Click OK to exit and then select the range you're doing date entry in,
starting from the first cell and dragging to the last cell. Once you start
type the enter key will move you to the right until the end of the selection,
which at that point it will move to the next line.
--
Kevin Backmann


"MSHO" wrote:

Hello. I am doing data entry and there are only 10 cells in each row. Is
there a way to make it go directly to the next line after the 10th cell has
been completed?

Thanks in advance