Doubt in excel regarding Cursor movement...

[Guest]

How can I get the cursor from B3 (Example) cell to E20 cell, when hitting
ENTER at B3?

or How can I control the movement of the Cursor through keyboard
rapidly..... I mean the above actually

 

[Arvi Laanemets]

Hi

Create an ordered named range, and activate it always before entering data!

Creating: holding Ctrl key down, select wanted cells in order starting with
second and ending with first. Enter some name for range into Name box and
press Enter.
Activating: select some cell in datarange, and then the name of created
range in Name box.

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0008.html

 

[Gord Dibben]

In addition to the two methods outlined at the URL Frank directed you to

There is a third method which requires VBA and a Worksheet_Change event.

''moves from C2 through E5 at entry
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$C$2"
Range("C5").Select
Case "$C$5"
Range("E2").Select
Case "$E$2"
Range("E5").Select
End Select
End Sub

Gord Dibben Excel MVP