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
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

138 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. 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
  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
  4. Anonymous
    2015-09-23T00:01:30+00:00

    I probably could lose some of the items since I know the shortcuts to most of them but I share this toolbar with my colleagues because they are not prone to learn shortcuts.

    I have common use features on the Quick Access so I don't have to switch tabs (it increases screen size for the spreadsheet as well), I will probably have to be more select about which features to have there and just use the shortcuts.

    Was this answer helpful?

    0 comments