How to Change Text to Uppercase in Excel 2007
If you're hunting around the Excel 2007 ribbon for a Change Case button, you may want to try your luck on the Word 2007 ribbon instead. Change Case, the button command in Word that easily converts text to lowercase, uppercase or fixes toggle case is not an option in Excel 2007. Short of retyping your lowercase text with the CAPS LOCK key turned on, there is a function within Excel that you can use to create a formula that will fix the problem.
Insert a blank column to the left of the column with cells that need to be converted to uppercase text by right-clicking on the column-header of the source cells and choosing "Insert" from the shortcut menu that appears.
Use the UPPER function to convert the text by clicking in the first cell of the new column and typing the following formula: =UPPER(A1) where A1 is the cell reference of the first cell with lowercase text. Use your keyboard to hit the Shift+Enter keys. You will see the result of the formula while staying in the active cell.
Fill the formula down to all additional cells in the new column as needed to convert lowercase text from the source column. To fill down easily, position the mouse over the bottom right-hand corner of the current cell, and when the solid, black cross-pointer appears, click and drag the mouse downward. You should now have a new column of uppercase text.
Delete the old column of lowercase text by right-clicking on the column header and choosing "Delete" from the shortcut menu that appears. If this is not convenient because of your spreadsheet's layout, then copy the cell containing the first UPPER formula and then right-click on top of the first lowercase cell, choose "Paste Special" from the shortcut menu and then choose the "Values" option and click the "OK" button.
Fill down the formula to the rest of the lowercase cells as needed. This option will overwrite any cells in the range which happen to contain a formula.