Changing the Ribbon's Size and Look

by Allen Wyatt
(last updated February 11, 2019)

1

Brian is a member of a club that teaches computer skills to senior citizens. He has a new student who is sight impaired. Despite copious amount of searching he has been unable to discover any means of changing the look and feel of the Ribbon to make it easier for the student to use. Brian wonders if there is a way to modify the Ribbon's size and look.

There are a number of approaches that can be taken. The first is to skip making any changes in Excel and make your adjustments in Windows. This may be the best overall approach as a person with sight impairment doesn't necessarily need help with just the Ribbon; the help is needed in all areas of using the computer.

If you decide to go this route, you should look at changing the color scheme used in Windows to provide more contrast. You can also use Windows' accessibility tools to add varying degrees of magnification to the area in which the mouse pointer is located. Color schemes and accessibility tools are all available through the Control Panel.

You might also consider adding verbalization tools to Windows or Excel. These allow a computer to "speak" what it on the screen so that those with sight impairment can actually hear what is on the screen. A good add-on to Windows is the JAWS software (you can search for it using your favorite search engine). Within Excel, you could consider adding the Speak Cells tools to the Quick Access Toolbar. When customizing the QAT, you can find it in the full list of available tools (there are several; they all start with the name Speak Cells).

If looking to specifically modify the Ribbon, Microsoft's Help system is pretty emphatic that "you cannot increase the size of the buttons," although it notes that you can modify the screen resolution within Windows to make the buttons appear larger.

That said, there are few tricks you can play with the Ribbon. You should, for example, consider adding the Touch/Mouse Mode tool to the QAT. This tool, available only in Excel 2013, provides the option to switch between an interface optimized for the mouse and one optimized for touch screen systems. The result of choosing "Touch" mode is that the tools on the Ribbon are spaced out more so they are easier to accurately touch with a finger. Even if you don't have a touch-screen system, the additional spacing is helpful for those who are sight impaired and using a mouse.

Finally, if you are using Excel 2010 or Excel 2013, consider adding a custom tab to the Ribbon that contains the tools used most by the user. This allows the common tools to be in a predictable location, which means it is easier to find the tools needed. In putting the custom tab together, you can add spacing so the tools aren't bunched up as much and therefore easier for a sight-impaired user to access.

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

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

Setting Default Attributes for Lines and Arrows

Don't like the way that Excel formats lines and arrows? You can easily make your own formatting changes, and then use ...

Discover More

Two Printed Copies to Different Paper Trays

Many modern printers include multiple paper trays that can be used for different types or colors of paper. Word allows ...

Discover More

Setting Program Window Size in a Macro

The macro programming language used in Excel gives you a great many tools that allow you to modify the way that Excel ...

Discover More

Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!

More ExcelTips (ribbon)

Problem with Missing Context Menu Option

When you right-click a cell, does it seem that the Context menu is missing an item or two? Here's how to get those items ...

Discover More

Turning Headers On and Off

Normally Excel displays row and column headers in a worksheet. If you prefer, you can turn these navigational aids off ...

Discover More

Adding a Little Animation to Your Life

Tired of the same old boring Excel look? You can add some life to your worksheets by introducing some animation. Here's ...

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

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 seven minus 4?

2015-08-01 05:37:38

Petros

Ribbon Commander is a framework for rapid Office UI development. It aims to both simplify and extend the existing XML-based programming model for the Office UI, by exposing a complete object model for the Ribbon and Backstage (while also fully supporting XML). It consists of:

Libraries (with projections for VBA, C#, VB.NET and COM-capable environments like VC++ and VB6).

Tooling: An ever growing suite of productivity add-ons for VBA and Visual Studio that aim to reduce development time even further.

The framework also allows dynamic manipulation of the Ribbon, which enables you to tightly integrate the Ribbon and Backstage with your application. And this is done without the complexity of managing call-backs (although they are fully supported and extended to include events and .NET delegates).

The Ribbon Commander framework integrate seamlessly with Excel, PowerPoint, Word and Outlook in Microsoft Office versions 2007 (32 bit), 2010 & 2013 & 2016 (32/64 bit).

http://www.spreadsheet1.com/ribbon-commander.html


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.