Unable to customize keyboard shortcuts in excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-714610%22%20slang%3D%22en-US%22%3EUnable%20to%20customize%20keyboard%20shortcuts%20in%20excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-714610%22%20slang%3D%22en-US%22%3E%3CP%3EDid%20microsoft%20remove%20this%20function%3F%20They%20had%20it%20in%202016.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-714610%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-715060%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20customize%20keyboard%20shortcuts%20in%20excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-715060%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F364772%22%20target%3D%22_blank%22%3E%40CommonQuestion%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20my%20knowledge%2C%20the%20keyboard%20shortcuts%20in%20Excel%20cannot%20be%20customized%20unless%20you%20use%20some%20third-party%20tools!%3C%2FP%3E%3CP%3EPlease%20check%20out%20this%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FCustomize-keyboard-shortcuts-excel-2016-Microsoft%2Ftd-p%2F174480%22%20target%3D%22_blank%22%3Elink%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBy%20the%20way%2C%20this%20option%20is%20available%20in%20Word%20not%20in%20Excel%20according%20to%20this%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcustomize-keyboard-shortcuts-9a92343e-a781-4d5a-92f1-0f32e3ba5b4d%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Earticle%3C%2FA%3E.%3C%2FP%3E%3CP%3EHow%20did%20you%20customize%20it%20in%20Excel%202016%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-715801%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20customize%20keyboard%20shortcuts%20in%20excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-715801%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F364772%22%20target%3D%22_blank%22%3E%40CommonQuestion%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22user-login%22%3E%26nbsp%3BI%20agree%20with%20Haytham.%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3EIn%20Excel%20the%20only%20customizable%20Shortcuts%20are%3A%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3E1-%20The%20ones%20you%20create%20for%20running%20Macros%20(in%20the%20Macro%20Recorder)%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3E2-%20The%20Shortcuts%20used%20to%20run%20commands%20from%20the%20Quick%20Access%20Toolbar%20%2C%20using%20ALT%20%2B%20a%20number%20that%20corresponds%20to%20the%20order%20of%20the%20command%20in%20the%20Quick%20Access%20Toolbar.%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3Ee.g.%20If%20you%20have%205%20commands%20on%20the%20QAT%20ordered%20as%20follows%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3ESave%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3EUndo%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3ERedo%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3EConditional%20Formatting%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3EPivot%20Table%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3EHitting%20ALT%20%2B%205%20will%20open%20the%20Insert%20Pivot%20Table%20dialog%20box.%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3EHope%20that%20helps%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3ENabil%20Mourad%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

 

Thanks.

7 Replies

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

@CommonQuestion 

@Haytham Amairah 

 

 

 

  

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

@Magdoulin 

Nothing changes, customized shortcuts for Word have been for years and exist now - as in post you mentioned

image.png

There were no customized shortcuts in Excel and I don't think they'll be out of the box.

 

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.

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