On Microsoft Excel, you can add a header or footer ... and older versions includes multiple ways to add and change the header and footer of the page, and there is even a way to apply the same ...

Open the Excel document that contains the words that you want to change to all caps. Right-click on the header of the column to the right of the column of text that you want to convert to all caps.