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]
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?
Jon Peltier commented
While you're at it, why not restore color to the QAT icons.
The spacing between the quick access toolbar icons is so large, only 10 show on the same window size that 20 or more used to show. Not helpful or productive to keep having to use the More Controls command.
And allow it to warp to a second+ line too, and then you don't have to waste screen real estate with that damned Ribbon...or ideally go back to how it was in 2003 (Menu function, drag and drop items onto/off QAT, no ribbon)
Xiaolun Cheng commented
Please give us control over the spacing between icons. Considering most of us who use Excel the most frequently are on a desktop, some optimized layout for desktop is really needed.
winston snyder commented
Give us greater control over look and feel of the QAT. I like a minimalist format - think Stardock Minimalism. Others will want to zoom in and make the icons bigger.
Ron Stransky commented
the icons for quick access got TOO LARGE in 2016, please put that back the way it was in prior versions. It was slightly comforting that if I moved them back ABOVE The tabs I got at least a little space back. Give us the option of using narrow icons or something, please
I have nearly 50 QAT icons that I use and on the new Excel, I can only see a very small amount. The spacing is pretty ridiculous and makes the QAT wayyyy less useful.
I was just forced to download the 2016 version (since the 2013 stopped working unexpectedly) and the large spacing has really frightened me - it's unusable... In Excel, I have just 23 shortcuts and they don't fit!
Could you please give there at least an option for shrinking the QAT for those of us who don't use touch screens? Multiple QAT rows wouldn't be a good solution since all the "obligatory toolbars / ribbons / whatever" on top already take quite large space.
Thanks a lot for a quick solution!