How to Change from Lowercase to Uppercase in Microsoft Excel

Download Article

Change the case of text in Excel data

Written by Rain Kengly

Last Updated: October 27, 2024 Fact Checked

Download Article

ARTICLE

VIDEO

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

1
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/.
2
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
3
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)
This will enter the formula.
This will have the changed name.
6
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.
7
Copy the entire column. It should already be selected after filling down the formula.
- On Windows, press CTRL + C. On Mac, press CMD + C.
A drop-down menu will open.
9
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.
10
Delete the temporary column. Right-click the column header (ex: B), and select Delete.

Change from Lowercase to Uppercase in Excel Step 10

Community Q&A

Search

Add New Question

Question

Can I change to uppercase for an entire working sheet at one time?

Community Answer

Yes, you can do this by selecting the entire sheet then specifying you want it to be uppercase.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 182 Helpful 106
Question

How do I do uppercase when putting in a password?

Community Answer

You can't use caps lock on some operating systems; try using the uppercase button

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 18 Helpful 18