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. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “make text all caps in excel”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the outcome you expected before you touch the real workbook. 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. The point is a layout choice that keeps the sheet readable and sortable, but the practical win is that someone else can open the file and understand what happened without asking you.
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 “make text all caps in excel”, 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 text all caps excel”, “changing text to all caps in excel”, “how do you capitalize all text in excel” and “how to make all text 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 text all caps excel”, “changing text to all caps in excel”, “how do you capitalize all text in excel” all point at the one operation explained on this page, which is why they all lead here.