Document Editing Problems

Fix Excel Data Entry and Merged Cell Navigation Problems

Natalie TaylorNatalie Taylor Nov 18, 2026 868 views

Question details

The user needs to enter numbers in an Excel worksheet without unexpected cursor movement and investigate a message about unmerging cells.

Fix Excel Data Entry and Merged Cell Navigation Problems
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.
Before you start

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.

Solution 1Recommended

Check Num Lock on the numeric keypad

Use this check if keypad keys move the selection instead of entering numbers.

1
Turn on Num Lock

Press the Num Lock or NumLk key on your keyboard, then check its indicator light if your keyboard has one.

2
Test number entry

Click an empty worksheet cell and type a number using the numeric keypad. Compare the result with the number keys above the letters.

Check Num Lock on the numeric keypad
Free Microsoft Office alternative

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.

Enter data and manage merged cells in WPS SpreadsheetCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

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.