Customize Excel Ribbon – Change Case of Text

We all know that Excel Ribbon has tabs like Home, Data, review, Insert and many more. This allows us to perform some tasks like formatting the text, inserting bullets and more. Without this Excel ribbon nothing can be done. But, if you observe it, text on all tabs of ribbon is in camel case. Do you know that, text on tabs can be changed to uppercase and that case can also be replaced with another text? Yes, you heard it right. We can do that and we have Jordan “Jlookup” Goldmeier explaining us the same. So, let us learn how to do that.

Let us Get Started to Customize Excel Ribbon

1 – The Output

Did you observe the image placed on the right? You could see that “Data” and “Review” got replaced with “DATA” and “REVIEW”. This is what the output of this Excel tip gives you. Let us see how to do that in the following steps.

2 – Go To Customize Ribbon

You could achieve the above target to change the text on tabs of Excel Ribbon by going to Customize Ribbon option. First, click on “File” and select “Options”. It opens up “Excel Options” and on the left side, select “Customize Ribbon”. You could see the one as specified on the image placed below.

3 – Rename the Text on Tabs

Now, it’s time to change the text on Tabs as we want. Click on the tab which you want to rename and select “Rename” button at the bottom. Now, it asks you to enter the new text you want. Once you enter the text, click “Ok” of the Rename box. Then, click “Ok” again as specified in the image. Now, you could see the text of the tab being replaced with the text you entered.

Repeat same steps if you want to change the text remaining tabs in Excel Ribbon.

What’s next?

Jordan explained us this tip in an easy way. Now, it’s your turn to implement it and to share it with your friends and colleagues. Hurry Up! If you have anything to add, please do share with us through comments.

• Author
• Recent Posts

Sridhar Belide

Sridhar Belide is a skilled software engineer with over a decade of experience in the industry. Currently working at Wells Fargo since December 2018, he focuses on developing UI frameworks for front-end applications using React. Before joining Wells Fargo, Sridhar spent five years and four months at Tata Consultancy Services, where he held the position of IT Analyst. He also has experience as a Community Manager for Impact SoftTech Pvt. Ltd. EALP and as a Software Research and Development Engineer at NSN - Nokia Solutions and Networks. Sridhar holds a Bachelor of Technology (B.Tech.) in Computer Science from JNTUH, demonstrating his strong foundation in the field.

Latest posts by Sridhar Belide (see all)

• Edit Excel Formulas in WORD – Spreadsheet Tips and Tricks - February 17, 2022
• Using the Immediate Window in VBA - April 4, 2017
• Intersection Operator with Named Ranges – Excel Tips and Tricks - October 3, 2016