Bring back REAL keyboard customization!
It is completely not true, that keyboard customization through OS X keyboard preferences really works. Tell me how to make a shortcut to fill cell with color: for instance CTRL+2? Or how to paste values (without any mid-steps)? Or even do something more advanced than copy/paste with my own combination of inputs.
The fact is that office 2016 for mac lacks this feature and this "workaround" is NOT a replacement. Please bring back the option that was SO USEFUL!
Great news. This feature is now available in Excel for Mac (O365 and Office 2019. Read more about it here -
I'm missing this feature too! The way described in previous post does not substitute this option!
Robert Gama commented
Definitely need a way to get a keyboard shortcut for paste values.
Thanks Tom for your comment, I will definately try your solution, even I'm not so good at VBA or any other scripting - this feature was extremely important to me.
However I still cannot believe that they remove features that are usefull. They have finally fixed opening big xls files (they work much faster in 2016( but failed to provide important features from 2011...
Thanks and I hope they will fix that in the next update!
Tim Clink commented
AlexK: Well I can't argue that it would not be easier to customize the keyboard for complex actions directly within Excel... What I can do is offer you another option.
First, as you mentioned OS X has shortcut actions assignable via the keyboard preferences pane.
Second, these keyboard preferences can be used to trigger Applescripts.
Lastly, Applescript supports direct manipulation of the GUI including "scriptable" applications like Excel.
Now you may be thinking that the last thing you need to learn is another scripting language... and I'd agree as AppleScript has a very different syntax than your probably accustomed to in Excel with VBA. However, it should be possible to leverage the Applescript editor (or my preference ScriptDebugger) to "record" the script as actions are performed in Excel. Then tie your Applescript back to the keyboard shortcut in the prefs pane and you should be in business. Might be worth a try.
If it turns out that Excel 2016 cannot be recorded, don't give up. A recordable application in MacOS must be written to pass it's actions as events to the OS to be recorded. If it is not recordable, it is likely scriptable with a little bit of learning and effort. I believe there is even a Applescript call that allows you to run a VB Script within the workbook. In this case, you might prefer a editor like ScriptDebugger (Late Night Software) as it has a very good object and event browser to determine what the application supports. Comparatively Apple's own AppleScript editor looks at you with a blank stare expecting you to know what to type.
Hopefully this will help you to bridge the gap until Microsoft brings back some of the missing features.
Here are a couple of links that might be useful:
Jose Geraldo commented
where this the icon of printer in the applicatory ones of office 2016? It must have an icon of printing in the icons of fast access