How to Capitalize in Excel: A Step-by-Step Guide

Turning text into capital letters in Excel is a handy skill to have. Whether you’re organizing data, creating a title, or simply ensuring consistency, capitalizing text can help your work look polished and professional. But how do you do it quickly and efficiently? It’s pretty simple, actually. After reading this paragraph, you should be able to capitalize text in Excel with ease.

Step by Step Tutorial on How to Capitalize in Excel

Before we dive into the steps, it’s important to know that we’ll be using a function in Excel called UPPER. This function converts all letters in a text string to uppercase.

Step 1: Select the Cell or Range of Cells

Click on the cell where you want the capitalized text to appear.

In this step, you’re choosing where you want the change to happen. If you’re capitalizing a single cell, just click on it. For multiple cells, click and drag to select them all.

Step 2: Type the UPPER Function

Type =UPPER(A1) into the selected cell, replacing A1 with the cell you want to capitalize.

Here’s where the magic happens. The UPPER function is what tells Excel to capitalize the text. Be sure to replace A1 with the reference to the cell containing the text you want to capitalize.

Step 3: Press Enter

Hit the enter key to apply the function.

Once you press enter, Excel will process the function and the text will be converted to all caps.

After completing these steps, the text you selected will be in all capital letters. This makes your data look uniform and can make headings stand out.

Tips for Capitalizing in Excel

  • Use the UPPER function to capitalize entire cells of text.
  • If you need to capitalize just the first letter of each word, use the PROPER function instead.
  • To toggle between upper and lower case, use the LOWER function to make all letters lowercase.
  • Remember to reference the correct cell within the UPPER function for accurate results.
  • For dynamic capitalization, combine the UPPER function with other Excel functions for advanced formatting.

Frequently Asked Questions

What is the UPPER function?

The UPPER function is an Excel feature that converts all text in a selected cell to uppercase letters.

Can I capitalize multiple cells at once?

Yes, you can capitalize multiple cells by selecting a range and using the UPPER function in a formula.

Is there a shortcut to capitalize text in Excel?

There isn’t a keyboard shortcut, but using the UPPER function is a quick method.

Can I capitalize only the first letter of each word?

Yes, use the PROPER function instead of UPPER to capitalize the first letter of each word in a text string.

Will the UPPER function affect numbers or symbols?

No, the UPPER function only changes letter characters to uppercase. Numbers and symbols remain unchanged.


  1. Select the cell or range of cells.
  2. Type the UPPER function.
  3. Press Enter.


Excel is a powerhouse when it comes to organizing and manipulating data. Knowing how to capitalize in Excel is just one of the many skills that can help you tidy up your worksheets. While it might seem like a simple task, it’s these small details that make your data more readable and professional. Whether you’re a beginner or a seasoned pro, mastering functions like UPPER can streamline your workflow and save precious time. So the next time you’re faced with a list of text that needs capitalizing, you’ll know exactly what to do. Go ahead, give it a try, and watch as your data transforms before your eyes.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy