Enlarging Icons on the Quick Access Toolbar

by Allen Wyatt
(last updated October 17, 2019)


Eyesight isn't what it used to be? (I know mine isn't!) If you find yourself squinting at the screen, trying to see the teeny, tiny icons that appear on the Quick Access toolbar, you may be wondering if there is a way to enlarge those icons.

The short answer is that there is no way to make such an enlargement. According to the helpful information provided by Microsoft, the only way to enlarge the icons is to change (lower) the resolution used to display information on your screen.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8882) applies to Microsoft Excel 2007 and 2010.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...


Using the WEEKNUM Function

Need to know which week of the year a particular date falls within? Excel provides the WEEKNUM function so you can easily ...

Discover More

Hiding Individual Cells

Hiding information in one or more cells can be a challenge. This tip presents several different techniques that can help ...

Discover More

Counting Names Based on Two Criteria

Need to figure out how many rows in a worksheet meet two criteria that you specify? Here's how to get the info you desire.

Discover More

Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!

More ExcelTips (ribbon)

Adding a Macro to the Quick Access Toolbar

The Quick Access Toolbar is a great place to put anything for which you want quick access. (Duh!) Here's how you can add ...

Discover More

Backing Up Quick Access Toolbars

The Quick Access Toolbar is a place where you can easily put your customizations. If you want to back up that toolbar ...

Discover More

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.


If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is three less than 3?

2020-10-10 08:00:39

Peter Z

I would just like to thank you for your tips and the excellent help that you give. I know that I speak for many, many others.

Whenever I'm stuck with, particularly Excel and excel VBA coding, and I search the web for a resolution, my first move is to scan the hits to see if excelribbon.tips.net appears. If it does, I need look no further.

That's where I know that I'll always get reliable, relevant advice, expressed in clear, unambiguous terms, with all the steps needed to resolve the issue. And often there'll be a side gem or two to enhance the core advice.

Thank you ever so much.

2019-10-18 11:32:18

Peter Atherton

Sometimes the tip ay not what you need but the comments are always worth reading. Have a look at Kirk's tip 12th Dec 2014 and the reply 21 Aug 2017 by newyears1978

2019-10-17 10:01:33


I look forward to these tips and for the most part they are great reminders of things I have forgotten about over the years.
I can't help but laugh at this one.... This tip was written in 2014 and is just as unhelpful now as it was then.
Not to mention, the problem has been around that long and Microsoft isn't listening.

Why put a tip, just to say you can't do something? (At least add "You Can't" in parenthesis or something)

2019-10-17 03:48:48

Natalie Kehr

Surely we need to learn to use the keyboard shortcuts. Write the number of the icon in large print on a post it note, then simply use Alt followed by the number. It might be helpful to re-arrange the order of the icons so that Alt 1 is the one that is used most frequently. Alan could provide the detailed instructions showing how to do that rearrangement

2017-08-21 13:28:07


Kirk's idea works, but not if you use Outlook at other apps because then the fonts in those apps are way too large.

Shame Microsoft can't fix this simple thing making the quick access more customizable..but I am not surprised. Microsoft stinks.

2015-01-20 10:18:37


Great tip from Kirk! Thanks so much!!!

All my documents are internal and I use only the most basic functions so all these "bells & whistles" are distracting and inconvenient. I was spending too much time hunting for the functions I needed.

After enlarging the icons I customized the QAT, moved it to appear beneath the ribbon and then hid the ribbon.

When I do need to use the ribbon it annoys me less now that the icons and font are larger.

2014-12-15 01:25:59

Shreepad S M Gandhi

Thanks for the sharing. It is really helpful.

Follow Kirk's comment word by word. I tried it. It really is a good tip.

2014-12-12 10:17:29


I found a way to make the QAT larger.

Go to: Control PanelAll Control Panel ItemsPersonalizationWindow Color and Appearance

(The fastest way to get there is to right-click on your desktop, select Personalization, and the select Window Color)

Select the link for Advanced Appearance Settings

Under the Item drop-down box, select "Menu"

