Excel2007 Stipulate where cursor goes when Enter Key pressed
 

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.

--
Ron
Perth
Western Australia

Excel2007 Stipulate where cursor goes when Enter Key pressed
 

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/ex...491511033.aspx

Hope it helps.

Pls click yes if it solves your problem..

Avi

"RonG" wrote:

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.

--
Ron
Perth
Western Australia

Excel2007 Stipulate where cursor goes when Enter Key pressed
 

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
--
Ron
Perth
Western Australia


"Aviral Sharma" wrote:

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/ex...491511033.aspx

Hope it helps.

Pls click yes if it solves your problem..

Avi

"RonG" wrote:

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.

--
Ron
Perth
Western Australia

Excel2007 Stipulate where cursor goes when Enter Key pressed
 

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



On Mon, 9 Mar 2009 04:00:12 -0700, RonG
wrote:

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

Excel2007 Stipulate where cursor goes when Enter Key pressed
 

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


"Gord Dibben" wrote:

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



On Mon, 9 Mar 2009 04:00:12 -0700, RonG
wrote:

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

Excel2007 Stipulate where cursor goes when Enter Key pressed
 

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

On Mon, 9 Mar 2009 14:24:07 -0700, RonG
wrote:

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