1. Open the Excel worksheet that has the case you want to change.
2. Decide which case you want to use. You can choose from uppercase, lowercase or proper case (the first letter is capitalized).
3. Use a blank cell, row or column next to the cell you want to change. If there is not a blank cell, row, or column, right-click next to the cell you want to change, select 'Insert' and choose whether you want to insert a new row or column. You can delete this later. If you need to change the entire spreadsheet, start with the column available at the end of the spreadsheet.
4. Enter '=' and the function for the case you want to change to in the blank cell. Use 'LOWER,' 'UPPER,' or 'PROPER.' For example, if you wanted to switch to lowercase, you would enter into the cell '=LOWER.'
5. Next to the case function enter a parenthesis. Inside the parenthesis, enter the cell reference for the first cell where you want to change the case. For example, if you are changing the case of the text in cell A1 to lowercase, you would have entered '=LOWER(A1)' at this point.
6. Highlight the cell you entered the function in and the rest of the row(s) or column(s).
7. Click the 'Home' tab located at the top of the screen and click the 'Fill' button. Select 'Down,' 'Right,' 'Up,' or 'Left' depending on the direction of the cells in which you're changing the case. If you need to change cells in more than one direction, then click 'Fill' again and select the next direction. The text with the case change will appear.
8. Highlight the cells with the case change, right-click, and select 'Copy.'
9. Click the first cell with the old case, which would be cell A1 in the example. Click the 'Paste' button and select 'Paste Special.' Select 'Values' in the box that opens and click 'OK' to paste the converted text. This will paste the new case into all the cells.
10. Delete the duplicate cells by highlighting them and pressing the 'Delete' button. If you had to insert a new row or column, select the row or column, right-click, and click 'Delete.'
Read more ►