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.

You can wrap text in Excel in several ways to ensure that all the text in a cell is visible at once. You may also want to edit the cell height.