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 -
Overall I am extremely disappointed in Office 2016 ... as it has increased my workload by over 20% ... because shortcut features are not the same as Office 2011
I read that you think you have fixed things (as a COMPLETED ITEM) when you say we can now use the iOS system of creating shortcuts ... but it is limited and some shortcuts are not possible.
There are 2 shortcuts I would particularly like to have fixed:
2) Fill Color
Matt Hines commented
Yay! Will this be added in 2016? Or is it planned for the next version?
Steve, that is so wonderful. If I can add to it as you work, some of the commands (with or without keyboard) have disappeared too - e.g. Straightforward Paste Formatting and Paste Values instructions. Those and a regular toggle for Light Shading as a keyboard command would be excellent to have back again. (My use of those commands cannot be counted).
This will be SOOOOO good; it means I will finally be able to use 2016 for all my work, not 2011 for most of it and 2016 for the basics!
THANK GOD AND THANK STEVE K FROM MS EXCEL!!
Claire Sela commented
I just upgraded to Excel 2016 and the customize keyboard option is missing. i had very useful shortcut to paste as values an now i cant use it.
Just 'upgraded' from 2011 to 2016. I have keyboard shortcuts in my muscle memory from years of working with Excel. Why was keyboard shortcut customization removed?? And why is this suggestion to add it back under review for 3 years? I don't want to downgrade to 2011 but it looks like it's the only option. The mentioned option through System prefs is not working.
Joel Lingenfelter commented
I really do think decisions like this are made in a vacuum. Excel for the Mac was released in 1985. On the mac only. Some of us have been using the product nearly that long. In my case I started with 2.2a. Needing to work quickly I learned every keyboard shortcut that could save me time every day. When Excel 2001 came out and they remapped things like command-b to control-b it took a while to get my fingers to use the new keys, but at least the core ideas (b = clear) did not go away. Excel 2016 is the first time I've ever reverted versions (ok, to be honest, I skipped 5 because it was terrible).
2016 changes all the keyboard shortcuts I've memorized since 1989 and gives us no way to change them back. It's also prettier when moving from cell to cell, but slower. If you survey 100 excel heavy users as to what is better, fast or pretty, you will get 100 out of 100 saying give me speed.
I want to use excel 2016. Really. But the keyboard shortcut issue is an absolute deal breaker.
Joel Lingenfelter commented
We used the same keyboard shortcuts for 30+ years (with some modification adapting to the control key for some). And you changed many of them. And took away the ability to customize them.
THAT'S JUST MEAN!
I still use Excel 2011. Because 2016 slows me way down.
Allow Ribbon to be customized in the stand alone version of Excel.
Adding this option in a future update would be appreciated.
I am very upset that since I bought a stand alone version of Excel for Mac for $109.99 and not the 365 Subscription I can not customize the ribbons. This is just not right. Are there any other options that I can not use?
Also f3 for range name list in formulae building and pivot range definition
Great to see many features being added back to Excel 2016. Still looking forward to having this feature. Strange that it is absent in Excel but present in Word.
Luis Camacho commented
Real keyboard customization is a basic and very useful feature. You should definitely add it.
Mr COSSON HUBERT commented
Pouvoir augmenter la Taille des caractères dans le tableau situé sous le Ruban.
Avec ma mauvaise vue, j'ai du mal à lire les formules.
also F4 to toggle relative / absolute cell reference please!
What's nonsensical is that Word still has in-app custom keyboard shortcuts, and you can do things with them that aren't in the Menu Bar — unlike Excel relying on System Prefs, which only do shortcuts that can be found in Menus.
What kills me is that I've "upgraded" from Office 2008, and while Excel 2016 takes up THIRTY TWO TIMES more hard drive space, it's...
a) missing *basic*, common-sense features that were available in 2008 (keyboard shortcuts, formatting for comments)
and b) unstable as ****
I have a list of over 40 bugs I've discovered, and at least half of them are *really* bad — like basic rendering issues, keyboard shortcuts not working at all sometimes, and frequent bombs.
I've had a conversation with someone on the Excel development team, and I think most of these issues will *eventually* be addressed. But I really don't see what I'm getting for the extra GIGABYTE of disk space taken up by this "upgrade," other than a pretty UI whose "pretty" is causing many of the problems.
[Deleted User] commented
Customizable shortcuts for inserting values and inserting cells are badly needed, the default workflow is a joke. Setting keyboard shortcuts for Excel via preference pane in Sierra is not working.
Why has keyboard customization been removed in the first place? In a new program version, one would expect new features, not the removal of essential features. What a disaster. Sad.
There are missing key commands on the Mac version of Excel that I need to use. These features are exclusive to Windows Macs which makes it a complete hassle to work with Excel if you are a Mac user. Some features include the Quick Analysis, Find & Select, including such layouts as the Page Break layout.