Capitalize in Excel: Shortcuts and Reliable Alternatives

How-to basics · Updated November 20, 2026

Excel has no built-in hotkey that changes selected text to uppercase or title case. To capitalize existing text, use a formula such as =UPPER(A2), or use Flash Fill with Ctrl+E on Windows when you can show Excel the desired pattern.

Why Excel has no case-change hotkey

Excel treats the capitalization of text as part of the cell’s contents, but unlike Word, it does not provide a Change Case command on the ribbon or a dedicated keyboard shortcut for changing selected text. This is why pressing a familiar Word shortcut in Excel may not do what you expect. The quickest method depends on whether you are entering new text, fixing existing values, or preparing a separate version of a column.

It also helps to distinguish several meanings of “capitalize.” A person might want every letter uppercase, only the first letter of each word uppercase, or just the first letter of a sentence uppercase. Excel’s built-in worksheet functions handle some of these patterns, but they do not all mean the same thing. Choosing the right one matters for names, product codes, addresses, and sentences.

Use UPPER to make every letter uppercase

For a column of existing text, put a formula in an empty cell beside the first value, then fill it down. If A2 contains quarterly sales report, enter this formula in B2:

With the source text in A2, use: =UPPER(A2). For the example, the result is QUARTERLY SALES REPORT.

In Microsoft 365 for Windows, you can drag or double-click the fill handle at the lower-right corner of B2 to copy the formula down alongside the data. Double-clicking usually fills to match the neighboring continuous data range. Check the last rows afterward, especially if there are blank cells in the source column, because those gaps can affect how far Excel fills.

UPPER converts lowercase letters to uppercase and leaves numbers, punctuation, and most other characters unchanged. It is useful for standardizing IDs or codes, but it does not make a cell bold, change its font, or alter the original source cell. The formula creates a result in another cell.

Choose PROPER or LOWER for a different case

If you mean title-style capitalization rather than all capitals, Excel’s PROPER function capitalizes the first letter of each word and converts the other letters to lowercase. It is a mechanical rule, not a grammar-aware title-case tool.

With the source text in A2, use: =PROPER(A2). If A2 contains quarterly sales report, the result is Quarterly Sales Report.

That behavior can be wrong for brand names, acronyms, or names with unusual internal capitals. For example, PROPER can turn a deliberately styled name such as eBay into Ebay, and it may not preserve acronyms as intended. Review those exceptions rather than assuming the formula knows the official spelling.

For lowercase output, use a different function. With the source text in A2, use: =LOWER(A2). If A2 contains Quarterly Sales Report, the result is quarterly sales report. Excel does not have a built-in function that reliably converts arbitrary text to sentence case, where only the first letter of a sentence is capitalized and the rest follows normal sentence rules.

Replace the original text with the results

Formulas are often the safest first step because they leave the source data intact. Once you have checked the results, you can replace the original values if that is what the workbook needs. Copy the formula results, select the original cells, and use Home > Paste > Values. This pastes the displayed text rather than formulas that refer back to the old cells.

For example, if the original values are in A2:A20 and the uppercase results are in B2:B20, copy B2:B20, select A2:A20, and paste values. The original entries are then replaced by capitalized text. If the data matters, keep a backup column or save a copy before overwriting it. After pasting, you can remove the helper column if it is no longer needed.

Do not simply delete the source column while formulas still refer to it. The results may change or produce reference errors. Pasting values first removes that dependency and makes the converted text stand on its own.

Use Flash Fill when you can show a pattern

Flash Fill can create a new column of text by learning from examples you type. It is useful when the desired result is not simply all uppercase or all lowercase—for instance, when you want to capitalize names in a particular way or combine text in a new format. It does not edit the source column directly; it fills neighboring cells with results.

  1. Keep the original text in one column and type the desired version of the first entry in the next column.
  2. Type a second example if the pattern might be ambiguous. For example, show how a two-part name should look as well as a one-part name.
  3. Select the next empty cell in the example column and press Ctrl+E on Windows, or choose Data > Flash Fill.
  4. Review the filled entries for exceptions before using them in a report or replacing source values.

Flash Fill is a pattern-recognition convenience, not a capitalization function with a guaranteed rule. It can guess incorrectly if the examples do not make your intention clear, and later changes to the original data do not necessarily update its results like formula results would. If consistency is essential, a formula or a carefully checked cleanup process may be preferable.

