Once you complete the steps, the configuration will replicate all the Excel sheets in the documents. If you have been tasked to edit and remove the header and footer from a document, you can ...

Q. Is it possible in the Office 365 edition of Excel 2016 to create new blank workbooks that are automatically formatted to include headers and footers with date, time, file name, and file path ...

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.