Unable to customize keyboard shortcuts in excel 365

[CommonQuestion]

Did microsoft remove this function? They had it in 2016.

Thanks.

[#2]

@CommonQuestion

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 article.

How did you customize it in Excel 2016?

[#3]

@CommonQuestion 

@Haytham Amairah 

 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 follows

Save

Undo

Redo

Conditional Formatting

Pivot Table

Hitting ALT + 5 will open the Insert Pivot Table dialog box.

Hope that helps

Nabil Mourad

[#4]

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-0f32...

Have you reached any progress? I still cannot find it

@CommonQuestion

[#5]

@Magdoulin 

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.

[#6]

You’re right, I didn’t realise that the article I was referring to was talking about Word, I assumed it was about Excel as my search was for Excel.

Anyways, any advice how to check the list of the assigned keyboard shortcuts in my Excel programme? The thing is, there is a universal keyboard shortcut that does not work with me whenever I try it, which is: Ctrl + ; which is there to hardcode today’s date, whereas this one works: Ctrl + Shift + ; which is there to hardcode the time now, I haven’t changed anything in my setting and I cannot figure out why it doesn’t work, so I thought to check the list of the assigned keyboard shortcuts to find out what this combination, Ctrl + ; is assigned for in my version.

[#7]

@Magdoulin 

All available keyboard shortcuts are listed here Keyboard shortcuts in Excel (microsoft.com)

To use Ctrl+something or Ctrl+Shift+something could depend on regional setting and your keyboard layout - above is for U.S.

[#8]

@CommonQuestion 

Power toys maybe?

PowerToys Keyboard Manager utility for Windows 10 | Microsoft Docs

[#9]

@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.

[#10]

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?

[#11]

@Michael_J_SL 

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.

[#12]

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!