# Capitalize All Letters in a Cell in Google Sheets

Edited by Djinu, Alexander Avdeev, Eng, James

You're watching VisiHow. In this video, we are going to show you how to capitalize all of the letters from lowercase to uppercase using Google Sheets.

## Steps

1. 1
To capitalize letters, we click cell "B1"
.
2. 2
We type "=upper("
.
3. 3
We type "A1" or click the "A1" cell
.
4. 4
We type ")"
.
5. 5
We press "Enter"
.
The formula will change the cell contents from lowercase to uppercase.
6. 6
We can fill the formula down by double-clicking or clicking and dragging the cell
.

That was how to change all of the letters from lowercase to uppercase using Google Sheets. If you have any questions or comments, please leave them in the space below. Thanks for watching VisiHow!

## Video: Capitalize All Letters in a Cell in Google Sheets

### How to change the letters in a cell to upper case, without moving the contents into another cell?

How do I change the letters in a cell, without moving the letters into another cell?. cell A1 has this text in it "The Boat is in THe waTTeR.". I want to change the letters in cell A1 all to upper case.. cell A1 will now look like this "THE BOAT IS IN THE WATER.". Cell A1 has "HeLLo" in it. Everyone shows insert this function into a blank cell =Upper(A1) That blank cell now has "HELLO" in it. I want cell A1 to change to "HELLO". I have tried: Cell A1 has "HeLLo" in it. I type this function =UPPER(A1) into cell H4 or any blank cell. cell H4 now has "HELLO" in it. Right click on cell H4 Left click - Copy Move to cell A1 Right click - Paste special Left click - Paste values only cell A1 now has "#REF!" in it

I simply want cell A1 to have "HELLO" in it.

That is as detailed as I can say it. cell A1 - Big cell A2 - Little cell A3 - Small cell A4 - ConFuSEd How do I make all cells upper case letters? cell A1 - BIG cell A2 - LITTLE cell A3 - SMALL cell A4 - CONFUSED. I think it was caused by: Google sheets does not have a feature like EXCEL does "Convert->Text case as->

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.