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