Capitalize in Excel: Shortcut Keys and Quick Methods

How-to basics · Updated November 20, 2026

Excel has no built-in shortcut that changes selected text from lowercase to uppercase. To capitalize a column, enter =UPPER(A2) in a helper column, fill it down, then copy the results and paste them as values. For title-style capitalization, use =PROPER(A2). On Windows, Ctrl+E can also run Flash Fill when you provide an example of the format you want.

What You’ll Need

  • A workbook open in Excel for Microsoft 365, preferably the desktop app on Windows for the shortcut steps below.
  • The text you want to change, with an empty column beside it if you plan to use a formula.
  • Optional: a clear example of the desired capitalization if you plan to use Flash Fill.

Save the workbook before making a large change. Formulas and Flash Fill put their results in cells; they do not automatically rewrite the original text. You can keep the original column as a backup until you have checked the output.

Step-by-Step

  1. Choose what “capitalize” means for your text. If every letter should be uppercase, use UPPER. If you want the first letter of each word uppercase and the remaining letters lowercase, use PROPER. If you only want the first character of each cell uppercase while leaving the rest as-is, use Flash Fill or a different formula approach; PROPER changes the rest of each word to lowercase, too. For example, PROPER changes “mACDONALD” to “Macdonald,” which may not be right for names with unusual spelling.
  2. Check the source cells and choose a blank output column. For example, if the original entries are in A2:A20, click B2. Do not put the formula over the source cell: the formula needs to refer to the original text, and replacing the source can cause a circular reference. If you are working in an Excel Table, add a new table column and enter the formula in its first data row.
  3. Enter the case formula. With the source text in A2 and the output cell selected as B2, type =UPPER(A2) for all capitals, or =PROPER(A2) for title-style capitalization. Press Enter. The result should appear in B2. For example, UPPER turns “quarterly report” into “QUARTERLY REPORT”; PROPER turns it into “Quarterly Report.”
  4. Fill the formula down the list. Select B2 again and point to the small square at the lower-right corner of the cell, called the fill handle. Double-click it to copy the formula down alongside a continuous list in column A. Alternatively, drag the fill handle to the last row, or select the output range and press Ctrl+D on Windows. Check the bottom of the list to make sure every source row received a result. If neighboring cells contain gaps, double-clicking the fill handle may stop early, so drag or fill a selected range instead.
  5. Review the transformed text before replacing anything. Compare several results with their originals, including names, acronyms, hyphenated words, and entries with punctuation. PROPER applies general word capitalization; it does not know that a brand, abbreviation, or surname should follow a special style. Correct exceptions in the output column before you turn the formulas into fixed text.
  6. Replace formulas with their displayed text if that is your goal. Select the completed output range and press Ctrl+C. Keep the range selected, then choose Home > Paste > Values. This pastes the text results instead of formulas. On Windows, Ctrl+Alt+V opens Paste Special; press V, then Enter to choose Values. The output cells now contain fixed text rather than formulas that depend on the source column.
  7. Put the finished values in the original column only if needed. After checking the pasted values, copy them and paste values over the source cells. Do this only if you no longer need the original wording, or keep an untouched backup column or sheet. If the original column contains formulas, replacing it with text will remove those formulas, so confirm what the cells contain first.
  8. Use Flash Fill for a custom pattern instead of a formula. Type the desired result beside the first source entry. For example, if A2 contains “jANE doe” and you want “Jane doe,” type that exact result in B2. Start the next result in B3; Excel may preview the pattern. If the preview is correct, press Enter. If no preview appears, select the output range and choose Data > Flash Fill, or press Ctrl+E on Windows. Inspect the results because Flash Fill infers a pattern from examples rather than applying a capitalization rule.

On Mac, the formulas work the same way. Use Command+C to copy, then use Home > Paste > Values to convert formula results to text; the Windows Ctrl+Alt+V sequence is not the Mac shortcut. Flash Fill is available through Data > Flash Fill in desktop Excel for Mac, though its keyboard shortcut can differ by keyboard and Excel setup. In Excel for the web, formulas are a dependable option; menus and available keyboard shortcuts can differ from the desktop app.

