Home
%3CLINGO-SUB%20id%3D%22lingo-sub-276459%22%20slang%3D%22en-US%22%3EExcel%20for%20Mac%20-%20customize%20your%20keyboard%20shortcuts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-276459%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22contentStandard%22%3EThere's%20a%20feature%20in%20Excel%20for%20Mac%20that%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22link%20to%20Excel.UserVoice.com%22%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933-excel-for-mac%2Fsuggestions%2F10217199-bring-back-real-keyboard-customization%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Emany%20people%20have%20been%20asking%20for%3C%2FA%3E.%26nbsp%3B%20The%20%22Customize%20Keyboard%22%20feature%20is%20now%20available.%26nbsp%3B%20To%20get%20the%20update%2C%20go%20to%20Help%20%26gt%3B%20Check%20for%20Updates%2C%20and%26nbsp%3Bupdate%20to%26nbsp%3Bversion%2016.18%26nbsp%3Bor%20greater.%3C%2FP%3E%0A%3CP%20class%3D%22contentStandard%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20now%20assign%20your%20own%20key%20combinations%20to%20many%20commands%20within%20Excel.%20Just%20go%20to%20the%20Tools%20menu%20and%20choose%20Customize%20Keyboard.%20Pick%20the%20category%20of%20command%20you%E2%80%99re%20trying%20to%20find%2C%20and%20then%20search%20or%20browse%20for%20the%20command%20in%20the%20list.%20Select%20a%20command%2C%20press%20a%20key%20combination%2C%20and%20see%20if%20it%E2%80%99s%20used%20already.%20If%20it%E2%80%99s%20already%20in%20use%2C%20you%20may%20want%20to%20pick%20a%20different%20combination.%20Then%20just%20click%20the%20%E2%80%9CAdd%E2%80%9D%20button%20to%20assign%20the%20key%20combination%20to%20the%20selected%20command.%20Read%20more%20details%20here%20-%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Farticle%2FCreate-a-custom-keyboard-shortcut-for-Office-for-Mac-6bbeb90e-96d9-4e03-b199-fc026ebdc321%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ECreate%20a%20Custom%20Keyboard%20Shortcut%3C%2FA%3E.%26nbsp%3B%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F57942iDEDB777B0AC50B78%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screen%20Shot%202018-10-22%20at%2011.09.35%20AM.png%22%20title%3D%22Screen%20Shot%202018-10-22%20at%2011.09.35%20AM.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Escreen%20shot%20of%20Customize%20Keyboard%20in%20Excel%20for%20Mac%3C%2FSPAN%3E%3C%2FSPAN%3E%3CBR%20%2F%3EWe'd%20love%20to%20hear%20your%20feedback%20about%20this%20feature%20and%20of%20course%20we%20want%20to%20know%20if%20you%20run%20into%20any%20problems%2C%20so%20please%20click%20the%20Smiley-face%20button%20in%20the%20top%20corner%20of%20the%20Excel%20window%20to%20send%20us%20feedback.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-276459%22%20slang%3D%22en-US%22%3E%3CP%3EUpdate%20to%20the%20latest%20version%20of%20Excel%20for%20Mac%20to%20customize%20your%20keyboard%20shortcuts%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-276459%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBlog%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358183%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%20-%20customize%20your%20keyboard%20shortcuts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358183%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F11719%22%20target%3D%22_blank%22%3E%40Steve%20Kraynak%3C%2FA%3E%26nbsp%3B%20%26nbsp%3BI%20don't%20seem%20to%20have%20the%20customize%20keyboard%20option%20despite%20running%20excel%20for%20mac%20version%2016.22%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20add%20F2%20as%20shortcut%20for%20%22Control%20%2B%20U%22%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%26nbsp%3B%3C%2FP%3E%3CP%3EErik%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84661iB5F912BA17BC73A1%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screenshot%202019-02-28%20at%2012.56.22.png%22%20title%3D%22Screenshot%202019-02-28%20at%2012.56.22.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20382px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84662i66A63D030C191062%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screenshot%202019-02-28%20at%2012.57.16.png%22%20title%3D%22Screenshot%202019-02-28%20at%2012.57.16.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-332784%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%20-%20customize%20your%20keyboard%20shortcuts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332784%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F11719%22%20target%3D%22_blank%22%3E%40Steve%20Kraynak%3C%2FA%3E%2C%20Thanks%20for%20Sharing%20This%20Useful%20Information.%20It%20is%20a%20good%20idea%20to%20Create%20a%20Custom%20Keyboard%20Shortcut%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

There's a feature in Excel for Mac that many people have been asking for.  The "Customize Keyboard" feature is now available.  To get the update, go to Help > Check for Updates, and update to version 16.18 or greater.

 

You can now assign your own key combinations to many commands within Excel. Just go to the Tools menu and choose Customize Keyboard. Pick the category of command you’re trying to find, and then search or browse for the command in the list. Select a command, press a key combination, and see if it’s used already. If it’s already in use, you may want to pick a different combination. Then just click the “Add” button to assign the key combination to the selected command. Read more details here - Create a Custom Keyboard Shortcut
Screen Shot 2018-10-22 at 11.09.35 AM.pngscreen shot of Customize Keyboard in Excel for Mac
We'd love to hear your feedback about this feature and of course we want to know if you run into any problems, so please click the Smiley-face button in the top corner of the Excel window to send us feedback.

2 Comments

Hi @Steve Kraynak, Thanks for Sharing This Useful Information. It is a good idea to Create a Custom Keyboard Shortcut.

Occasional Visitor

Hi @Steve Kraynak   I don't seem to have the customize keyboard option despite running excel for mac version 16.22 ? 

 

I would like to add F2 as shortcut for "Control + U" 

 

Kind regards, 

Erik

 

Screenshot 2019-02-28 at 12.56.22.pngScreenshot 2019-02-28 at 12.57.16.png