Keyboard Shortcut to Capitalize Text in Excel: What Works

How-to basics · Updated November 20, 2026

Excel has no built-in keyboard shortcut that directly changes selected text to uppercase. To capitalize a column quickly, use Flash Fill with Ctrl+E on Windows (Control+E on Mac) after entering an uppercase example, or use the UPPER formula when you want a dependable, repeatable result.

Is there a direct shortcut to change case?

No—not in Excel for Microsoft 365 on Windows. You cannot select a cell or range and press a single shortcut to convert its existing text from lowercase or mixed case to uppercase in place. This is different from Microsoft Word, where Shift+F3 cycles through case options. In Excel, Shift+F3 opens the Insert Function dialog; it does not capitalize the selected text.

The practical shortcut is therefore a way to create uppercase text in another column, rather than a command that transforms the original cells. You can use Flash Fill for a quick one-time conversion, or use a formula if you need a result that updates when the source text changes. Both approaches preserve the original data until you choose to replace it.

This distinction matters when a workbook contains important source data. Keeping the original column lets you check the conversion and recover the original spelling if needed. Once you have verified the result, you can copy the converted cells and paste their values over the originals if that is what the task requires.

Use Ctrl+E with Flash Fill

Flash Fill detects a pattern from examples you enter and fills the rest of a neighboring column to match. It is useful for a quick, one-off capitalization job because the result is regular text, not a formula. For example, suppose A2 contains northwind supplies. Enter NORTHWIND SUPPLIES in B2, then use Flash Fill to apply the same transformation to the remaining entries in column A.

  1. Keep the original text in one column and make sure the cells below your example in the output column are empty.
  2. In the first output cell, type the source text exactly as you want it to appear in uppercase.
  3. Move to the next output cell and press Ctrl+E on Windows. In Excel for Mac, use Control+E.
  4. Review the filled results before using them elsewhere. If the shortcut does not run, choose Data > Flash Fill from the ribbon instead.

Flash Fill is a pattern-recognition feature, so it is not a guaranteed case-conversion command. It may need more examples if nearby rows use different patterns, and it can make an incorrect guess if the data is inconsistent. For a uniform list where every letter should be uppercase, compare the results with the source or choose the formula method below. Flash Fill creates fixed text: changing a source cell later does not automatically update its filled result.

Use the UPPER formula for a reliable conversion

For a consistent transformation, use Excel’s UPPER function. It returns text with lowercase letters converted to uppercase while leaving other characters, such as digits and punctuation, in place. The formula creates a result in a different cell; it does not change the source cell itself.

With the original text in A2, enter this in B2:

=UPPER(A2)

For example, if A2 contains Northwind Supplies, 2026, the result in B2 is NORTHWIND SUPPLIES, 2026. To apply it to more rows, select B2 and drag the fill handle—the small square at the lower-right corner of the selection—down the column. You can also copy B2, select the destination cells, and paste. Excel adjusts the relative reference for each row, so the next row will refer to A3, then A4, and so on.

A formula is usually the better choice when the source list may change, when every row must follow the same rule, or when you need to audit how the result was produced. It also handles a long column without asking Excel to infer a pattern. The trade-off is that the output remains linked to the source: if A2 changes, the result in B2 recalculates.

How to replace the original text with uppercase values

If the final workbook should contain uppercase text in the original column, first create the converted results in a separate column. Check a sample of the output, then copy the converted cells and paste values into the original range. Pasting values removes the formulas while keeping their displayed text.

On Windows, copy the converted range with Ctrl+C, select the matching original range, and press Ctrl+Alt+V to open Paste Special. Choose Values and confirm. You can also use the ribbon path Home > Paste > Values. On Mac, use the Paste Values command from the Home tab or the paste options available in the context menu; shortcut assignments can differ by keyboard and Excel version.

Take care to select the correct destination range: pasting values over the source replaces the original text and cannot be reversed after you close the workbook. Keep a backup or retain the original column until you have checked the result. If you used Flash Fill instead of a formula, its output is already fixed text, but the same review-and-copy precautions apply.

Which method should you choose?

The best method depends on whether you want speed, a repeatable rule, or a final set of fixed values. These options solve related problems, but they do not behave identically:

  • Flash Fill (Ctrl+E): Best for a quick conversion when Excel recognizes the example. It creates fixed text and does not keep a live link to the source.
  • UPPER formula: Best for a large or changing list that should update automatically. It is consistent, but you must paste values if you need to remove the formulas.
  • Manual retyping: Reasonable for a handful of short entries, but slow and prone to transcription mistakes in a longer list.

For example, if you have ten product labels to standardize once, Flash Fill may be the fastest route. If you maintain a monthly report where new labels arrive each month, a formula column is easier to extend and check. If the workbook is shared with others, leaving the source and converted columns side by side can make the transformation transparent.

Common problems and misconceptions

If Ctrl+E does nothing, check that you are using desktop Excel and that there is a clear example in the column beside the source data. Try the ribbon command Data > Flash Fill; if Excel still does not fill the range, enter another example that makes the intended pattern clearer. A blank destination area and a consistently arranged list also help Flash Fill identify what to do.

Another frequent mix-up is expecting a formula to change the original cell. A formula such as =UPPER(A2) displays an uppercase version elsewhere; it cannot overwrite A2 while also referring to A2. That is why a helper column and a later Paste Values step are needed when replacing the source.

Also distinguish uppercase from title case. Uppercase turns every letter into a capital letter, as in EXCEL SHORTCUTS. Title case capitalizes words, as in Excel Shortcuts, and is a different transformation. Excel does not have a direct in-place case-toggle shortcut for either one. For a title-style result, the PROPER function may help, but it capitalizes the first letter of each word and lowercases other letters, which may not suit names or acronyms.

Finally, formulas and Flash Fill do not validate whether the capitalization is appropriate. An acronym, brand spelling, or person’s preferred name may have a special form. Treat automatic conversion as a formatting step and check exceptions rather than assuming every word should follow a general rule.

Excel on Mac and in a browser

In Excel for Mac, Flash Fill is available in supported desktop versions. The keyboard equivalent is Control+E; if your keyboard or version handles the shortcut differently, use Data > Flash Fill. The UPPER function also works in Excel for Mac, and its formula syntax is the same.

Excel for the web supports the UPPER formula, so you can enter it in a helper column and fill it down in a browser. Flash Fill is a desktop Excel feature and is not a dependable web-browser shortcut workflow; use the formula method in the web app. If a workbook will be edited across desktop and web versions, formulas are generally easier to maintain than relying on a one-time Flash Fill result.

Frequently Asked Questions

What is the shortcut to make text uppercase in Excel?
There is no direct in-place uppercase shortcut. Ctrl+E on Windows (Control+E on Mac) runs Flash Fill after you provide an uppercase example, while UPPER is the reliable formula option.

Does Shift+F3 capitalize text in Excel?
No. In Excel, Shift+F3 opens the Insert Function dialog. The Shift+F3 case-cycling shortcut is associated with Word, not Excel.

Can Ctrl+E change text in the same cells?
Flash Fill writes its results into a destination column; it does not directly replace the source cells. To replace the source, copy the results and paste values over the original range after checking them.

How do I capitalize an entire column with a formula?
Put the source text in one column, enter =UPPER(A2) in the adjacent output cell when the first source is in A2, then fill the formula down. Copy and paste values if you need a fixed-text result.

Does UPPER capitalize numbers and punctuation?
It converts lowercase letters to uppercase. Numbers, spaces, and punctuation stay as they are, so a value such as item-42a becomes ITEM-42A.

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.