Formula Errors

How to Fix Excel Numeric Keypad Minus Key Not Starting Formulas

Aamir Naveed AkramAamir Naveed Akram Nov 3, 2026 869 views

Question details

The user cannot initiate a spreadsheet formula using the minus key on the numeric keypad, as it sometimes highlights cells instead.

How to Fix Excel Numeric Keypad Minus Key Not Starting Formulas
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.
Before you start

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.

Solution 1Recommended

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.

1
Check Num Lock Status

Look for the Num Lock indicator light on your keyboard. Press the 'Num Lock' key to toggle it on.

2
Test in a Worksheet Cell

Select an empty cell and press the numeric keypad minus key to see if the formula cursor appears.

3
Test in the Formula Bar

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.

Toggle Num Lock and Test the Formula Bar
Alternative Key: While troubleshooting, you can always use the standard hyphen/minus key located next to the number 0 on the top row of your main keyboard.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS website to download the free installation package for your operating system.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheet and easily open your existing Excel workbooks without losing any formatting or data.
  3. 3. Calculate Without Interruptions: Use your numeric keypad and formulas just as you always have, benefiting from reliable and stable performance.
Fully compatible with Microsoft Excel (.xls, .xlsx) files and formulasLightweight application that runs smoothly on older and newer systems alikeFamiliar user interface ensuring a zero-learning-curve transitionFree to use for everyday spreadsheet creation and data analysis
microsoft office alternative - wps office

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.