In Excel: change case with a helper column: =UPPER(A2) for ALL CAPS, =LOWER(A2) for lowercase, =PROPER(A2) to capitalize each word — then paste the results back as values. Excel has no Shift+F3 shortcut like Word.
On this page7
Insert a helper column next to your text.
Use =UPPER(A2), =LOWER(A2), or =PROPER(A2) and fill down.
For sentence case: =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2))).
Copy the helper, Paste Special ▸ Values over the original, delete the helper.
What this does
Excel deliberately has no "Change Case" button; case conversion is done with the three text functions UPPER, LOWER, and PROPER in a helper column. PROPER capitalizes every letter that follows a non-letter, which is right for names ("anna meyer" → "Anna Meyer") but quirky for words with apostrophes or codes ("don't" → "Don'T"). Sentence case needs a small combined formula. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. For “excel make letters all caps”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. That is what makes a layout choice that keeps the sheet readable and sortable useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
Column A holds shouting customer names like "ANNA MEYER". In B2, =PROPER(A2) returns "Anna Meyer"; filling down fixes the whole list. Copy column B, then Paste Special ▸ Values over column A and delete the helper — the originals are replaced in place. Imported data arrives SHOUTING or all-lowercase constantly — CRM exports, form submissions, legacy systems. A helper column with one function call normalizes thousands of rows in seconds. Check the referenced cells, argument order and result type in your workbook. Start with the worked example before changing an input, then compare the changed result with the calculation you expected. An error value or a result of a different type is a reason to inspect the inputs and arguments.
In Google Sheets
The standard worksheet functions used by this example are listed in Google Sheets. Check the cell references, argument separators and input types in the target spreadsheet, then compare the worked result. This formula-availability check does not establish identical menus, keyboard shortcuts or workbook features, and it is not a product execution test. Keep this page bookmarked for the next time the same question comes up. Better still, repeat the steps once in your own workbook — doing it yourself is what turns a copied answer into something you remember. For “excel make letters all caps”, keep the input cells and the result visible while you check the formula in Excel. Follow the worked example and change one input at a time. The steps explain the workbook calculation; this page does not run a live calculator for that task.
Common mistakes
- Looking for Word's Shift+F3 — Excel does not have it.
- Deleting the original column before pasting the formulas back as VALUES, which breaks the references.
- Expecting PROPER to handle "McDonald" or "iPhone" — it returns "Mcdonald" and "Iphone".
- Running PROPER over codes like "A-1b" and getting "A-1B" — letters after digits and dashes get capitalized too.
Frequently asked questions
Is there a change-case shortcut in Excel?
No. Unlike Word's Shift+F3, Excel needs the UPPER/LOWER/PROPER functions, Flash Fill, or a paste from the converter above.
How do I convert case without formulas?
Type the first corrected value and press Ctrl+E (Flash Fill) — or paste your column through the converter above and copy the result back.
What does PROPER do with apostrophes?
It capitalizes the letter after them: "o'brien" becomes "O'Brien" (good) but "don't" becomes "Don'T" (usually not wanted).
Other ways people ask this
On the way here you may have searched this as “make all letters caps in excel” and “how to make letters all caps in excel” — it is all the same task, and this page is the single, complete answer to it.
Why do people search for this in so many different ways?
Because the same task has many names. “make all letters caps in excel”, “how to make letters all caps in excel” all point at the one operation explained on this page, which is why they all lead here.