How to reduce the size of quick access toolbar icons? (Office 2016)

Anonymous
2015-09-22T22:39:10+00:00

With the update to Office 2016 the Quick Access Toolbar icons were enlarged.

I used to have a filled Quick Access toolbar for Excel and now they do not fit defeating the purpose.

Is there any way to reduce the size of Quick Access Toolbar items?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
Anonymous
2015-11-05T18:00:03+00:00

Folks, our shared UX controls team have been following this thread, as well as your requests on UserVoice and are spinning up some work to address your concerns. I can't promise a specific date for getting this work out to you all, but they recognize the impact this has had on those of you who work with customized QAT and are moving very quickly.

When they're done you'll see the improvement arrive as part of the regular updates we send all subscription customers.

Thanks again for the clear feedback, both here and on UserVoice - keep it coming!

Cheers...pc

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

138 additional answers

Sort by: Newest
  1. Anonymous
    2015-09-23T21:55:37+00:00

    Dan - yes, agree that changing text size for this doesn't make sense, I've edited my initial post to remove this. I understand your frustration with this, but do consider the other suggestion - taking the most frequent things that you do and mapping them to keyboard short cuts, this will potentially free up enough space for the remaining icons.

    Thanks for the feedback...pc

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2015-09-23T20:29:10+00:00

    It seems to me the reason for the enormously wide QAT icons is to facilitate people using touch screens.

    I read somewhere that many of the changes to 2016 were geared to touch screens.

    So the 85% of us NOT using touch screens are out-of-luck.

    I have 23 icons in my Excel QAT that is above the ribbon.

    Putting the QAT below the ribbon takes up even more space.

    This new spacing drives the available space one would use to click and drag to reposition the window all the way to the right.

    "Try changing the way the entire rest of the display looks"

    and

    "Try customizing the bloated ribbon feature you're already avoiding"

    are not solutions

    A "Not Helpful" link would also be appropriate

    -Dan

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2015-09-23T17:02:28+00:00

    I'm sorry this change has impacted the way you work. I was able to get 26 icons on my laptop screen (2560x1440 and text size set at 200% in Windows) and 37 on my desktop screen, how many do you have in Excel 2013? What is the screen resolution/text size that you are working with?

    Now I understand a little more about what you're using the Quick Access toolbar for (to avoid tabbing through the Ribbon to find the commands most relevant to the way you use Excel), I have another suggestion that might help (but as it involves customizing the ribbon) it assumes that you aren't closing the ribbon.

    See: https://support.office.com/en-US/article/Customize-the-ribbon-in-Office-00f24ca7-6021-48d3-9514-a31a460ecb31  

    You can't change the order of the built in tabs, but you can add groups to them, and then export the customization for easy sharing with colleagues.

    Again, apologies for this change impacting you, hopefully the workarounds I've suggested will help...

    ...pc

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2015-09-23T12:45:43+00:00

    I share this problem. It has ruined the functionality of the quick access toolbar. This is not an improvement and should be returned to the prior buffering size or at lease we should be given the option.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments No comments