Forum Discussion
Unable to customize keyboard shortcuts in excel 365
Did microsoft remove this function? They had it in 2016.
Thanks.
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:
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
