In this article:

How to Capitalize All Letters in Google Sheets (2024 Update)

May 8, 2024

In this article, we explain how to capitalize all letters in Google Sheets across multiple cells. Read on to learn more.

How to Capitalize All Letters in Google Sheets

To capitalize all letters across multiple cells in Google Sheets, you can use the UPPER function. This function converts all lowercase letters in a text string to uppercase. Here's how to apply it: 

Let's assume you have a list of names in column A, from A1 to A4:

how to capitalize all letters in google sheets

Step 1: Select an Empty Cell

Click on an empty cell where you want the capitalized results to appear. For example, click on B1.

Step 2: Enter the UPPER Function

In cell B1, type the following formula:


This formula converts the text in cell A1 to uppercase.

google sheets all caps
google sheets capitalize all

Step 3: Drag the Formula Down

Click and drag the small dot in the lower-right corner of B1 down to the other cells where you want to apply the same formula (B2, B3, B4).

capitalize all letters in google sheets
google sheets how to capitalize all letters

Step 4: Copy and Paste as Values (Optional)

If you want to replace the original data with the capitalized text, first select cells B1 to B4. Right-click and choose "Copy." Then select cell A1, right-click, and under "Paste special," choose "Values only."

google sheets capitalize all letters

We hope that this article has helped you and given you a better understanding of how to capitalize all letters in Google Sheets. If you enjoyed this article, you might also like our articles on how to capitalize the first letter in Google Sheets and how to clear conditional formatting in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->