How To Capitalize in Excel

Last updated: August 20, 2026

Excel case conversion cheat sheet

Four results, four different approaches. Find the row that matches what you want and go to that section.

Unlike Microsoft Word, Excel has no button that changes the case of what is already in a cell. Word has Shift + F3 to cycle through cases. Excel has nothing equivalent, and that single missing feature is why every method below exists.

How do you make text all caps with UPPER?

UPPER converts every letter in a cell to a capital. It does not change the original cell, it produces the result somewhere else, which is why the last two steps matter as much as the first three.

1. Pick an empty column. Choose a column next to your data, for example column D, to hold the converted text.

2. Enter the formula. In cell D2 type =UPPER(A2) and press Enter. "john doe" in A2 becomes "JOHN DOE" in D2.

3. Fill it down. Drag the small square at the bottom right corner of D2 down the column, or double-click that square to fill to the bottom of the adjacent data in one action.

4. Paste the results back as values. Select D2 down to the last filled cell, press Ctrl + C, click cell A2, then right-click and choose Paste Special with Values selected. Click A2 specifically rather than the whole column A, so the paste lands on the right row.

5. Delete the helper column. Only now is it safe to delete column D. If anything looks wrong, press Ctrl + Z, or read our guide on how to undo in Excel.

The rule: never delete the source column while the results are still formulas. Paste Special as Values first, then delete.

Microsoft's reference for the UPPER function covers the full syntax.

How do you capitalize the first letter of every word?

PROPER is the function for names, titles and city names, anywhere every word should start with a capital.

1. Click an empty cell next to the first row of data, for example D2.

2. Type =PROPER(A2) and press Enter. "john doe" becomes "John Doe".

3. Fill down by dragging the fill handle from D2, or double-clicking it.

4. Copy the results with Ctrl + C.

5. Paste as values over the original. Click A2, right-click, choose Paste Special, select Values, and click OK.

6. Delete the helper column.

Before you use PROPER on real names, read the section on where PROPER gets names wrong. It will turn McDonald into Mcdonald and IBM into Ibm, and it does that silently.

How do you capitalize only the first letter of a sentence?

This is the request PROPER does not answer, and it is the one people most often end up with the wrong function for. PROPER capitalizes every word. For sentence case, where only the very first letter is capitalized and the rest is left in lowercase, Excel has no built-in function, so you build it from three:

=UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2)))

Reading it left to right: LEFT(A2,1) takes the first character, UPPER capitalizes it, MID(A2,2,LEN(A2)) takes everything from the second character onwards, LOWER forces that to lowercase, and the & operator joins the two halves back together.

If you want to capitalize the first letter but leave the rest of the text exactly as typed, including any capitals already in it, drop the LOWER:

=UPPER(LEFT(A2,1))&MID(A2,2,LEN(A2))

The rule: PROPER is for names and titles, the sentence case formula is for sentences. Using PROPER on a sentence gives you Title Case, which is almost never what you wanted.

Is there a keyboard shortcut for all caps in Excel?

The honest answer, and the one most pages avoid giving: no. Excel has no built-in keyboard shortcut that changes the case of existing text. Word has Shift + F3, which cycles lowercase, Title Case and UPPERCASE. Microsoft never brought it to Excel. Ctrl + Shift + A, Ctrl + Shift + U and the other combinations people try do something else entirely.

There are three real workarounds, in order of how quickly you can get to them.

1. Flash Fill: Ctrl + E

The closest thing to a native shortcut. Type the first value the way you want it, then press Ctrl + E in the cell below and Excel completes the rest of the column. Full steps are in the Flash Fill section.

2. Give a macro its own shortcut key

If you change case constantly, this turns it into one keystroke permanently.

1. Add the macro from the VBA section below to your Personal Macro Workbook so it is available in every file.

2. Press Alt + F8 to open the Macro dialog, select the macro, and click Options.

3. In the "Shortcut key" box type a letter, for example a capital U, which assigns Ctrl + Shift + U to the macro.

4. Click OK. Now select any cells and press your shortcut.

3. Put a button on the Quick Access Toolbar

Right-click the macro in the Quick Access Toolbar customisation screen and add it. Anything on that toolbar gets an automatic Alt plus number shortcut, so the first button becomes Alt + 1.

The rule: there is no shortcut key for case in Excel. Ctrl + E is the fastest thing that exists out of the box, and a macro shortcut is the only way to get a true one keystroke conversion.

How do you use Flash Fill to change case?

Flash Fill watches what you type and completes the pattern. It needs no formula and no helper formula to clean up afterwards, because it writes plain text values straight away.

1. If A2 contains "john doe", click B2 and type JOHN DOE exactly as you want it.

2. Press Enter to move to B3.

3. Press Ctrl + E. Excel fills the rest of column B in the same style.

4. Check a few rows, then copy column B, paste it over column A as Values, and delete column B.

Two limits worth knowing. Flash Fill is static, so changing A2 later does not update B2. And it is a desktop feature, so Ctrl + E does nothing in Excel for the web.

How do you capitalize a whole column at once?

Nothing special is required, but two details save a lot of dragging.

• Fill down instantly. Enter the formula in the first cell, then double-click the fill handle, the small square at the bottom right of the cell. Excel fills down to the last row of the adjacent column automatically, however many thousands of rows that is.

