Excel Case button

Question

Where on earth is the "change case" button to toggle between UPPER/lower case text?

Does it exist? If not, how was this an oversight, there is no excuse for omitting a "change case" button and/or keystroke shortcut, I'm shocked.

Answer 1

Dear Jake Hamilton,

Good day! Welcome to Microsoft Q&A forum!

Based on your description, I understand that you want to find the "change case" button to toggle between UPPER/lower case text in Excel.

You are absolutely right to complain about that. Excel really doesn't have a "Change Case" button like Word does.

Microsoft confirms this in its official support documentation: "Unlike Microsoft Word, Microsoft Excel doesn't have a Change Case button for changing capitalization." - Change the case of text

Instead, Microsoft has long required the use of these functions:

• =UPPER(A1) ' UPPERCASE
• =LOWER(A1) ' lowercase
• =PROPER(A1) ' Title Case

If you want an experience similar to Word, the most common methods are:

• Adding a VBA macro and assigning it to a button on the Ribbon or Quick Access Toolbar (QAT).
• Using Office Scripts (for Excel on the web).
• Using Power Query for batch data processing.
• Using Excel add-ins that provide a dedicated "Change Case" button.

If any of these workarounds interest you, please let me know, and I will provide instructions to ensure your work proceeds smoothly.

As a fellow user, I also find it difficult to handle large datasets due to the lack of that feature. And some other users have the same question as you - Where is the change case option located in Excel

I suggest submitting this feedback to the Feedback portal so the Excel team can look into it. You could then share the feedback link here so other community members can see and vote for it.

Thank you for your time and patience.

Answer 2

Thank you for this detailed response, Julie! I will absolutely be adding this to the Feedback portal.