Increase the Menu size to 25 and the Font size to 14.

This will increase the size of your menu, as well as the QAT. You can tweak to your preference. Enjoy!

2014-10-14 17:54:37


MS has added dozens of "bells & Whistles" to excel, making it so complicated that perhaps only a small % of users use any of it.
It's beyond my understanding why they can't take a simple item like the QAT and make it as cool and snappy as the older versions......Unbelievable !!

2014-06-06 21:18:58


Today I discovered its a bit more comfortable to set the QAT to "Show Below the Ribbon" instead of "Show Above the Ribbon".

2014-05-22 15:49:57

Surendera M. Bhanot

The icon in the QAT come with the Tool Tips. You just hower you mouse pointer over an icon in the QAT and the Tool tip tells you what it is. so its not that 'pain in the ass' as has been made out.

2014-05-22 11:56:00

Morris Manning

Kathy, I would make an list of functions you want in your ribbon on paper first and group them logically and give each group a name. Then right click the ribbon and select "Customize the Ribbon". In the right pane at bottom select "New Tab". Right click New Tab and give it a name eg "MyTools".
Highlight New Tab and select New Group. Give this New Group a name depending on the items to be included eg: Rng Mgmt or Data Mgmt. Using Data Mgmt as an example, highlight Data Mgmt. Go to left pane and find Sort Ascending. In this case it is found under the Popular commands. Using the Add button, move to the Data Mgmt group. Some functions may be found under other catagories such as Commands Not Found In Ribbon. This should get you started.

2014-05-22 11:54:26


If you want to 'play' with the Ribon, a good place to start is here: http://www.rondebruin.nl/win/s2/win001.htm
It may take a while but once you understand the way it works you can create you own custumized evenvironment.

2014-05-22 11:34:15

Morris Manning

I recently switched from Office 3 to 10 and find ribbons useful in some ways but maddenly irritating in others. Many icons are overly large. Can't rearrange or otherwise customize.

I made a ribbon with my favorite tools but it suffers from issues. The snaking nature of ordering icons, along with small and large icons and the way text is displayed, makes it impossible to get a visually pleasing product.

For those, like me, who desire to customize our work envirnment, the QA toolbar is an improvement but a pale imitation compared to the customization possible in Word or Excel 3.

Improve QA toolbar by allowing more than one bar. As suggested, sharper dividers and slightly larger icons. I would also opt for more color contrast in many of the icons: The pale color pallet is not condusive to making fine distinctions in small items.

I employ a lot of macros attached to buttons. The tiny selection of icons is almost useless. If MS would add an icon editor and access to the full array of Office icons I would be happy.

2014-05-22 10:00:30

Kathy R.

Kathy B., could you explain how to make your own ribbon with the items on your QA toolbar? Thank you

2014-05-22 09:24:04

Steve N

Excellent suggestion. You just have to be careful when creating this as it was easy to reset my QAT at the same time.

2014-05-22 08:55:51


I keep the Magnifier on my toolbar for situations like this when I need to enlarge just one (or a few things). It makes it easier to see the very small icons without enlarging the entire desktop!

2014-05-22 07:11:33

Kathy B

Even though you can't increase the size of the icons on the QA toolbar, did you know you can make your own ribbon (in 2010 and 2013 versions) with the items on your QA toolbar? The icons on your custom ribbon are larger and easier to see.

2013-06-06 17:22:35

Bill I

Now I know why I am still using an older version of xcel. This one is anything but user friendly.

2012-11-19 17:46:22


Please Microsoft do something about enlarging the QA Bar icons!!! And while you are at it: Give the Separators a bright color and more width!!!

2012-11-05 14:55:22


I agree with Carol. Microsoft needs to rethink user-friendly, use-ability!!!

2012-11-03 16:19:46


I'm not happy. My vision is very poor and the option to change resolution will only make the entire screen less crisp.

2012-02-21 12:44:40

Joan Thompson

If I change my resolution, as suggested, it also changes things in my other software. Is there a way to only change the resolution of Excel?

This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.