Common Mistakes

  • Expecting a case-change shortcut like Word’s. Shift+F3 is not Excel’s uppercase/lowercase toggle; in Excel it opens the Insert Function dialog. Excel does not have a native shortcut that directly changes the case of selected cell contents. Use a formula or Flash Fill instead.
  • Using PROPER when only the first character should change. PROPER lowercases the rest of each word, which can damage acronyms, product names, or deliberately mixed-case text. Review unusual entries and use Flash Fill when you need a specific pattern.
  • Forgetting to replace formulas with values. If you delete or move the original cells, formulas such as =UPPER(A2) may show errors or change their results. Paste values before removing the source, and verify the output first.
  • Overwriting data without a backup. Pasting values over the source column is permanent unless you undo immediately. Keep a copy of the original data until you are satisfied with the capitalization and any exceptions.
  • Assuming Flash Fill understands every exception. Flash Fill may follow the wrong pattern if examples are inconsistent or the data has several different formats. Provide representative examples and check the entire filled range.

Tips

  • Use UPPER for codes and labels. It is usually suitable for inventory codes, state abbreviations, or headings that must be all caps. It changes letters only; digits and punctuation stay as they are.
  • Use PROPER for ordinary names and headings, but inspect the output. It can be a quick first pass for names or title-style text, not a reliable style editor. Some names and acronyms have conventions that do not match automatic title casing.
  • Keep the source and result side by side while checking. A temporary helper column makes mismatches easy to spot. Once reviewed, paste values where you need the final text and remove the helper column if it is no longer useful.
  • Use the fill handle or Ctrl+D to avoid retyping. After entering one formula, fill it through the whole data range. Excel adjusts the reference from A2 to A3, A4, and so on when the reference is relative.
  • Work on a selected range, not an entire worksheet. Select only the rows containing the data. This makes it easier to review the results and reduces the chance of changing unrelated cells.
  • Remember that capitalization changes text, not cell formatting. Changing the font or applying a format does not convert the underlying letters to uppercase. UPPER, PROPER, or an accurately defined Flash Fill pattern changes the displayed text itself.

Troubleshooting

  • The formula appears as text instead of a result. Check whether the cell is formatted as Text or the entry begins with an apostrophe. Change the cell format to General, then edit the formula and press Enter again. Merely changing the format may not recalculate a formula already stored as text.
  • The formula returns an unexpected result. Confirm that the reference points to the intended source cell and that you chose the right function. UPPER makes all letters uppercase; PROPER applies first-letter capitalization to each word. If you need only the first character changed, neither function is an exact match.
  • Some rows did not fill down. Look for a blank in the source data or a break in the adjacent column that could have stopped the fill handle. Select the full destination range manually and use Ctrl+D on Windows, or copy the first formula and paste it into the remaining selected cells.
  • Flash Fill does not show a preview. Enter a second example that makes your intended pattern clearer, then select the destination cells and choose Data > Flash Fill. Make sure there is a consistent relationship between the source and examples. If it still cannot infer the pattern, use a formula for standard case changes or edit the results manually.
  • Paste Values is unavailable or pastes the wrong thing. Copy the formula results first, then select the destination and choose Home > Paste > Values. If you use Paste Special, confirm that Values is selected in the dialog. On Mac, use the ribbon menu if the Windows keyboard sequence does not work.

Frequently Asked Questions

What is the shortcut key to capitalize text in Excel?

Excel has no built-in shortcut to switch selected cells to uppercase or title case. On Windows, Ctrl+E runs Flash Fill when Excel can infer a pattern from examples. For a consistent change, use UPPER or PROPER in a helper column.

Does Shift+F3 capitalize text in Excel?

No. Shift+F3 opens Excel’s Insert Function dialog; it does not change the case of selected text. That shortcut is often confused with the case-changing shortcut in Microsoft Word.

How do I make all text uppercase without retyping it?

If the text is in A2, enter =UPPER(A2) in a blank cell and fill the formula down. Copy the results and use Home > Paste > Values if you need fixed text rather than formulas.

How do I capitalize the first letter of every word?

Use =PROPER(A2) in a helper column and fill it down. Check names and abbreviations because PROPER may change letters that should remain lowercase or uppercase for a particular style.

Can I change the text in place with a formula?

Not directly in the same cells: a formula needs a separate cell to refer to the original without creating a circular reference. Use a helper column, review the results, then copy and paste values over the original if you want to replace it.

Do these methods work in Excel for Mac or the web?

UPPER and PROPER work in Excel for Mac and Excel for the web. Ribbon locations and shortcuts can differ. On Mac, use the Paste Values command from the ribbon if Windows shortcuts do not apply; on the web, use the available Data and Paste menus or the formula method.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.