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

Printing Multiple Label Copies when Merging

Need to print more than one copy of mail-merge labels? There are a number of different approaches you can take to getting ...

Discover More

Controlling the Plotting of Empty Cells

When creating a chart from information that contains empty cells, you can direct Excel how it should proceed. This tip ...

Discover More

Ribbon Acting Strangely

The ribbon is the place where Word stores all the tools you need to work with your documents. What happens when the ...

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)

Setting a Default File Format

Excel normally saves workbooks using a default file format that is peculiar to your version of the program. You can ...

Discover More

Transferring Ribbon Customizations

Excel allows you to make a wide range of customizations to both the Quick Access Toolbar and the ribbon. If you want to ...

Discover More

Adding an Equal Sign Tool

In older versions of Excel (97 and 2000) the program had an equal sign tool that appeared right next to the Formula bar. ...

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