question

Airun-8433 avatar image
0 Votes"
Airun-8433 asked Airun-8433 commented

How can I disable hotkeys in Excel

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

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered Airun-8433 commented

@Airun-8433

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.




capture4.jpg (97.5 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I'm merely an underling and do not have GP access. I'm in IT but the wrong department for that lol. But it is 365 Apps for Enterprise.

0 Votes 0 ·

What I need is a way, w/o admin rights, to disable them. So many programs have the decency to put in toggles to disable items like this. But it's never so Microsoft Products.

0 Votes 0 ·

Hi @Airun-8433

Thanks for your replies.
Currently, as I am unable to find any lightweight setting in the Excel app to achieve your needs, if you need a way that without admin rights, I would suggest you use the VBA code that I mendtioned above to disable these shortcut keys .
Thanks again for your understanding.

0 Votes 0 ·