Document Editing Problems

Fix Cannot Edit Numerical Cells in Excel (Num Lock Issue)

Elise Williams Oct 9, 2026 870 views

Question details

The user is unable to type or edit numbers in spreadsheet cells using the numeric keypad, while text input continues to function normally.

How to Fix Cannot Edit Numerical Cells in Excel

Product: Excel
Device & OS: not provided
Scenario: Entering numerical data into a spreadsheet using a physical keyboard's numeric keypad.
Observed behavior: Text cells remain editable, but pressing number keys on the numeric keypad does not input numbers or allow editing of numerical cells.

Before you start

Ensure your keyboard is properly connected to your computer and check if the standard number keys on the top row of your keyboard are functioning correctly to isolate the issue to the keypad.

Solution 1Recommended

Enable the Num Lock Key

The most common reason for numeric keypad failure in Excel is that the Num Lock key is accidentally turned off.

When the Num Lock key is disabled, the numeric keypad on most keyboards switches to navigation mode (acting as arrow keys, Home, End, etc.) instead of typing numbers. Turning it back on restores standard numerical entry.

Locate the Num Lock Key

Find the 'Num Lock' (or 'NumLk') key on your physical keyboard. It is typically located above the numeric keypad on the right side.

Press to Enable

Press the 'Num Lock' key once to activate it. Look for an indicator LED light on your keyboard confirming that the numeric lock is now active.

Test Cell Editing

Return to your Excel worksheet, select a numerical cell, and try typing numbers using the numeric keypad to confirm the issue is resolved.

On-Screen Keyboard Verification: If your physical keyboard lacks a Num Lock indicator light, you can open the Windows 'On-Screen Keyboard' via the Start menu to visually check if the Num Lock key is highlighted and active.

Solution 2

Check for Cell Protection

If Num Lock is enabled but you still cannot edit specific numerical cells, the worksheet or the cells may be protected by the author.

Advanced Spreadsheet Editing

Efficiently Edit and Analyze Data with WPS Spreadsheet

WPS Spreadsheet offers a highly intuitive user interface for all your data entry and analysis needs. It perfectly recognizes physical keyboard inputs and ensures a smooth editing experience, allowing you to manage large datasets effortlessly.

1. Download WPS Office: Download and install the free WPS Office suite from the official website.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx or .xls file.
3. Enter Data Seamlessly: Select your target cell, ensure your keyboard's Num Lock is enabled, and easily edit your numerical data without interruption.

Flawless compatibility with all major Microsoft Excel (.xlsx, .xls, .csv) formats.Intuitive interface for seamless numerical data entry, editing, and formatting.Free, lightweight, and fast to launch on any operating system.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my arrow keys move the whole spreadsheet instead of moving between cells?

This happens when the 'Scroll Lock' key is enabled. Press the Scroll Lock (ScrLk) key on your keyboard to toggle it off, which will immediately restore normal cell-to-cell navigation.

Can I edit locked numerical cells if I don't have the worksheet password?

No, if a worksheet is strictly protected with a password, you must enter the correct password via the 'Review' tab > 'Unprotect Sheet' before you can edit any locked numerical cells.

Why are the numbers I type automatically formatting as dates?

This occurs when the cell format is accidentally set to 'Date'. To fix it, right-click the affected cell, select 'Format Cells', navigate to the 'Number' tab, and change the category to 'General' or 'Number'.

Document & File Issues