Feedback by UserVoice

How can we improve Excel for Mac?

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!

287 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

AlexK shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

64 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • [Deleted User] commented  ·   ·  Flag as inappropriate

    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.

  • Landon commented  ·   ·  Flag as inappropriate

    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.

  • BrianC commented  ·   ·  Flag as inappropriate

    I have Command-Option-i set as a MAC OS X keyboard shortcut to the Excel menu item Insert-Copied Cells. When I first press this key nothing happens. If I move the cursor up to the Insert menu and click Insert the menu drops down. Frustratingly, the menu item actually reads "Copied Cells" and my shortcut key combination so apparently Excel knows about the shortcut but refuses to execute it. Anyway, next I release the mouse button and the menu snaps back up. No menu item was selected, I only clicked on Insert then released. Now the keyboard shortcut works.

    I have the same problem with a shortcut Command-Shift-d set to Delete. Nothing happens with this shortcut until I toggle the menu.

  • Richard Widman commented  ·   ·  Flag as inappropriate

    There are many practical macros I run that I have had on the tool bar for many versions of Excel (user since version 1.2).
    Give us back the ability to put buttons there to run the macros.

  • John commented  ·   ·  Flag as inappropriate

    So true. I used the Office 365 trial but have gone back to 2011 in order to use basic shortcuts such as 'Paste Values' which I use all the time.

  • Aaron I commented  ·   ·  Flag as inappropriate

    This was the most useful feature of Excel 2011. It allowed you to perform nearly any necessary function through custom shortcuts, eliminating the need to transition back and forth from keyboard to mouse.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Under format cell you can program the cell to change color when a specific number, letter or word, is entered into the cell. I use this all the time when making a schedule for my department.

  • Michael I commented  ·   ·  Flag as inappropriate

    the default paste values shortcut on excel 2016 for mac i believe is ctrl+cmd+v - how is one supposed to even press this with their left hand (since we is typed by the left hand) without looking at keyboard??? has anyone actually thought about it when designing these shortcuts? why did't you make like 5 keys that user is supposed to press with one hand... really ridiculous...

  • Michael I commented  ·   ·  Flag as inappropriate

    what an idiot removed this feature???? especially on a mac - i am sitting and wasting a shitload of time on trying to find and customize keyboard shortcuts instead of doing necessary work!!!!!

  • DP1604 commented  ·   ·  Flag as inappropriate

    We've lost the ability to Customise the Toolbar... AND Keyboard Shortcuts are, at best, limited; bye bye functionality for the vast majority of users!

    Surprise, one size does NOT fit all - many users have particular functions they use repeatedly in their day, making the ability to customise the toolbar or make custom keyboard shortcuts very desirable (I feel "essential")

    I can't believe how much impact this loss of functionality has had on my productivity - I've taken the time out from work to add to this and other Forums, don't worry I'll catch up with my work by using Office for Windows on my laptop; it's so far ahead of the Mac version in many ways, not least in having MY buttons and shortcuts available

  • Jeff Chapman commented  ·   ·  Flag as inappropriate

    I completely agree with the need for an intuitive way to assign Excel commands to keyboard shortcuts in Excel 2016 for Mac, especially those commands not found in the menus. This was available in Excel 2011 for Mac, and is now inexplicably missing—completely!—from Excel 2016 for Mac.

    For instance, I was previously able to assign Command + Shift + ; to zoom in on the worksheet. Now that this option is completely unavailable, there is no quick and effective way to zoom in and out on an Excel worksheet by using the keyboard.

    This has sadly resulted in a drop of productivity. It is not a changed feature—it is a complete loss of functionality. It is available in Word 2016 for Mac, but missing in Excel.

    I strongly request for the development team to do their best to bring this back ASAP. An upgrade should not result in basic losses of functionality and inconvenience for users like this.

  • Neal Sofge commented  ·   ·  Flag as inappropriate

    Yes, please bring back this incredibly useful feature, along with the ability to delete shortcuts we don't need.

  • Anonymous commented  ·   ·  Flag as inappropriate

    OS X keyboard shortcuts work by matching a string in a menu item. This will not always work with Office for two reasons: 1) Office menu commands are not consistent and are not always unique strings; and 2) Many commands that I was able to customize in previous versions of Office are not available in the menus (e.g., Excel Delete Row).

  • BrianC commented  ·   ·  Flag as inappropriate

    I created a macro to paste values and assigned a shortcut to it. Unfortunately macro shortcuts only accept Option+Cmd.

    Sub PasteValues()
    '
    ' PasteValues Macro
    '
    ' Keyboard Shortcut: Option+Cmd+v
    '
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
    False, Transpose:=False
    End Sub

  • AlexK commented  ·   ·  Flag as inappropriate

    We all hope, that you'll fix that! This feature really HELPS! :)

  • Anonymous commented  ·   ·  Flag as inappropriate

    Guys seriously, it's so annoying. And yes I do have the latest version, and no it doesn't go far enough in this area.

    At least have an option for this. So with one option I can make all the shortcuts the same as on windows.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I'm missing this feature too! The way described in previous post does not substitute this option!

Feedback and Knowledge Base