return to first column of next row
 

I am trying to make a worksheet with only seven columns. I configured excel
to move to the right after entering data into a cell. I need help creating an
auto return after the data is entered into the last column (G). Also, Is
there a way to have Excel display only the seven columns for the end-user? I
have looked for examples of code but I can not find what I need or make it
myself.

return to first column of next row
 

Hide the other columns.

Unlock cells in the 7 columns then protect the worksheet.

Use Tab key to move across and down.

Or set the ENTER key to move right.

Without protection...................

Hide the unneeded columns.

Start in A1 and Tab your way across as you enter data.

When leaving column G hit the ENTER key to move back to column A one row down.




On Tue, 12 Feb 2008 11:56:02 -0800, DanO wrote:

I am trying to make a worksheet with only seven columns. I configured excel
to move to the right after entering data into a cell. I need help creating an
auto return after the data is entered into the last column (G). Also, Is
there a way to have Excel display only the seven columns for the end-user? I
have looked for examples of code but I can not find what I need or make it
myself.

return to first column of next row
 

In addition to Gord's suggestion, how about some VBA code to simulate
a typewriter return?

This would go in the sheet module for the worksheet you are using.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Column = 8 Then ActiveCell.Offset(1, -7).Select
End Sub

See http://www.rondebruin.nl/code.htm if you need assistance
implementing.

HTH,
JP

On Feb 12, 2:56*pm, DanO wrote:
I am trying to make a worksheet with only seven columns. I configured excel
to move to the right after entering data into a cell. I need help creating an
auto return after the data is entered into the last column (G). Also, Is
there a way to have Excel display only the seven columns for the end-user? I
have looked for examples of code but I can not find what I need or make it
myself.

return to first column of next row
 

Thanks for the code and link to help me get this working. It works prefect.

"JP" wrote:

In addition to Gord's suggestion, how about some VBA code to simulate
a typewriter return?

This would go in the sheet module for the worksheet you are using.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Column = 8 Then ActiveCell.Offset(1, -7).Select
End Sub

See http://www.rondebruin.nl/code.htm if you need assistance
implementing.

HTH,
JP

On Feb 12, 2:56 pm, DanO wrote:
I am trying to make a worksheet with only seven columns. I configured excel
to move to the right after entering data into a cell. I need help creating an
auto return after the data is entered into the last column (G). Also, Is
there a way to have Excel display only the seven columns for the end-user? I
have looked for examples of code but I can not find what I need or make it
myself.

return to first column of next row
 

Glad to hear it!


--JP

On Feb 13, 2:48*pm, DanO wrote:
Thanks *for the code and link to help me get this working. It works prefect.



"JP" wrote:
In addition to Gord's suggestion, how about some VBA code to simulate
a typewriter return?

This would go in the sheet module for the worksheet you are using.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
* * If ActiveCell.Column = 8 Then ActiveCell.Offset(1, -7).Select
End Sub

Seehttp://www.rondebruin.nl/code.htmif you need assistance
implementing.