The QAT spacing on the 2016 version is impossible to work with and forcing me to look at creating a new tab. I liked the spacing on 2013 which allowed me to view all my written macros and buttons. The new spacing pushed 5 of my buttons to a drop down. Please correct this spacing issue. The spacing does not need to be this large when you don't have a touch screen. I am one of 35 employees in my company that this effects. We have a customized QAT that all employees use.
This one is getting underway – we’ve been channeling the feedback to the core team in Office that owns that UI, and they’re working on it!
John [MS XL]
Its 2019 and still no fix to this issue!
MS and its Office team are working overtime to kill usability of their products!
Can't believe we had a better functioning software in previous versions!
Has this been fixed yet? I just want it to fit!
Got an update this morning that changed the size of QAT icons and went from 58 visible icons to 52. If MS has been working on this since late 2015, what happened 28 months later? From the sounds of other posts, I'm lucky to have had as many icons as I did. It's bad enough that every new version of Office takes several steps backward but now I can't count on the same functionality from update to update!
All of these comments, going back to early 2015 including replies from MS indicating this issue is being worked on. Where are the results please? I used 56 icons in Excel 2010 and now only get 33 of them in the (visible) QAT. And I'm not even starting to complain about the look & style, although it is only different and surely no better that let's say 2010. Come on!
Richard W. Memmer commented
"with grace and speed and a minimum of cussing the latest trend of minimalistic pablum"
Kudos to Glenn who so perfectly captured the absurdity of the design trends of our times.
The human eye can distinguish the flame of a single candle from 10 miles away. We don't need our vision patronized by style gurus who think that providing fewer and fewer tools and pieces of information is helpful. Puh-leeze. Allow us the privilege of complicating our lives, of arranging our tools as close together as possible, so we can stay in the zone and cruise our spreadsheets as nature intended, with grace and speed and a minimum of cussing the latest trend of minimalistic pablum. "Getting underway," you say? - 20 months ago tomorrow, that was offered up. What's the holdup?
Anonymous Californian commented
It's ridiculous how FEW QAT icons you can fit in Excel 2016. This leads to MORE clicking and LESS efficiency. WHY are you making my life harder and not easier, Microsoft?
just switched to Excel 2016. YIKES! totally agree
agreed, ridiculous that they keep changing stuff like this. Not everyone wants to touch screens, most people still use a keyboard and mouse
heavy excel user commented
The QAT icon spacing is too wide and so wasting space and so in turn efficiency and productivity. It will be good to be able to edit the icons themselves as you use to be able to rather than just use the stock selection.
Michael Williams commented
Maybe the QAT could be resized by the user to be more than one row high, in the same way that the formula bar can be?
Michael Williams commented
The company I work for (450 employees) has just switched from 2007 to 2013 & I have found this to also be an issue with 2013. I could fit a lot more icons on my 2007 QAT than I can on my 2013 QAT. Will this development also be rolled out for 2013 versions?
Sameer Bhide commented
@Excel Team : The QAT issue is fixed with the latest update - Great work !!!
However the XML for Font Type and Font size is now messed up
<comboBox idMso="Font" showLabel="false"/>
<comboBox idMso="FontSize" showLabel="false"/>
The showLable = "false" - has no effect the Label is still displayed !!!!
Sameer Bhide commented
Have exhausted my votes but please add +1 from end - The QAT is a disaster in 2016
Also reduce the amount of bleaching powder that you have put in Excel 2013 / 2016 - We are
more that happy with the look and feel of 2010
How does the Excel UI team manage to make each version look worse than the previous ?
Patrice F. commented
Hello all, I upgraded to Office 2016 and really struggle with the QAT icon spacing in all office apps (PPT, XL, Word, Outlook, One Notes...). My workflow is optimized with the QAT (which I also backup in case of troubles). More than one line is not good enough. I do not want to spend my time using CTRL + F1 to show or hide the ribbon and then click to access a customized one (as I read as workaround). We are in Jan 16 and the last updates are from 2 months ago. What ETA are we looking at for a reverse to the previous icon spacing when NOT in tablet mode? Thanks
This is a significant problem for me. I put icons on the QAT for commands that I want to be able to do with a single click. Roughly half of them no longer display in Excel 2016, which means that I now have to frequently do 2 clicks to get to them. Please, let people have the option of reducing the spacing of the items on the QAT.
Well, I'm just a home user with no macros in Excel (have some in Word), and I too hate the added spacing. I put several built-in items onto the QAT because I use them often and don't like to waste time scrolling through the ribbon choices for them. Not only have I had some buttons relegated to an inconvenient drop-down, but it's hard to find any free space to pick up the window and move it around. MS has essentially undermined the whole purpose of the QAT with this change (won't call it an improvement). Also don't like the new icons, but that's more an issue of aesthetics and familiarity.
I had to revert back to Office 2013 because of this issue and will not upgrade to 2016 until this issue is resolved. Who the hell would approved such a disastrous objective?
It is nightmarish. I had tweaked my office apps (word & ppt as well) so I could be really fast with the most used commands. Now each command requests additional mouse clicks & moves. Office 2016 has punished power users. thanks ! I so regret to have installed it.
Steven Welch commented
Spacing between the QAT items is too large. I appreciate this may have been brought in for touch screens so can an option be added that you can choose the spacing?