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]
Like others here I don't understand why MS doesn't let you control the icon spacing. I would vote for a customization setting button in the QAT dialog for adding the horizontal separation spacing for QAT buttons in pixels. I can do something similar with the taskbar icons using Ultimate Windows Tweaker and it works fine for just the taskbar (regardless of my scaling factor set in my Win Surface Pro 3).
I believe that this is clearly yet another example the MS philosophy of "less is more." MS has been on a mission to dumb down the interface of Win 10 into huge icons and take away user control so they can "save money" by not answering tech questions that come from users that have customized their precious Win 10 environment. I would gladly give up my rights to call MS in exchange for allowing a few reasonable user customization options to the MS Office environment. Of course this goes against their maximum profit vision of everyone running "their" version of MS Office (including the OS itself) from the great MS cloud in the sky and paying license fees yearly forever. It's what they really want and it's why their stringing along all of the user's complaints... or ignoring them for years.
David Staudenmeir commented
It seems each "upgrade" is really a downgrade - less efficient, harder to read and navigate, more screen real estate devoted to icons, etc. that don't need them, and overall, a re-shuffling of all the plumbing so that it's more difficult to find things each time around. Is it at all possible to not fix what isn't broken? Please??! Our firm just "upgraded" to Office 2016, and the QAT in Excel is, as others have said here, a big step backward. I can't believe that paid people at MS actually spent (wasted) time redesigning and re-coloring all the little icons used when selecting an icon for use with a macro or command in the QAT. Excel 2010 was just fine. Can you possibly add any upgraded functionality to the existing display and navigational scheme without having to move and redesign everything else each time around? That would be like having a part in your car upgraded, but having to repaint and redesign the rest of the car inside and out just to do upgrade.
Can you hurry? Since the QAT, I've ALWAYS been able to add whitespace at will with the spacer. I'd like to be able to REMOVE it too!
It's frustrating to be unable to see all my "quick access" buttons but be able to see lots and lots of white space between.
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.