Is it possible to change and entire sheet to Upper case???

If you would rather not use formulas, you could right-click on the sheet tab, select view code, and paste this code, and then run the macro:

Sub allcaps()
    Dim rng As Range, cell As Range
    Set rng = ActiveSheet.UsedRange
    For Each cell In rng.Cells
        cell.Value = UCase(cell.Value)
    Next
End Sub

Thanks Bryan and Jason.

Jason, that macro is great. Thats going to save us heaps of work.


Thanks very much for your help. All the best for the year ahead.

Timbo

Glad I could help, Timbo.

That is awesome! I have been trying for EVER to do this with different formulas...and it two seconds the code you posted took care of my whole sheet. Why haven't MicroSoft people figured out a way to simplify this for the user yet?? Ugh. Anyway..thanks so much for posting.

This worked great! Thanks!

Thank you so much for this macro!! This made a WORLD of difference for a work project of mine.

You. Are. A. Genius! Thank you!!!

thanks a ton, this saved my time and did help me a lot and many thanks once again

Thanks Jason, your Macro saved me. I was looking for many days to convert the whole sheet in Caps but could not find any. Your macro has resolved my problem, thanks a lot.