You can insert or add Header and Footer in Excel spreadsheet using this tutorial. Insert page number, current date and time, etc.

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.

If you want to change the text case from lowercase to uppercase in Microsoft Excel, then this guide shows you five ways to do it.