Excel2007 Stipulate where cursor goes when Enter Key pressed

R

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.
 
A

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
 
R

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
 
G

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
 
R

RonG

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top