How to move to next cell after input automatically in Excel?
In this article, I introduce the tricks on automatically moving cursor to next cell to input sequence number without pressing Enter key in Excel.
Auto move to next right cell after 4-digit inputting without press Enter key with VBA
Auto fill 4-digit series with Kutools for Excel 
Auto move to next right cell after 4-digit inputting without press Enter key with VBA
Here is VBA code that can help you automatically move to the next right cell after entering a 4-digit number, without pressing the Enter key.
1. Press Alt + F11 keys to open Microsoft Visual Basic for Applications window.
2. Click Insert > Module and paste below VBA code to the Module script. See screenshot:
VBA: Auto move to next right cell after 4-digit number input.
Sub FourCharEntry1()
'UpdatebyExtendoffice20160614
Dim xStr As String
Dim I As Integer
Dim K As Integer
xStr = Application.InputBox("Enter string", "Kutools for Excel", , , , , , 2)
K = 0
Application.ScreenUpdating = False
For I = 1 To Len(xStr) Step 4
ActiveCell.Offset(0, K) = "'" & Mid(xStr, I, 4)
K = K + 1
Next
Application.ScreenUpdating = True
End Sub
3. Press the F5 key to run the code, and a Kutools for Excel dialog will pop out, you can enter sequence numbers in it without any separators. See screenshot:
4. Click OK. Now every 4 digits have been placed in one cell from left to right.
Tip: If you want to enter 5-digit, 6-digit…into cell, you can change 4 to 5, 6 or others in the code.
Auto fill 4-digit series with Kutools for Excel
With Kutools for Excel – a handy tool, you can auto fill series numbers to a range without press the Enter key by its Insert Sequence Number utility.
After free installing Kutools for Excel, please do as below:
1. Select a column or a row you want to fill series, and click Kutools > Insert > Insert Sequence Number. See screenshot:
2. In the Insert Sequence Number dialog, click New to expand the dialog. See screenshot:
3. Then specify the series as you need. See screenshot:
4. Click Add > Fill Range, then the selected range will be auto-filled with the sequence numbers.
Tip: With Insert Sequence Number utility, you also can insert repeated series. Check End number option in the dialog, enter the ending number you want into the right textbox, and then the series numbers will be filled repeatedly every 10 numbers. See screenshot:
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
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!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in