Take Excel to the UPPER class

All capitals made easy

Word has a keyboard shortcut to convert lowercase to uppercase. Shift + F3. Excel doesn’t. Macros to the rescue again.

The following macro will convert all letters in a cell or range to uppercase. It ignores any formulas in the range.

You first select the range and then run the macro.

Sub ConvertToUppercase()
' This macro converts all the letters in
' the selected cells to uppercase
' it ignores formula
Dim c As Range
If TypeName(Selection) <> "Range" Then Exit Sub
 For Each c In Selection
  If Not(c.HasFormula) Then
   c.Value = UCase(c.Value)
  End If
 Next c
Set c = Nothing
End Sub

If you need to convert to lowercase use the LCase command instead of UCase in the code.

To see more instructions on how to install and use macros see this blog post.

Click here to see how you can run a Macro off a Quick Access Toolbar icon.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.