Excel All Caps Shortcut: The Fastest Ways to Change Case

Excel has no built-in keyboard shortcut that changes selected text to all caps. To convert text reliably, enter =UPPER(A2) in a helper column and fill it down; for a quick one-time conversion, use Flash Fill with an uppercase example and press Ctrl+E on Windows or Control+E on Mac.

Is there a built-in all-caps shortcut?

No. Excel for Microsoft 365 on Windows does not provide a Word-style Change Case command or a keyboard shortcut that switches selected cell contents to uppercase. This distinction matters: selecting a range and pressing a familiar case-toggle shortcut from another Office app will not convert the text in Excel.

One shortcut that can cause confusion is Ctrl+Shift+U. In Excel for Windows, it expands or collapses the formula bar; it does not change the case of cell contents. The formula bar shortcut changes how much of a formula or cell entry is visible, not the underlying data.

For a repeatable change, use Excel’s UPPER function. For an immediate result without writing a formula, Flash Fill can recognize a case pattern from an example. These methods produce uppercase text, whereas changing a font or cell format does not actually convert lowercase letters.

Use UPPER for a dependable conversion

UPPER changes lowercase letters in text to uppercase. It leaves digits, punctuation, and other characters without letter case unchanged. Because it is a worksheet function, it is a good choice when you have many rows, want a result that updates when the source changes, or need a clear audit trail of the conversion.

With the original text in A2, enter this formula in B2. For example, if A2 contains Northwind sales, the result in B2 is NORTHWIND SALES.

With the source text in A2, enter =UPPER(A2) in B2; the example returns NORTHWIND SALES.

Put a heading such as Uppercase in B1, then enter the formula in B2.
Press Enter and check that the displayed result has the intended capitalization.
Copy the formula down the column. You can drag the fill handle at the lower-right corner of B2, or select the formula cell and the cells below it, then use Ctrl+D on Windows or Command+D on Mac to fill down.
Keep column A if you need the original wording, or replace it with the converted results after checking them.

The reference A2 is relative. When the formula is filled into B3, Excel changes the reference to A3, then to A4 and so on. If the source range is an Excel table, a formula entered in the first row of a new table column will usually fill through that calculated column automatically. A formula result is not a permanent edit to the source cell: it is displayed in B while the original value remains in A.

Convert a column with Flash Fill

Flash Fill is useful when you want a one-time set of converted values and prefer not to keep formulas. It detects a pattern from examples in neighboring data. To use it, put an uppercase version of the first source entry in the adjacent column, then start the next entry or select the destination cells and choose Data > Flash Fill. The Windows shortcut is Ctrl+E; in Excel for Mac, use Control+E where that shortcut is available, or use the Data tab command.

For instance, if A2 contains mira chen, type MIRA CHEN in B2. When Excel recognizes the pattern, it previews uppercase versions of the remaining entries. Accept the preview to populate the column. Check a few results, especially when the source contains unusual punctuation, abbreviations, or inconsistent spacing. Flash Fill generates values rather than formulas, so later edits to column A do not automatically update the results.

If no preview appears, make sure the example is next to the source data and that the entries follow a consistent pattern. You can also use Data > Flash Fill explicitly after providing the example. Flash Fill is a pattern-recognition tool, not a general formula engine; if the pattern is ambiguous, a formula is usually more dependable.

Choose the method that fits the job

The right approach depends on whether the conversion should be permanent, repeatable, or easy to refresh. These practical differences can help you decide:

Use UPPER when accuracy and repeatability matter, when the list is long, or when source entries may change. The result updates with the source, but it occupies a separate cell until you replace the original data.
Use Flash Fill for a quick, one-time transformation when the values share a clear pattern. It gives you static results and avoids maintaining formulas, but you should inspect its output.
Use Power Query for a recurring import or cleanup process. In Excel for Microsoft 365 on Windows, load or select a query table, then use Transform > Format > UPPERCASE in the Power Query Editor. Load the transformed data back to Excel and refresh the query when the source changes. Power Query availability and features can differ on Mac.

There is no need to convert case just to make an ordinary Excel lookup work. Many standard Excel comparisons, including common lookup operations, do not distinguish between uppercase and lowercase text. Case can still matter to readers, exported files, systems that require a particular format, and case-sensitive operations. Decide whether the goal is visual consistency or a real change to the text before altering a source list.

Replace the original values safely

If a final file must contain uppercase text in the original column, first calculate the results in a separate column. Review them, then copy the completed results. Select the original destination and use Home > Paste > Paste Values. This replaces formulas or source entries with their displayed text values, without leaving a live link to the helper column.

Keep a copy of the original data until you have confirmed the replacement. If the source is important, make a duplicate worksheet or save a separate workbook before overwriting it. For a table with formulas, filters, or downstream references, check those dependencies: replacing cells can affect other calculations even when the uppercase text itself is correct.

Flash Fill already returns static values, so it does not need a paste-values step. However, if it filled a helper column, you still need to copy those results into the original column if that is where the final text belongs. Avoid pasting over the source before checking the preview or the full output.

Common problems and misconceptions

The formula is visible instead of its result. The cell may be formatted as Text, or Excel may be displaying formulas. Set the cell format to General, re-enter the formula, and check the Formulas tab’s Show Formulas setting. A leading apostrophe before an equals sign also makes an entry literal text rather than a formula.

Some entries keep their spaces. UPPER changes letter case; it does not trim leading or trailing spaces, remove line breaks, or standardize punctuation. Inspect imported data separately if spaces are causing a problem. Do not assume that uppercase conversion also cleans or validates a list.

Names and acronyms look wrong after a different case function. UPPER makes every cased letter uppercase. PROPER instead capitalizes the first letter of each word, which can turn an acronym such as NASA into Nasa and may not handle every name convention correctly. For an all-caps requirement, UPPER is the relevant function.

The source column did not change. That is expected when you use a helper-column formula: the formula returns a new value elsewhere. To make the change permanent, use Paste Values after review, or use Flash Fill to create static output and then move it into place.

Frequently Asked Questions

What is the Excel shortcut for all caps?

There is no built-in Excel shortcut to convert selected cell text to all caps. Use the UPPER function for a formula-based conversion, or use Flash Fill with an uppercase example and Ctrl+E on Windows. On Mac, try Control+E or select Data > Flash Fill.

Does Ctrl+Shift+U make text uppercase in Excel?

No. In Excel for Windows, Ctrl+Shift+U expands or collapses the formula bar. It does not change the case of a cell’s contents. Use UPPER or Flash Fill instead.

Can I change case without a formula?

Yes. Enter an uppercase example in a neighboring column and use Flash Fill to generate the rest. Excel does not have a standard Change Case command for selected cells, so Flash Fill is the built-in no-formula option for this kind of one-time conversion.

Will UPPER change numbers or punctuation?

UPPER changes letters that have lowercase and uppercase forms. Digits and punctuation remain visually unchanged. It also does not remove spaces or rewrite the wording; it changes case rather than cleaning the text.

How do I make the uppercase result replace the original text?

Generate and check the results in a helper column, copy them, then select the original cells and use Home > Paste > Paste Values. Keeping a backup first is prudent because replacing the source removes the original entries.

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.