How To Add "Change Case" to Excel Ribbon

We all know the Excel Ribbon is packed with tools that make our lives easier. With tabs like Home, Insert, Data, and Review, we can format, analyze, and manage data with just a few clicks. But did you know you can customize the Ribbon to add new functionality, like a handy “Change Case” button? Yes, you heard that right! With a few simple steps, you can add this feature to save time and effort.

Let’s dive into this Excel tip and learn how to customize your Ribbon with Jordan “Jlookup” Goldmeier’s knack for making Excel fun and easy.

How To Add “Change Case” to Excel Ribbon

1 – Let’s Get Started with Adding “Change Case”

Did you ever wish Excel had a built-in “Change Case” feature like Word? While Excel doesn’t natively support case changes, you can create your own button to toggle between uppercase, lowercase, and proper case directly from the Ribbon!

Take a look at the image. The “Change Case” command now appears in the Home tab of the Ribbon, ready for action. Let’s see how to do it step by step.

2 – Enable the Developer Tab

Before we create the macro, make sure the Developer tab is visible in the Ribbon:

Click on File > Options > Customize Ribbon.
On the right-hand side, check the box for Developer.
Click OK to save and return to Excel.

3 – Create a Change Case Macro

Now let’s write the macro:

Go to the Developer tab and click on Visual Basic to open the VBA editor.
In the editor, click Insert > Module.
Copy and paste the following macro code:

vbaCopy codeSub ChangeCase()
    Dim rng As Range
    Dim cell As Range
    Dim caseType As Integer
    
    ' Prompt the user to select the case type
    caseType = Application.InputBox("Enter 1 for UPPERCASE, 2 for lowercase, 3 for Proper Case", "Change Case", Type:=1)
    
    If caseType < 1 Or caseType > 3 Then
        MsgBox "Invalid selection. Please enter 1, 2, or 3."
        Exit Sub
    End If
    
    ' Loop through the selected cells
    On Error Resume Next
    Set rng = Selection
    For Each cell In rng
        If Not IsEmpty(cell.Value) And VarType(cell.Value) = vbString Then
            Select Case caseType
                Case 1: cell.Value = UCase(cell.Value)
                Case 2: cell.Value = LCase(cell.Value)
                Case 3: cell.Value = Application.WorksheetFunction.Proper(cell.Value)
            End Select
        End If
    Next cell
    On Error GoTo 0
End Sub

Close the VBA editor and return to Excel.

4 – Add the Macro to the Ribbon

Click File > Options > Customize Ribbon.
In the right-hand panel, select the tab where you want to add the button (e.g., Home).
Click New Group to create a custom group (you can rename it to “Text Tools”).
In the left-hand panel under Choose Commands From, select Macros.
Find your “ChangeCase” macro and click Add>> to add it to your custom group.
Click OK to save your changes.

5 – Test Your “Change Case” Button

Choose 1 for UPPERCASE, 2 for lowercase, or 3 for Proper Case in the pop-up.

Select some text in Excel.

Click your newly added “Change Case” button in the Ribbon.

How To Change the Case of Tabs in the Excel Ribbon

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.

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 has shown us how simple it is to make Excel work the way you want it to. Now it’s your turn! Add “Change Case” to your Ribbon, and try it out on your next project. Don’t forget to share this tip with your friends and colleagues. Let us know in the comments if you’ve tried it or if you have more ideas for customizing Excel.

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)

Excel VBA: Disable Pop up Messages (Remove Auto Syntax Popup) - January 9, 2025
Data Parsing in Excel Using LEN and SUBSTITUTE function - January 9, 2025
How To Add “Change Case” to Excel Ribbon - January 9, 2025