How can I disable hotkeys in Excel

Airun 6 Reputation points
2021-10-31T18:28:03.283+00:00

I would like to disable specifically the ctrl+arrow hotkeys. Can this be done? I'm using Office 365 Excel version 2102

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,649 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,546 Reputation points
    2021-11-01T06:01:12.643+00:00

    @Airun

    Which version of Microsoft 365 Apps do you have?

    If you have Microsoft 365 Apps for enterprise, please try to set Group Policy.
    User Configuration > Administrative Templates > Microsoft Excel 2016 > Disable Items in User Interface > Custom, enable "Disable shotcut keys".
    Then enter following "[key],[modifier]" values:
    "40,8" for Ctrl + Down arrow key
    "38,8" for Ctrl + Up arrow key
    "39,8" for Ctrl + Right arrow key
    "37,8" for Ctrl + Left arrow key
    145402-capture4.jpg
    For more, please refer to "Disabling shortcut keys by using virtual key codes" and "Virtual-Key Codes" (You need to convert the hexadecimal value to decimal).

    If you have other versions for Microsoft 365 Apps, I suggest you try VBA code to disable these shortcut keys via "Application.OnKey" method.
    But as the VBA code is out of our support scope, I would suggest you post a new thread with tag "office-vba-dev". Thanks for your understanding.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.