How to Capitalize Words in Excel: Shortcuts and Formulas

Formulas & functions · Updated November 20, 2026

Excel has no built-in keyboard shortcut that directly changes the case of selected text. To capitalize the first letter of each word, enter =PROPER(A2) in a helper column and fill it down; for a keyboard-driven option, type an example of the desired result and press Ctrl+E to use Flash Fill in Excel for Windows. Check the results before replacing your original text.

What You’ll Need

  • An Excel workbook with the text you want to change, preferably saved as a copy before editing.
  • A blank column beside the source text if you plan to use a formula or Flash Fill.
  • Excel for Microsoft 365 on Windows for the Ctrl+E Flash Fill shortcut. The formula method also works in Excel for Mac and Excel for the web.

Decide what “capitalize” means for your data first. Excel’s PROPER function makes the first letter of each word uppercase and the remaining letters lowercase. That is useful for names or headings, but it is not the same as making every letter uppercase, and it does not follow every person’s preferred spelling.

Step-by-Step

  1. Identify the source column and make room for results. Suppose the text to change is in A2:A20, with a heading in A1. Insert or choose an empty column next to it, such as column B, and label B1 “Capitalized.” Keeping the output separate lets you compare the transformed text with the original and recover the source if the result is wrong. If the workbook is important, save a separate copy before making a batch change.
  2. Use PROPER for title-style capitalization. With the text in A2:A20 and the first output cell in B2, enter =PROPER(A2) in B2 and press Enter. For example, if A2 contains “mARy jONES,” the result is “Mary Jones.” PROPER changes the case of letters throughout the text; it does not merely add capitals while preserving all existing uppercase letters. It also leaves spaces and punctuation in place.
  3. Fill the formula through the remaining rows. Select B2 and point to the small square at the lower-right corner of the selection, called the fill handle. Drag it down to B20. If column A has a continuous list, you can double-click the fill handle to fill alongside that list. Check the last rows to confirm the formula reached the intended end and did not extend into unrelated records. A formula in B3 should refer to A3, and the same row-by-row relationship should continue down the column.
  4. Review the converted text before using it. Compare a selection of results with the originals, including names with spaces, hyphens, apostrophes, initials, and abbreviations. PROPER may turn “NASA” into “Nasa” or “iPhone” into “Iphone.” It can also change special name spellings. Correct those exceptions in the output column manually before you replace or share the data.
  5. Turn formula results into ordinary text if needed. If you want the converted values to remain after deleting the source column, select the results in B2:B20 and copy them. Then use Home > Paste > Values to paste the displayed text back over the selected output cells. This removes the formulas while keeping their results. If you want the capitalized text in the original column, copy the finished output, select A2:A20, and use Home > Paste > Values there. Do not delete column A while B still contains formulas that refer to it.
  6. Use Flash Fill when you prefer a shortcut and the pattern is clear. With source examples in A2:A20, type the desired result for A2 in B2. For instance, if A2 is “jANE DOE,” type “Jane Doe” in B2. If Excel does not show a suggested pattern as you begin the next result, type a second example in B3. Select the remaining destination cells in column B, then press Ctrl+E on Windows. Excel fills the selected cells based on the examples. Review the whole output: Flash Fill infers a pattern rather than applying a guaranteed case rule, so it can make a different choice when entries vary.
  7. Choose uppercase or lowercase when that is what you mean. With the text in A2:A20 and the result in B2, enter =UPPER(A2) to make all letters uppercase, or enter =LOWER(A2) to make all letters lowercase. Fill the selected formula down as described above. For example, UPPER changes “Mary Jones” to “MARY JONES,” while LOWER changes it to “mary jones.” These functions are alternatives to PROPER, not keyboard shortcuts.
  8. Use the appropriate option on Mac or in a browser. In Excel for Mac, use the same PROPER, UPPER, or LOWER formula steps. If Flash Fill is available in your desktop version, use Data > Flash Fill; do not assume the Windows Ctrl+E shortcut applies on Mac. In Excel for the web, formulas are a dependable choice. If Flash Fill is not available in the web ribbon, open the workbook in the desktop app or use a formula instead.

There is no Excel equivalent of a universal “change case” key that cycles selected cells through lowercase, title case, and uppercase. Ctrl+E is useful because it runs Flash Fill, but it works by recognizing a pattern from examples; it does not act like a direct case toggle.

