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 -
Also, it seems that most of the shortcuts simply don't work regardless of how many key combinations I try. AutoSum, for example, works fine with the default (CMD + SHIFT + T), but I cannot re-assign it to anything else. I have tried re-starting excel and the shortcuts still don't work. Has anyone had any success actually using this new feature?
Is it possible to change the shortcut for editing the active cell. By default, this is done with F2 or CTRL + U. They both work, but I want to change the shortcut to something else. This seems like one of the most important and basic shortcuts and yet it looks like you still can't change it. I feel like I'm going insane.
No - wait, it's back again. Conspiracy theory. They were watching me the whole time, saw my comment and put it back. (Or some major restart restored it)
Have they taken this away? I go to the tools menu and there is no menu for customise keyboard. Pretty sure it was there before? (Why do I feel like I'm living in 1984- the book)
Roy, that Gateway keyboard (requiring PS/2 port and Windows software)is not compatible with Macintosh.
Your post should not be in this 'Excel for Mac' section.
MS DOES offer something, though it is a Windows thing that you could use everywhere, not Excel-centric.
If you want to define your own keystrokes into single key presses (AND I DO WANT TO VERY MUCH... Gateway 2000's Anykey keyboards were God's gift to mankind), you need to look into gaming keyboards (the reason you die when attacked no matter how fast you hammer a key to fire is the other guy bought one and is firing literally as fast as inhumanly possible, no missed microseconds) and they actually solve the Anykey's problem of stepping on itself. And you can load, and replace with a new load, sets of macros to fit the program you are using at the moment. Or have several just for Excel. But those keyboards... they're $200...
To get window switching and mouse movement and events and all the timing adjustable, along with keypresses, available at a single keypress, you need what MS offers, or a third party macro package.
None of those things will be programmed into Excel specifically. Count on that. Especially with the functionality already "readily" available outside Excel. Kind of.
Hence ol' Admin's useless comment, by the way:
"Gee, we solved that for you by not having anything at all that you are talking about! Find something else to whine about!"
I'm baffled. This doesn't appear to be anything but keyboard shortcuts for stuff in the ribbon. Those of us that asked for this asked for one reason: to make excel work like it has since the 1980's. But to the best of my understanding here, I can't use this to make a keyboard shortcut for fill down (command-d since the 80's, mapped to control-d since excel 2001 I think), something I use every day. This is not an esoteric command. What else is beyond my ability to correct? We don't need the ability to create keyboard shortcuts for the ribbon, we need a way to keep the speed of our workflows. How is this so hard to understand?
And for Office Mac 2016? T_T
Fantastic news, Steve! Thanks!
In response to Joel's question - there is no preset to revert back to defaults from prior versions.
Thanks Steve, is there a preset for all keyboard shortcuts to revert to Office 2001-2011 defaults? (And by extension, the same keyboard shortcuts (mostly) going back to at least 2.2a)?
David Charlap commented
I completely agree with the others here. I've got over a decade of muscle-memory built up from using Excel since Office 2004. In 2016, quite a lot of the keystrokes I'm familiar with have changed, forcing me to unlearn all kinds of habits and for no apparent reason other than some vague attempt to align with the Windows version.
And removing the ability to customize the keyboard is just adding insult to injury. I have been using a shortcut for "paste special as values" for years and there is no way to do this in 2016.
As for using Alt to navigate the ribbon, that's not very important to me. It may be useful for those migrating from Windows, but what modifier key could you use for this? On a Mac, the "alt" key is "option", which is used for composing accented characters and for entering other non-alphabetic characters. Disabling that capability would be a disaster and would anger just about everybody who doesn't live in the United States. Not an acceptable trade-off unless you also provide a preference to completely disable this "feature".
a million times yes. Please bring back Alt key actions.
Back on excel 2011 I was able to customize and modify the keyboard shortcuts to whatever I use most often, for example I use "Paste Special Value" a lot so I created a simple keyboard shortcut for it. I don't understand why this isn't allowed on the 2016 version since I'm assuming everyone using excel would love to be able to easily customize the keyboard shortcuts to what they use most often, the keyboard customization through OS X keyboard preferences absolutely doesn't work and doesn't make any sense to do it that way. Please return this function to 2016 excel!
Hi Steve. This is Rob. You know the one (color palettes, wandering tabs, etc). :)
I'm not sure I fully understand the suggestion, but I'm with Joel: What's needed is the ability to assign our own keyboard shortcuts to anything in the Menus or Ribbons.
For example, right now it's literally impossible to assign a keystroke that toggles Trace Precedents on/off. It's possible, through System Prefs, to assign the key to turn them on (although in my experience, it doesn't always work), but using that same key combo doesn't turn them back off, as it did in previous versions of Excel.
Another example: The same problem exists with Protect Sheet. You can assign a key through Sys Prefs to turn protection on, but once it's on, the menu item changes its name to "Unprotect Sheet," and if you assign the same key combo to "Unprotect," it doesn't work.
Then there's the problem of Excel having changed the keystrokes for certain features to ones that don't make as much sense, so I want to reassign them to my own choices. For example:
CMD + OPT + [minus key] for strikethrough (been using for 10 years) instead of CMD + SHIFT + X
As near as I can tell, assigning your own key shorties in Sys Prefs does *not* override the Excel's hard-coded keystrokes, so we're stuck with Excel's choices.
So in short, the return of Tools > Customize Keyboard is definitely preferable to any other options.
Well said Joel
Honestly alt/option access to the ribbon is not important to me and I doubt I'd use it. Restoring the ability to use the same keyboard shortcuts I've used for 30+ years is critically important to me. There is no more important feature request for me, period. Anything that slowed that down i would say no to.
Mr COSSON HUBERT commented
C'est une très bonne chose de personnaliser le Ruban, utiliser le paramétrage des touches de raccourcis-claviers, augmenter la Taille des Caractères
personnaliser le mode d'impression . ( en bleu si nombre positif, en rouge si négatif et Noir
pour valeur Zero . Etc
The ability for us to program our own key combinations would be best. This is an urgent feature though, now that 2011 is not a happening thing under High Sierra.
The use of the Option key (not ALT, Option !) might help some people, but this has not much to do with Keyboard shortcuts customization (which is really needed)!