
To make text uppercase in Excel, type =UPPER(A2) in a blank column next to your data, fill the formula down, and paste the results as values if you want to keep only the capitals. If you’d rather skip formulas, type the first entry in capitals yourself and press Ctrl+E to run Flash Fill. Both work on any column of text. The difference is what’s left in the sheet afterward.
Method 1: the UPPER function
UPPER takes one argument, the text to convert. It can be a cell reference or text typed straight into the formula. Microsoft’s own example: if A2 contains “total”, =UPPER(A2) returns TOTAL.
The formula doesn’t change the original cell, so it needs somewhere to show its result. Here’s how to set it up:
- Pick an empty column next to your data. If the names are in column A, use column B.
- Click the first cell of that column, on the same row as your first name.
- Type
=UPPER(A2)and press Enter. - Click the cell you just filled and double-click the small square at its bottom-right corner, the fill handle. Excel copies the formula down as far as the neighboring column has data.
Every row in column B now shows the text from column A in capitals. Edit a name in column A and column B updates with it, because the formula stays live.
If the cell shows the formula itself instead of a result, Microsoft’s page suggests selecting it, pressing F2, and then Enter.
Replace the original column with the capitals
Most of the time you don’t want two columns. To keep only the uppercase text, convert the formulas to values:
- Select the cells with the formula (column B in the example).
- Select Copy.
- Click the first cell of the original column (A2) so you paste over the old data.
- Under Paste, open the arrow next to Paste Options and choose Values Only.
- Delete column B, which now holds only the helper formulas.
Microsoft attaches two warnings to this. First, Excel removes the formulas permanently, so save a copy of the workbook before you start, especially if other cells depend on these. Second, if you make a mistake, click Undo right after pasting to bring everything back.
For a single cell there’s a shortcut: press F2 to edit the cell, then F9 and Enter. F9 swaps the formula for its calculated value.
Method 2: Flash Fill (Ctrl+E)
Flash Fill watches the pattern you show it and repeats it down the column, with no formula. For uppercase, the pattern is simply your first entry typed in capitals.
- In the column next to your data, type the first value in capitals. If A2 says “maria souza”, type MARIA SOUZA in B2.
- Select column B (or click B3).
- Go to Data > Flash Fill, or press Ctrl+E.
Ctrl+E works on Windows and in Excel for the web. On a Mac, Microsoft lists Control+E. The column fills in following the pattern from your example.
Flash Fill produces fixed values, not formulas. That skips the paste-as-values step, but there’s a cost: if you fix a name in column A later, column B won’t follow. For a list you’ll use once, it’s the quickest route. For a sheet that keeps changing, UPPER is the safer choice.
Which method should you use?
| Situation | Best option |
|---|---|
| Finished list, one-time use | Flash Fill (Ctrl+E) |
| Data that will keep changing | UPPER function, left in the sheet |
| You want to replace the original column | UPPER, then Paste Values Only |
| Text inside a larger formula | UPPER nested, like =UPPER(A2&" "&B2) |
The last row shows an advantage of the function: it combines with others. If you join first and last names in one cell, the same formula returns the whole result in capitals.
When Flash Fill doesn’t work
If Excel says it can’t find a pattern, or the column fills in wrong, the example is usually the problem. Check these points:
- Type your example in the column right next to the data, with no blank column between them.
- If every row repeated your first value, delete the column and start over. Sometimes a second example on the next row helps Excel see what you want.
- If Flash Fill doesn’t suggest anything on its own, run it manually from Data > Flash Fill.
If the column still comes out uneven, go back to UPPER, which doesn’t rely on guessing a pattern.
What about lowercase or just the first letters?
Excel has sister functions for the other formats: LOWER makes everything lowercase and PROPER capitalizes the first letter of each word. The routine is the same: a formula in a helper column, fill down, and paste as values if needed.
If you’re setting up a sheet for other people to fill in, an Excel drop down list keeps entries consistent from the start. And a checkbox in a cell helps when you need yes/no columns that don’t depend on anyone’s typing.
Frequently asked questions
Is there a keyboard shortcut for uppercase in Excel?
There’s no shortcut that converts a cell’s text the way word processors do. The two quick options are the UPPER function and Flash Fill with Ctrl+E.
Does UPPER change the original cell?
No. It returns the result in the cell where you wrote it and leaves the source text as it was. To replace the original, copy the formulas and paste them as Values Only over the old column.
Does UPPER work in older versions of Excel?
Microsoft’s page lists Excel for Microsoft 365, Excel for the web, and Excel 2024, 2021, 2019 and 2016.


