Share via

Ctrl + 1 not working

Anonymous
2020-11-04T15:38:12+00:00

Ctrl + 1 short cut does not bring up formatting options in Microsoft excel 2019. My operating system is a windows 10 Pro and all the solutions I could find in here with respect to this issue don't work too.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2020-11-04T16:42:55+00:00

    Please follow these steps:

    Close Excel

    Press and hold the CTRL key

    Open Excel

    Wait for a message to appear and ask for "Safe Mode"

    Release the CTRL key

    Click Yes

    After Excel opens

    Click File\Open and select your file

    Press and hold the SHIFT key

    Click Open

    Wait for your file to open

    Release the SHIFT key

    Test the behavior

    What happens?

    If CTRL+1 does not work, does the Format window comes up if you right-click and choose "Format Cells"?

    Andreas.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2020-11-04T19:32:34+00:00

    Please follow these steps:

    Close Excel

    Press and hold the CTRL key

    Open Excel

    Wait for a message to appear and ask for "Safe Mode"

    Release the CTRL key

    Click Yes

    After Excel opens

    Click File\Open and select your file

    Press and hold the SHIFT key

    Click Open

    Wait for your file to open

    Release the SHIFT key

    Test the behavior

    What happens?

    If CTRL+1 does not work, does the Format window comes up if you right-click and choose "Format Cells"?

    Andreas.

    Right clicking does show the format window but CTRL+1 shortcut still doesn't work

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments
  3. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2020-11-07T14:29:17+00:00

    The issue is persisting while using the laptop keyboard and  not with the Virtual one.

    Could this an issue with the drivers or Ms OS ?

    I'm not an expert for that, but IMHO it is obvious that the keyboard do not send the correct scan code.

    Maybe it's the driver in the OS and/or the keyboard layout...  unfortunately I can't help with that.

    Andreas.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-11-06T18:54:43+00:00

    Close all applications

    Go to this website and lunch the keyboard tester

    https://www.keyboardtester.com/

    Check if your keyboard works

    If so use this program to check whether an other application has set a global shortcut

    https://www.nirsoft.net/utils/hot_keys_list.html

    If neither is the case, repair your Office, maybe de-/install

    Repair an Office application - Office Support

    Uninstall Office from a PC - Office Support

    Andreas.

    Hello,

    All of the steps provides don't work as well. The issue is persisting while using the laptop keyboard and  not with the Virtual one.

    I did run the keyboard test but all my keys are ok.

    Could this an issue with the drivers or Ms OS ?

    Was this answer helpful?

    0 comments
  5. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2020-11-05T04:46:35+00:00

    Close all applications

    Go to this website and lunch the keyboard tester

    https://www.keyboardtester.com/

    Check if your keyboard works

    If so use this program to check whether an other application has set a global shortcut

    https://www.nirsoft.net/utils/hot_keys_list.html

    If neither is the case, repair your Office, maybe de-/install

    Repair an Office application - Office Support

    Uninstall Office from a PC - Office Support

    Andreas.

    Was this answer helpful?

    0 comments