Excel2007 Stipulate where cursor goes when Enter Key pressed

[RonG]

In Excel 2007, where are the old Tools/Keyboard options. I want to change the
cursor position when Enter Key pressed. Cursor is required to move down one
cell, and two cells to the left.

 

[Aviral Sharma]

You can change the cursor movement as per your choice.
Click on the Windows button on the top left corner and choose "Excel Options"
now click on "Advanced" tab and you will find the option to change cursor
movement under Editing Options.

To find various options of Excel 2003 on Excel 2007 Please refer the
interactive guide on the following page:

http://office.microsoft.com/en-us/excel/HA101491511033.aspx

Hope it helps.

Pls click yes if it solves your problem..

Avi

 

[RonG]

Thanks Avi,
Partially helpful, but I only get four movement options: Up, Down, Left
Right. I thought I could move One cell down and One cell left. I'll write a
macro to overcome this problem. Cheers, Ron

 

[Gord Dibben]

No version of Excel has had more than the standard four options you see.

Yes, a macro would work.

Event code behind the sheet would seem appropriate.


Gord Dibben MS Excel MVP

 

[RonG]

Thanks Gord, you've confirmed my thoughts. A macro with a button on the
spreadsheet should do the trick. Thanks buddy.

 

[Gord Dibben]

I would prefer event code so's I didn't have to click a button

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then
With Target
.Offset(1, -1).Select
End With
End If
End Sub

Goes into the sheet module.

Requires that something has been entered in the activecell then ENTER key
hit.


Gord