Enlarging Icons on the Quick Access Toolbar

by Allen Wyatt
(last updated May 22, 2014)

18

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

MORE FROM ALLEN

Disappearing Toolbar Buttons for Macros

One of the important configuration files for Excel is known as the XLB file. You should periodically make backups of this ...

Discover More

Printing Multiple Selections

Need to print several portions of a worksheet all on a single piece of paper? Here's an easy way you can get what you need ...

Discover More

Changing the Ribbon's Size and Look

The Ribbon, while debatably handy, can be downright difficult to use for those with a sight impairment. Here are some ideas ...

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

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 info, ...

Discover More
Subscribe

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

View most recent newsletter.

Comments for this tip:

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. 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 nine minus 3?

2015-01-20 10:18:37

Susan

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

@Kirk,
Thanks for the sharing. It is really helpful.

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


2014-12-12 10:17:29

Kirk

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

Doug

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

Tony

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

Erik

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

Pat

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

BWH

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

Joan

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


2012-11-03 16:19:46

Carol

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
Subscribe

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.

Links and Sharing