Fix Excel Data Entry and Merged Cell Navigation Problems
Question details
The user needs to enter numbers in an Excel worksheet without unexpected cursor movement and investigate a message about unmerging cells.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Entering numeric data into a worksheet that may contain merged cells.
- Observed behavior
- The cursor moves to another field when numbers are entered, and Excel displays a message concerning unmerging cells.
Note whether the cursor moves when you press a numeric keypad key or only after you press Enter. Also check the exact wording of the unmerge message and the cells selected when it appears.
Check Num Lock on the numeric keypad
Use this check if keypad keys move the selection instead of entering numbers.
Press the Num Lock or NumLk key on your keyboard, then check its indicator light if your keyboard has one.
Click an empty worksheet cell and type a number using the numeric keypad. Compare the result with the number keys above the letters.

Inspect and unmerge the affected Excel cells
Check the selected range if Excel displays an unmerge message or navigation behaves unexpectedly around merged cells.
Check where Excel moves after Enter
Use this option if the number is entered successfully but the selection moves after you press Enter.
Edit spreadsheets with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet to continue working with data and merged cells; it does not repair Excel itself.

Frequently Asked Questions
Why do the numeric keypad keys move between cells?
Num Lock may be off, causing keypad keys to act as navigation keys. Press Num Lock and test the keypad in an empty cell.
Why does Excel move to another cell after I press Enter?
Excel can be set to move the selection after Enter. In Excel for Windows, check File > Options > Advanced > Editing options to change or disable that behavior.
How do I unmerge a cell in Excel?
Select the merged cell, then choose Home > Merge & Center drop-down > Unmerge Cells. The value remains in the upper-left cell of the former merged range.
Do merged cells always cause data entry problems?
No. Merged cells can affect selection and navigation, but a Num Lock setting or Excel's Enter behavior may also explain cursor movement. Check the exact message and test each possibility.




