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:


The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

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!
officetab bottom
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    John · 2 months ago
    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?
    • To post as a guest, your comment is unpublished.
      crystal · 2 months ago
      Hi John,
      I am confused on your question. How can we know if the cell is finish editing?
  • To post as a guest, your comment is unpublished.
    James · 2 months ago
    Sorry I mean to type "instantly jump to F8"
    • To post as a guest, your comment is unpublished.
      crystal · 2 months ago
      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
  • To post as a guest, your comment is unpublished.
    james · 2 months ago
    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.
  • To post as a guest, your comment is unpublished.
    Steve · 1 years ago
    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...
    • To post as a guest, your comment is unpublished.
      crystal · 1 years ago
      Hi Steve,
      Sorry can't help you with that.
  • To post as a guest, your comment is unpublished.
    Kris · 2 years ago
    I'd like to make a macro that moves from one cell to the next, step by step.