How to customize keyboard shortcuts in Excel for Mac 2016

I would like to set a key shortcut (ctrl+q) to the trace precedents option. 

How can it be done in the new Excel for Mac 2016?

Thank you for your help.

|
Answer
Answer

> Just looking to insert and delete cells/rows. <

According to the article "Keyboard shortcuts in Excel 2016 for Mac" at

https://support.office.com/en-us/article/Keyboard-shortcuts-in-Excel-2016-for-Mac-acf5419e-1f87-444d-962f-4e951a658ccd

Insert cells

CONTROL + SHIFT + =

Delete cells

+ HYPHEN
or
CONTROL + HYPHEN

On my system, OS X 10.10.5, Mac Excel 2016 version 15.16, these same keyboard shortcuts work both for cells and for rows.

Thanks Mike Middleton

Yes, I know this short cut but it is clumsy.  I would like to assign keys to my own short cut keys.  As a number of contributors have complained, this functionality has been withdrawn by Microsoft.  I tried the universal apple preferences route to get my key stoke preferences (ie Apple preferences, Keyboard, shortcuts...(but this does not work.

I think I will got back to Excel 2011 and give this defective version the flick.

3 people found this reply helpful

Was this reply helpful?

Yes
No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated February 9, 2020 Views 9,962 Applies to: