Convert Sheet to all Caps

I need to take an entire excel sheet and convert it to all caps

Is there an easy way to do this?
Who is Participating?
Martin LissOlder than dirtCommented:
Go to VisualBasic, insert a module if one doesn't already exist, copy/paste this into the module, select it and press F5. Note that it will affect only the active sheet.

Sub MakeUpper()

Dim c As Range

For Each c In ActiveSheet.UsedRange.Cells
    c.Value = UCase(c.Value)
End Sub

Open in new window

It's not a point and click, if that's what you're after. There's the upper function, vb scripts and even utilities from ASAP.

Here's a step by step if you don't want to mess around with scripts or install utilities:

Another one from Microsoft:
ssblueAuthor Commented:
Martin LissOlder than dirtCommented:
You’re welcome and I’m glad I was able to help.

If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange Most Valuable Expert (MVE) 2015, 2017
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
You're welcome. Thanks for the grade and Good luck!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.