• Or fill a selection. Enter the formula in the top cell, select from there down to the last row you want, and press Ctrl + D.

• Then replace the original in one paste. Copy the whole helper column, click the first cell of the original column, and Paste Special as Values.

If the column is inside an Excel Table, entering the formula in one cell fills the entire column automatically and there is nothing to drag at all.

How do you capitalize with a VBA macro?

Worth it when you convert case often enough to want it on a shortcut key. Press Alt + F11, click Insert then Module, and paste the code.

Sub CapitalizeSelection()
Dim cell As Range
For Each cell In Selection
If Not cell.HasFormula And Not IsEmpty(cell.Value) Then
If Application.WorksheetFunction.IsText(cell.Value) Then
cell.Value = UCase(cell.Value)
End If
End If
Next cell
End Sub

Select your cells, press Alt + F8, choose the macro and click Run. Swap UCase for LCase to go the other way, or for Application.WorksheetFunction.Proper(cell.Value) to title case.

The IsText check matters. Without it the macro runs UCase over numbers and dates too, which converts them into text that looks identical but no longer calculates. Two other warnings: a macro clears the undo history, so save a copy first, and the file has to be saved as .xlsm for the macro to survive.

How do you change case in Power Query?

Use this when the same file gets refreshed every week and you want the case fixed automatically every time, rather than redoing it by hand.

1. Click inside your data and press Ctrl + T, then OK, to make it a table.

2. Go to Data, then From Table/Range. The Power Query Editor opens.

3. Click the column header to select it.

4. On the Transform tab, click Format, then choose UPPERCASE, lowercase or Capitalize Each Word.

5. Click Close & Load.

The transform is saved as a step in the query, so refreshing next month reapplies it to the new data. Our guide to Power Query in Excel covers the rest of the editor.

Can you make cells look uppercase without changing the data?

Yes, but be clear about what this does and does not do. Excel has no cell format that changes case, unlike Word's Font dialog which has an All Caps checkbox. What you can do is apply a font whose lowercase glyphs are drawn as small capitals.

1. Select the range.

2. Press Ctrl + 1 to open Format Cells and go to the Font tab.

3. Choose a small caps font such as Copperplate Gothic Bold or Castellar, then click OK.

The important caveat: the underlying text is unchanged. A2 still contains "john doe", so a formula reading it, a filter matching it, or a CSV exported from it all still see lowercase. If the person opening the file does not have that font installed, the display reverts too.

The rule: the font trick changes what you see, never what is in the cell. Use UPPER if the data itself needs to be uppercase.

Where PROPER gets names wrong

PROPER capitalizes the letter after every space, hyphen and apostrophe, and lowercases everything else. That rule is right most of the time and confidently wrong the rest of the time, without any error to warn you.

There is no formula that fixes all of these, because the correct answer depends on knowing what the word is. Two practical options: run PROPER, then filter the column for the handful of known exceptions and correct them by hand, or use Flash Fill, which learns from the corrected examples you give it rather than applying a fixed rule.

Why is Excel not capitalizing?

How do you stop Excel capitalizing automatically?

The opposite problem, and a common one. Excel's AutoCorrect capitalizes the first letter of anything it decides is a sentence, which mangles product codes, chemical names and deliberately lowercase entries.

1. Go to File, then Options.

2. Click Proofing, then AutoCorrect Options.

3. Clear the Capitalize first letter of sentence checkbox.

4. While you are there, clearing Correct TWo INitial CApitals stops Excel changing entries such as ABc.

5. Click OK.

The setting is per installation, not per file, so it applies to every workbook you open on that machine.

Frequently asked questions

How do I capitalize the first letter in Excel?

Use =PROPER(A2) if you want every word capitalized, which suits names and titles. For sentence case, where only the very first letter is capitalized, use =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2))).

Is there an Excel shortcut for all caps?

No. Excel has no built-in key combination that changes case, and Word's Shift + F3 does nothing here. The fastest option is Flash Fill: type the first value in caps and press Ctrl + E. For a true one keystroke conversion you have to assign a macro to a shortcut key.

How do I capitalize a whole column in Excel?

Put =UPPER(A2) in the first cell of an empty column, then double-click the fill handle to fill the whole column instantly. Copy that column, click the first cell of the original, and Paste Special as Values.

Why does PROPER turn McDonald into Mcdonald?

PROPER only capitalizes the letter after a space, hyphen or apostrophe, and lowercases everything else. The D in McDonald follows a letter, so it gets lowercased. Acronyms such as IBM become Ibm for the same reason.

Can I change case without a formula?

Yes, three ways. Flash Fill with Ctrl + E, the Format then UPPERCASE transform in Power Query, or a VBA macro. Applying a small caps font changes the display only and leaves the underlying text untouched.

How do I stop Excel from capitalizing the first letter automatically?

Go to File, Options, Proofing, AutoCorrect Options, and clear the "Capitalize first letter of sentence" checkbox. The setting applies to every workbook on that installation of Excel.

Final thoughts

Pick the function that matches the result you want rather than the one you remember. UPPER for all caps, PROPER for names and titles, the LEFT and MID combination for sentence case, and Power Query when the same fix has to happen again next month. Whichever you use, paste the results as values before deleting anything.

You can visit our homepage for more guides.

Related Articles

How to Print Gridlines in Excel

How to Add a Total Row in Excel

How to Convert Text to Numbers in Excel