One way
right click sheet tabinsert this

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 11 Then Cells(Target.Row + 1, 1).Select
End Sub

--
Don Guillett
SalesAid Software

"Diamontina Cocktail" wrote in message
...
Hi all,

Just trying to get the sheet to be fixed in width from 1 to 11 so that
when I tab to the next column from the last on the right, it automatically
goes down to the next row and starts out at 1 on that next row again.

I know it can be done but just haven't found it and really need it. Can
anyone help please? Thanks.