Forum Discussion
Unable to customize keyboard shortcuts in excel 365
Did microsoft remove this function? They had it in 2016.
Thanks.
13 Replies
CommonQuestion Workaround: Record whatever you were wanting to do as a macro. You can then assign a keyboard shortcut to that.
Pretty ridiculous that you can no longer assign a keyboard shortcut directly, but fairly typical Redmond idiocy.
I created a macro in Excel, assigned CTRL-r (which isn't in the list of shortcuts), BUT, it doesn't seem to override the Excel assigned key. Is there a method to tell Excel to use mine and not theirs?
CTRL + R is a built in shortcut in Excel for Copying to the Right. if you have a column of Text or numbers and you select an equal range in the column just to its right side., hit CTRL + R to copy to the right column.
I agree, I cannot find "Customize Shortcuts" tab that is mentioned by Microsoft itself in this article:
https://support.microsoft.com/en-us/office/customize-keyboard-shortcuts-9a92343e-a781-4d5a-92f1-0f32e3ba5b4d
Have you reached any progress? I still cannot find it
Nothing changes, customized shortcuts for Word have been for years and exist now - as in post you mentioned
There were no customized shortcuts in Excel and I don't think they'll be out of the box.
SergeiBaklanIt's not there now. I used it for years. The article references where it should be, but it's gone.
- I agree with Haytham.In Excel the only customizable Shortcuts are:1- The ones you create for running Macros (in the Macro Recorder)2- The Shortcuts used to run commands from the Quick Access Toolbar , using ALT + a number that corresponds to the order of the command in the Quick Access Toolbar.e.g. If you have 5 commands on the QAT ordered as followsSaveUndoRedoConditional FormattingPivot TableHitting ALT + 5 will open the Insert Pivot Table dialog box.Hope that helpsNabil Mourad
To my knowledge, the keyboard shortcuts in Excel cannot be customized unless you use some third-party tools!
Please check out this link.
By the way, this option is available in Word not in Excel according to this https://support.office.com/en-us/article/customize-keyboard-shortcuts-9a92343e-a781-4d5a-92f1-0f32e3ba5b4d.
How did you customize it in Excel 2016?