Common Mistakes

  • Expecting PROPER to preserve acronyms and brand styling. Since it lowercases letters that are not at the start of a word, it may alter acronyms, product names, or deliberately mixed-case text. Keep a source copy and correct exceptions after conversion.
  • Typing a formula into the source cell it refers to. If A2 contains the original and you put =PROPER(A2) in A2, the formula refers to itself. Put the formula in a different cell, such as B2, and point it at A2.
  • Overwriting data before checking the output. A formula or Flash Fill result can be wrong for an unusual entry. Keep the original column until the transformed values have been reviewed and pasted as values if necessary.
  • Assuming Flash Fill always knows the intended rule. A single example can be ambiguous. Give it another example when entries have different formats, then inspect the results instead of accepting the fill blindly.
  • Expecting PROPER to create sentence case. PROPER capitalizes the start of each word, not just the first word in a sentence. It is not a dedicated sentence-case command.

Tips

Use a helper column even if your eventual goal is to replace the original values. It makes the change reversible during review and makes it easy to compare a source entry and its result side by side. For a long list, filter or sort the output and inspect unusual-looking names, abbreviations, and records with punctuation before pasting values.

Choose the method based on the pattern, not only on speed. PROPER is predictable for ordinary word capitalization and can be filled consistently across many rows. Flash Fill is convenient when you want to demonstrate a particular transformation with examples, but its output can depend on the examples and the surrounding data. If you need to retain special casing such as “McLeod,” “eBay,” or “USA,” plan to make corrections or use a controlled mapping rather than assuming a general case function will know the preferred spelling.

For a one-time edit, the formula may be quickest because you can see exactly what transformation is being applied. For repeated work, keep the formula in a template column and document the intended case rule. If other people will use the workbook, label the output column clearly and note whether it contains formulas or fixed values. That prevents someone from mistaking a temporary conversion column for the original data.

Troubleshooting

  • The formula appears as text instead of calculating. Check whether the cell is formatted as Text, or whether an apostrophe was entered before the equals sign. Change the cell format to General, re-enter the formula, and press Enter. Also check that Show Formulas is not enabled; on Windows, Ctrl+` toggles that worksheet view.
  • The formula returns an error or an unexpected reference. Confirm that the formula is in the output column and references the matching source row. For the first result beside A2, the reference should be A2. If you copied a formula from another row, inspect the cell reference before filling the rest.
  • Flash Fill does nothing. Make sure the examples are in a column beside the source data, that the destination range is selected, and that the examples show the transformation you want. Add a second example if the pattern is not obvious. In desktop Excel for Windows, try Data > Flash Fill if Ctrl+E does not trigger it. If the command is unavailable, use a formula.
  • Only some rows were filled. Check whether the selected range ended too early or whether blank rows interrupted the adjacent data used by the fill handle. Select the exact destination range and fill again, or drag the handle to the last record. For Flash Fill, select the cells that should receive results and check for any skipped rows afterward.
  • The output has the wrong capitalization for certain entries. That is usually a limitation of the chosen rule, not a broken workbook. Restore the original for those records or edit the output manually. PROPER cannot infer every name’s official spelling, and Flash Fill cannot reliably generalize a pattern that the examples do not establish.

Frequently Asked Questions

Is there a keyboard shortcut to capitalize selected text in Excel?
No built-in shortcut directly cycles selected cell text through different cases. On Windows, Ctrl+E runs Flash Fill when you have supplied an example; it is a pattern-based shortcut, not a direct change-case command.

What is the formula to capitalize the first letter of every word?
Use PROPER in a helper cell. If the source text is in A2, =PROPER(A2) returns text with each word’s initial letter capitalized and its other letters lowercased.

Can I use Flash Fill to capitalize names?
Yes. Type one or more correctly capitalized examples beside the source names, select the destination cells, and use Ctrl+E in Excel for Windows. Review results carefully because Flash Fill infers the pattern from your examples.

How do I make every letter uppercase or lowercase?
Use UPPER for all capitals or LOWER for all lowercase, with the source cell in the formula’s reference. Fill the formula down for the rest of the list, then paste values if you need fixed text.

Will capitalization formulas change my original data?
No. A formula in a separate column returns a result without altering the source cell. The source changes only if you deliberately paste the results over it, so keep a copy until you have checked the converted values.

Does Excel have a sentence-case formula?
PROPER is not sentence case because it capitalizes every word. Excel does not provide a simple built-in worksheet function that reliably converts arbitrary text to sentence case; use a suitable custom method if that exact rule is required.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.