Skip to main content

How to automatically move cursor to specific cell in Excel?

Sometimes, you may need to jump to specific cell for some purpose. This article will show you methods of moving cursor to specific cell in details.

Auto move cursor to specific cell with the Name box
Auto move cursor to specific cell with VBA code

Auto move cursor to specific cell with the Name box

The Name box can help you easily move cursor to specific cell in Excel.

1. In the Name box, enter the specific cell reference you will jump to, and then press the Enter key.

Then the cursor moves to the specified cell immediately.

Note: If you need to jump to the specified cell in another worksheet, for example jump to cell C30 of Sheet2, please type Sheet2!C30 into the Name box, and then press the Enter key.

Auto move cursor to specific cell with VBA code

The following VBA code helps you moving to specific cell at once in Excel.

1. Press Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window.

2. In the Microsoft Visual Basic for Applications window, double click ThisWorkbook in the left pane to open the ThisWorkbook (Code) window. Then copy and paste the below VBA code into the window.

VBA code: Move to the beginning or start of next row for data entry

Sub jumpnext()
    Range("F100").Select
End Sub

Note: In the code, F100 is the specified cell you will jump to. You can change it as you need.

3. Press the F5 key to run the code, then the cursor moves to cell F100 in current worksheet immediately.

Related articles:

Best Office Productivity Tools

Supports Office/Excel 2007-2021 and 365  |  Available in 44 Languages  |  Easy to Uninstall Completely

Popular Features: Find/Highlight/Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup  |   Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns   |   Move Columns   |   Unhide Columns   |   Compare Columns to Select Same & Different Cells ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar   |  Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells   |  Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets:  12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need Is Just A Click Away...

Supercharge Your Excel Skills: Experience Efficiency Like Never Before with Kutools for Excel  (Full-Featured 30-Day Free Trial)

kte tab 201905

60-Day Unconditional Money-Back GuaranteeRead More... Free Download... Purchase... 

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day! (Full-Featured 30-Day Free Trial)
60-Day Unconditional Money-Back GuaranteeRead More... Free Download... Purchase... 
 
Comments (15)
No ratings yet. Be the first to rate!
arvind
arvind
This comment was minimized by the moderator on the site
Sub jumpnext()
Range("F100").Select
End Sub

What chnage do i have to do so this code can be uased on all sheets of the workbook at the same time.

Regards,
Reply
0
0
crystal
crystal     arvind
This comment was minimized by the moderator on the site
Hi arvind,

The following VBA code can do you a favor. Please give it a try. Thank you.
Note: You need to put the VBA code in the ThisWorkbook (Code) editor.
Sub jumpnext()
'Updated by Extendoffice 20230109
Set CurrWS = ActiveSheet
    For Each WS In ThisWorkbook.Worksheets
    WS.Activate
        WS.Range("F100").Select
    Next
    CurrWS.Activate
End Sub

https://www.extendoffice.com/images/stories/comments/comment-picture-zxm/select-same-cell.png
Reply
Report
0
0
Andy Coghlan
Andy Coghlan
This comment was minimized by the moderator on the site
Hi,

Can you help with the following VBA code request please?

Sheet 1 is named "Master Asset" with a further 100 sheets named as "0001...0002...0003....0004 ~ 0100"

In any of each of the sheets "0001 ~ 0100"
I want to be able to select cell A4 which already contains text "Back to Master Asset" then press enter, to automatically jump back to cell J3 in the "Master Asset"

Thanks in advance.
Andy C.
Reply
0
0
crystal
crystal     Andy Coghlan
This comment was minimized by the moderator on the site
Hi Andy Coghlan，
I can't find a way to trigger the macro with the enter key right now. The following VBA code can insert the same hyperlink in A4 of all worksheets at the same time. After clicking the hyperlink in A4, it will jump to J3 in the "Master Asset". Please give it a try.

Sub AddHyperlinks()
'Updated by Extendoffice 20220715
    Dim xRg, yRg As Range
    Set xRg = Worksheets("Master Asset").Range("J3")
    xStr = xRg.Address(External:=True)
    For Each Sh In Worksheets
        If Sh.Name <> "Sh.Name" Then
            Set yRg = Sh.Range("A4")
            yRg.Hyperlinks.Add anchor:=yRg, Address:="", SubAddress:=xStr, TextToDisplay:="Back to Master Asset"
        End If
    Next
End Sub
Reply
Report
0
0
Nelson
Nelson
This comment was minimized by the moderator on the site
Bagiaimana mengisi textbox pada form dengan memilih data di cell/sheet yg dipilih dgn kursor ?
Reply
0
0
crystal
crystal     Nelson
This comment was minimized by the moderator on the site
Hi Lelson,
Sorry I don't understand what you mean. Would you mind providing a screenshot of your data? Or try to be more specific about your question. Sorry for the inconvenience.
Reply
Report
0
0
Shahad
Shahad
This comment was minimized by the moderator on the site
you didn't sign the F5 for teh code, how it is gonna run by pressing F5?
Reply
0
0
John
John
This comment was minimized by the moderator on the site
Is it possible to move the active cell without pressing a key on the keyboard? For example, can I have the cell move down as soon as the cell above it is filled? I am looking for either a function or a VBA to run when a cell is filled. As soon as A3 has characters in it, is there a VBA to move the active cell down to A4?
Reply
0
0
crystal
crystal     John
This comment was minimized by the moderator on the site
Hi John,
I am confused on your question. How can we know if the cell is finish editing?
Reply
Report
0
0
James
James
This comment was minimized by the moderator on the site
Sorry I mean to type "instantly jump to F8"
Reply
0
0
crystal
crystal     James
This comment was minimized by the moderator on the site
Hi James,
Please try the below code. After data has been entered into E6, press the Tab key or the Enter key, and the cursor will jump to F8 instantly.

Private Sub Worksheet_Change(ByVal Target As Range)

'Updated by Extendoffice 2020087

Dim tabArray As Variant

Dim i As Long

tabArray = Array("E6", "F8")

Application.ScreenUpdating = False

For i = LBound(tabArray) To UBound(tabArray)

If tabArray(i) = Target.Address(0, 0) Then

If i = UBound(tabArray) Then

Me.Range(tabArray(LBound(tabArray))).Select

Else

Me.Range(tabArray(i + 1)).Select

End If

End If

Next i

Application.ScreenUpdating = True

End Sub
Reply
Report
0
0
james
james
This comment was minimized by the moderator on the site
How would I have the cursor move from Cell E6 to F8 once data has been entered into E6? I would like the cursor to ignore all the other lines in the E column and instantly jump to E6.
Reply
0
0
Steve
Steve
This comment was minimized by the moderator on the site
That's helpful thanks. However I would like to have a formula as the argument for the 'Range' function. Is this permissible? What I would like to do is have the user enter a number in a dialog box, then search for the first occurrence of that number in a range of cells, and then jump the cursor to that cell...
Reply
0
0
crystal
crystal     Steve
This comment was minimized by the moderator on the site
Hi Steve,
Sorry can't help you with that.
Reply
Report
0
0
Kris
Kris
This comment was minimized by the moderator on the site
I'd like to make a macro that moves from one cell to the next, step by step.
Reply
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations