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.

Unfortunately, Excel doesn’t have a built-in option to change the case of the text like ... after renaming the header (if any), or copy-paste data from one spreadsheet to the other.

If you want to add a header and footer in Excel spreadsheet, then this article will help you to do that. Microsoft Excel allows users to insert a header and footer for each page manually.