Download Article
Download Article
While there's no Change Case button in Microsoft Excel, you can use an easy formula to capitalize all letters or change the case of a list of names without retyping it. You'll just need the UPPER or PROPER functions to do so. Here's how to change letters from lowercase to uppercase in Microsoft Excel using your Windows or Mac computer.
Making Uppercase Text in Excel
In a temporary column, use the formula =UPPER(cell) . Replace cell with the location of the first cell of the column you want to change. Press Enter to convert the text. Fill down the rest of the formula, then copy and paste it to the original column.
Steps
Download Article
-
Open a workbook in Microsoft Excel . You can use an existing project or create a new spreadsheet . Make sure you're on the correct worksheet.
- Microsoft Excel is available on Windows and Mac . You can also use the online web version at https://www.office.com/ .
-
Right-click the column and select Insert . This will insert a temporary column.
- The column can be on the left or right side of the column you want to change from lowercase to uppercase. Keep note of the original cell name. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
Advertisement -
Type "=UPPER(cell)" into the first cell of the new column. Replace cell with the location of the first cell in the column you want to change from lowercase to uppercase.
- This formula will convert all lowercase letters into uppercase (all caps). To only capitalize the first letter of each name or word, use PROPER instead.
- For example, the formula could be: =UPPER(A2) or =PROPER(A2)
-
Press ↵ Enter or ⏎ Return . This will enter the formula.
-
Select the first cell of the temporary column. This will have the changed name.
-
Double-click the square in the bottom-right corner of the cell. This shortcut will fill down the formula in the rest of the column.
- You should see the rest of the column change into the Upper or Proper version.
-
Copy the entire column. It should already be selected after filling down the formula.
- On Windows, press CTRL + C . On Mac, press CMD + C .
-
Right-click the first cell of the original column. A drop-down menu will open.
-
Select Paste Values . If you don't see this, you can click the clipboard with 123 in front of it.
- Alternatively, press V with the drop-down menu open to paste values.
- The new names will be pasted without the underlying formulas.
-
10Delete the temporary column. Right-click the column header (ex: B), and select Delete .
Community Q&A
-
QuestionCan I change to uppercase for an entire working sheet at one time?Community AnswerYes, you can do this by selecting the entire sheet then specifying you want it to be uppercase.
-
QuestionHow do I do uppercase when putting in a password?Community AnswerYou can't use caps lock on some operating systems; try using the uppercase button
Video
Tips
References
About This Article
You can use the "UPPER" function in Microsoft Excel to transform lower-case letters to capitals. Start by inserting a blank column to the right of the column that contains your data. Click the first blank cell of the new column. Then, click the formula bar at the top of your worksheet—it's the typing area that has an "fx" on its left side. Type an equal (=) sign, followed by the word "UPPER" in all capital letters. To tell the "UPPER" function which data to convert, click the first cell in your original data column. Press the Enter or Return key on your keyboard to apply the formula. The first cell of your original data column is now converted to uppercase letters. To apply this change to the entire column, click the cell containing the uppercase letters to select it. Then, drag the small square at the bottom-right corner of the cell down to the final row.
Reader Success Stories
- "As a teacher, I give computer lessons. My pupil and I were trying to work out ways to change the letter casing in her spreadsheet demo. I was sure there were other ways. I always use wikiHow, so naturally, I found your 4 methods." ..." more