For new text, use Caps Lock or Shift

If you are typing a new entry and want every letter uppercase, press Caps Lock and type the text; press Caps Lock again to return to normal typing. To capitalize just one letter, hold Shift while typing that letter. These are keyboard controls for entering characters, not Excel commands that transform text already stored in cells.

On a Mac, Caps Lock and Shift serve the same basic typing purposes. The exact physical keyboard layout can vary, but there is still no special Excel case-conversion shortcut to apply to selected cell contents. If you need to change text already entered, use a formula, Flash Fill, or another appropriate data-cleanup method.

Common shortcut confusion

A frequent misconception is that Shift+F3 changes the case of selected Excel text. In Excel, Shift+F3 opens the Insert Function dialog; it is not a Change Case command. The shortcut may be familiar to people who use Microsoft Word, where case-changing features are available, but shortcuts and commands do not automatically carry over between Office apps.

Another point of confusion is selecting a cell and typing an uppercase letter. Typing normally replaces the cell’s contents, so it is not a way to capitalize the existing value. To edit a cell, double-click it or select it and press F2, then make the needed changes. For a long column, a formula or Flash Fill is usually more practical than editing every cell individually.

Also, changing the font or applying a formatting style does not convert lowercase characters into uppercase characters. Cell formatting can change appearance—such as font, size, or color—but capitalization is text content. If a report requires actual uppercase letters for copying, exporting, or matching, use a text transformation rather than visual formatting.

Which method should you choose?

The most reliable option depends on the task. Use a formula when you want a repeatable transformation and an easy way to compare results with the original. Use Flash Fill when you can demonstrate a pattern that is awkward to express with a simple case function. Use Caps Lock or Shift when entering new text. For a few existing cells, direct editing may be quicker than setting up a helper column.

  • All uppercase: use UPPER, such as for a batch of codes that must be entered consistently.
  • First letter of each word uppercase: use PROPER, then inspect names and brands that have special spellings.
  • All lowercase: use LOWER when standardizing email addresses or other text where lowercase is appropriate.
  • Custom pattern: try Flash Fill, check the output, and use examples that make the pattern clear.
  • New text only: use Caps Lock for a run of uppercase typing or Shift for a single capital letter.

Think about whether the result should remain connected to its source. A formula updates when its referenced text changes; Flash Fill produces filled text that generally must be refreshed or recreated when the source changes. If the workbook is a recurring report, that difference can determine which method saves time in the long run.

Windows, Mac, and Excel for the web

The formulas UPPER, PROPER, and LOWER work in Microsoft Excel for Microsoft 365 on Windows and Mac, and are also available in Excel for the web. Their names and basic behavior are the same across these platforms. The examples above assume the original text is in A2 and the formula is entered in a neighboring cell.

For Flash Fill, the Windows shortcut is Ctrl+E, and the ribbon route is Data > Flash Fill. On Mac, use the Data tab’s Flash Fill command if it is available in your Excel version; keyboard shortcuts can differ with the Mac keyboard and Excel release. In Excel for the web, formula-based conversion is the dependable choice if a desktop Flash Fill command or shortcut is not available in the interface you are using.

Frequently Asked Questions

What is the shortcut to make text uppercase in Excel?
Excel has no dedicated shortcut to convert selected text to uppercase. On Windows, enter =UPPER(A2) in a neighboring cell and fill it down. For new typing, use Caps Lock.

Does Shift+F3 capitalize text in Excel?
No. Shift+F3 opens the Insert Function dialog in Excel. It does not change the case of the selected cell’s text.

How do I capitalize the first letter of every word?
Use PROPER in a helper cell, such as =PROPER(A2) when the original text is in A2. Check the results for names, abbreviations, and brands with intentional capitalization.

Can I change case without a formula?
Yes. Flash Fill can infer a pattern from examples, and you can manually edit a small number of cells. For a large, straightforward conversion, a formula is usually easier to review and repeat.

How do I keep the capitalized results but remove the formulas?
Copy the result cells, then paste them over the desired destination with Home > Paste > Values. The cells retain the converted text rather than formulas linked to the source.

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.