Doubt in excel regarding Cursor movement...

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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
 
Back
Top