How to Fix Excel Numeric Keypad Minus Key Not Starting Formulas
Question details
The user cannot initiate a spreadsheet formula using the minus key on the numeric keypad, as it sometimes highlights cells instead.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Starting a calculation by typing a minus sign in a worksheet cell or the formula bar.
- Observed behavior
- The numeric keypad minus key fails to start a formula and acts as an extended selection or navigation key when Num Lock is enabled or disabled.
Open a plain text editor like Notepad and press the numeric keypad minus key to ensure the hardware is functioning and the keystroke is being registered by your operating system.
Toggle Num Lock and Test the Formula Bar
Determine if the issue is tied to the Num Lock state or specific cell entry behaviors.
In some Excel builds, the numeric keypad minus key behaves differently depending on whether Num Lock is active. When Num Lock is off, Excel often interprets keypad strokes as navigation or selection commands.
Look for the Num Lock indicator light on your keyboard. Press the 'Num Lock' key to toggle it on.
Select an empty cell and press the numeric keypad minus key to see if the formula cursor appears.
Click directly inside the formula bar at the top of the worksheet and press the keypad minus key. If it works here but not in the cell, the issue may be related to in-cell editing settings.

Disable Windows Keyboard Accessibility Settings
Turn off Ease of Access features that might be hijacking or altering your numeric keypad inputs.
Update Microsoft Excel
Install the latest Office updates to patch known bugs related to keyboard inputs.
Switch to WPS Office for a Bug-Free Spreadsheet Experience
If persistent Microsoft Excel bugs are disrupting your workflow, WPS Spreadsheet offers a seamless, reliable, and highly compatible alternative without the frustrating keyboard glitches.
- 1. Download and Install: Visit the official WPS website to download the free installation package for your operating system.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and easily open your existing Excel workbooks without losing any formatting or data.
- 3. Calculate Without Interruptions: Use your numeric keypad and formulas just as you always have, benefiting from reliable and stable performance.

Frequently Asked Questions
Why does my numeric keypad act as arrow keys in Excel?
This happens when the Num Lock key is disabled. Without Num Lock, the numbers on the keypad default to their secondary navigation functions, such as moving up, down, left, or right across cells.
Does the main keyboard minus key work differently than the numeric keypad one?
Yes. The standard hyphen/minus key on the top row of your keyboard operates independently of the Num Lock status and is less likely to be affected by specific accessibility settings like Mouse Keys.
Can Excel add-ins interfere with keyboard shortcuts?
Yes, third-party Excel add-ins can sometimes intercept or remap keystrokes. You can test this by launching Excel in Safe Mode (holding the Ctrl key while opening the app) to see if the minus key works normally without add-ins loaded.




