Forum Discussion

LLattuca's avatar
LLattuca
Copper Contributor
Dec 15, 2021

minus key

When attempting to enter a negative number in a cell using the minus key of the numeric key block area of the keyboard, I must first hit any other key in the numeric block of the keyboard.  This just started happening and I don't know how to fix it.  The problem is limited to all Excel files (workbooks, and spreadsheets) on one computer. 

The same keyboard functions perfectly when attached to another computer. 

The minus key above the alpha keys on the same keyboard works perfectly.

I can get the minus key of the numeric key area to work only when I press another key of the numeric key area first.

This one is driving me crazy cause it seems to be a problem with Excel on one computer and not the keyboard...  Any help is greatly appreciated!!!

7 Replies

  • Robin730's avatar
    Robin730
    Copper Contributor

    LLattuca Check the On Screen keyboard to make sure the num lock is on. Do this by searching On Screen Keyboard and choose the search result and click the numlock button with your mouse. 

    • leah_elliott's avatar
      leah_elliott
      Copper Contributor
      Thank you so very much! I was having the same issue and your solution worked!!!!!
    • LLattuca's avatar
      LLattuca
      Copper Contributor
      Thank you so much for your response!!!



      Yes it happens in safe mode also but I have a new detail....



      When I press the minus key in the numeric keypad area....Excel displays a comment on the bottom right of the screen next to the word READY....the comment is " Extend Section " and when I make a cursor movement on the keyboard adjacent cells are "highlighted" along with the current cell...it's kina making a cell selection of some type with adjacent cells in the direction I move the cursor
      I also noticed the Minus Key of the numeric keypad area will function properly when I turn off the NUMLOCK key....but then the numeric keypad keys function as cursor directors...
    • LLattuca's avatar
      LLattuca
      Copper Contributor

      SergeiBaklan 

       

      Thank you so much for your response!!!

       

      Yes it happens in safe mode also but I have a new detail....

       

      When I press the minus key in the numeric keypad area....Excel displays a comment on the bottom right of the screen next to the word READY....the comment is " Extend Section "  and when I make a cursor movement on the keyboard adjacent cells are "highlighted" along with the current cell...it's kina making a cell selection of some type with adjacent cells in the direction I move the cursor

      • LLattuca's avatar
        LLattuca
        Copper Contributor
        I also noticed the Minus Key of the numeric keypad area will function properly when I turn off the NUMLOCK key....but then the numeric keypad keys function as cursor directors...

Resources