Forum Discussion
Unable to customize keyboard shortcuts in excel 365
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.
Thanks nabilmourad
It looked like that is what is was doing. Do bad Excel doesn't let you override that or at least tell you that the shortcut key you define isn't going to work!
