Allow Toolbar / Ribbon customization
the possibility to customize the toolbar or ribbon and adding custom buttons that start macros is vital for a efficient workflow when processing big amount of data tables.
June 16, 2016
Great news, with Mac Excel 15.23 you can now customize the Quick Access Toolbar (QAT) and Ribbon. This version started rolling out on June 14th, so look for an update if you don’t have it already.
Oct 31, 2015———————
Thanks for your feedback! Just a note to let you know that we’re building your suggestion now.
Eric de Rochefort commented
Well ... this is now february 2021 and QAT buttons are still greyed out (although functional) on version 16.35 up-to-date => what's the deal?
Was (and still is) working fine on Office 2011 (version 14. 4.5) => no can update to 64bits OS without downgrading functionalities over more than 10 years?
John K commented
This is the reason I returned to Excel 2011. I have a single, undocked, heavily customized toolbar with what I need on it. I had hope for the QAT, but I'm only able to put about 30% of what I need on it. And then I can't tell which macro is which.
I leave the ribbon off. I'm sure it did well in focus groups, but I'm guessing people like me weren't there.
Ian Page commented
The ability to add a custom toolbar - with custom icon and tooltip - is still lacking. And the Ribbon is a ridiculous space hog. I'm sticking with Excel 2011, and all of my clients are too.
So Microsoft think its solved the problem. No. !!?!
QAT still doesn't offer customised icons or tooltips for macros !!?!
Previous versions of Excel had it!!
You can add macros to the QAT. However you cannot give them an icon or a name!
So the all appear as circles and you have to guess which is which. Not even a tooltip to help you.
I have tried to access ribbon & tool bar in preferences and it keeps crashing excel on my mac.
I'm running: Yosemite 10.10.2 and excel 15.38 on a macbook pro.
Does anyone know why i can't run ribbon & tool bar preferences?
Tobias Bußmann commented
Great to hear this is implemented. However the feature is only available to Office 365 subscribers. Being a user of a Volume Licence we are at a complete loss now. It seems not to be possible to 'update' or 'renew' the licence, not even for a fee. I wonder what one would get if we would buy a new volume licence now?
The QAT customisation is unfinished. You cannot add many commands (e.g. Paste Formatting, or Paste Values). The Commands shown in the customisation screen are inconsistent...for example Commands are shown in the Not in the Ribbon list which do not appear in the All Commands list. Go figure! The icons are in grey, so it is very difficult to differentiate them....although I'd live with that if they'd just let me add the commands I want to.
These are fundamental productivity tools to many Excel users as they save multiple clicks and scrolling. This customisation (or its equivalent) have been around through the many versions of Excel over the years. Seems crazy - or perhaps just lazy - to me that MS have dropped it.
Deal breaker for me - the lost productivity wipes out the 64 bit release and speed gains. I continue to stick with good ol' 2011. (Which works on El Capitan BTW - sympathies to the user on this thread who jumped through the hoops to downgrade).
Yes, thanks! The only problem I have now is that when I add Macros to the QAT they have no tooltip so I can't tell which circle icon is which macro. If I try to Rename the macro entry in the QAT setup it prompts for a name and then resets to no name when I click Apply.
Earlier version used to allow customizing of the ribbon to add additional commands.
Peter Smith commented
The long overdue ribbon customisation is great but some of the basic commands are missing. E.G.
Format painter button (copy formatting button)
Font colour button
Fill Colour button
Also it would be useful if appearance of buttons in the quick access bar was the same as in the ribbon bars
I would especially like the "lock cell" button to be an option. Or if you could, just imitate the customize ribbon function in Windows.
Please add ability to create custom toolbars in Excel 2016 and to pin custom toolbars in 2011.
The latest update of Excel 2011 for Mac (v14.6.4) will allow me to create custom toolbars, but they aren't fixed to an existing ribbon or toolbar as in prior releases (which I liked because I always knew where to find it). Now when I open excel, I'm forced to move the open window around to see where the floating custom toolbar resides. Is there a way to lock a custom toolbar so it always shows up in the same place within Excel regardless of which file I open?
I see a resolution to this problem (significant shortcoming if you ask me and most users I talk to!) has been cited as "Started"... on October 02 2015. Any ETA on it?
I can't help feeling a lot of other problems and issues listed on this and other forums I visit would be resolved if we could get the functionality into the Toolbar that Windows users enjoy (I use Office for Windows on my laptop, the difference between the two versions is mind boggling)
Adding a button to do those multiple step processes makes a BIG difference to User efficiency AND enjoyment; I didn't realise how much I used them until the "upgrade" shone the spotlight on the glaring disparity between Office for Windows and Office for Mac.
If Microsoft market this product to Mac users, it should provide the same experience as it does for PC users; otherwise don't call it Office for Mac - call it what it is Almost-Office for Mac
Please add the ability to customize the ribbon
Jim B commented
Please add the ability to customize the ribbon, including the ability to add a custom button to run a specific macro.
glad to see the problems with less votes are getting addressed before the higher voted items..........
Excel 2016 Mac is the worst "upgrade" I have ever purchased. This is a massive downgrade. This app is now SLOW and fundamental user productivity features (customizeable toolbar) have been removed completely. Even simple prior productivity features such as the ability to option click row or column headings to insert blank rows or columns has been removed. Miserable. MS clearly does not respect its' customers.
Walt Mullon commented
Would really like to add the strike-through button to the quick access toolbar. Why is this currently impossible to do?
I have been using Excel from day 1.... Love it!
Can not comprehend how Microsoft removes well established and well used features, then call is a new release. I need to customize my ribbons to group all of my often used in one area. Simple?
About 2 years ago, bought Office for Mac and that is when I began to see that the Mac version had missing items, felt like a second class customer.
Please fix this.