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?
ssblueAsked:
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)
Next
End Sub

Open in new window

0
 
netcmhCommented:
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: https://www.journalofaccountancy.com/issues/2005/feb/whosaysyoucanteasilychangeexcel.html

Another one from Microsoft: https://support.office.com/en-us/article/change-the-case-of-text-01481046-0fa7-4f3b-a693-496795a7a44d
0
 
ssblueAuthor Commented:
thanks
0
 
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
0
 
netcmhCommented:
You're welcome. Thanks for the grade and Good luck!
0
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.