Changing the Ribbon's Size and Look

by Allen Wyatt
(last updated August 1, 2015)

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

Unique Military Date Format

Some industries (such as the military) have special formatting that they use to represent dates. Here is one such format and ...

Discover More

Adding Titles to a Chart

Adding titles to either an axis or the chart as a whole can make your data easier to understand. Here's how to add this ...

Discover More

Moving Through a Table in a Macro

Do you need to step through a table, cell by cell, in a macro? It's easy to do using the Move method, as described in this ...

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)

Displaying Excel's Developer Tab

The Developer tab of the ribbon is the gateway to many advanced features in Excel, including those features related to ...

Discover More

Controlling Display of Page Breaks

Do you want page breaks displayed on the screen? Excel allows you to specify whether it should show those page breaks or not.

Discover More

Fixing the Decimal Point

Don't want to always type the decimal point as you enter information in a worksheet? If you are entering information that ...

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 7 + 8?

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


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
Share