Excel does not have a dedicated keyboard shortcut that changes selected lowercase text to uppercase in place. The quickest dependable method is to use the UPPER function, or, for a one-off conversion, use Flash Fill with Ctrl+E on Windows.
Is there a direct uppercase shortcut in Excel?
No built-in Excel shortcut works like Word’s Change Case command: selecting cells and pressing a key combination will not automatically turn their contents into uppercase. Excel does have shortcuts for editing, filling, and pasting, but case conversion is normally done with a text function or Flash Fill.
This distinction matters because a worksheet cell contains data, not just text displayed on screen. To change its letters, Excel needs an instruction that produces uppercase text, such as a formula, or a one-time pattern that Flash Fill can recognize. The best option depends on whether you want a repeatable result, a quick static copy, or an update to the original cells.
- For a repeatable result: use
UPPER. - For a fast one-time transformation: try Flash Fill with Ctrl+E on Windows.
- To replace the original values: create uppercase results, then paste them back as values.
Use the UPPER function
UPPER converts the letters in text to uppercase. It leaves numbers and punctuation as they are, so a value such as Order #ab-27 becomes ORDER #AB-27. The function does not change the source cell; it returns the converted text in the cell containing the formula.
With the original text in A2, enter this formula in B2:
=UPPER(A2)
For example, if A2 contains north region, B2 displays NORTH REGION. To apply the formula to more rows, select B2 and drag the small fill handle at the lower-right corner of the cell down the column. You can also copy B2, select the destination cells below it, and paste. Excel adjusts the reference for each row, so the next formula refers to A3, then A4, and so on.
This approach is useful when the original values need to remain available or when the uppercase result should update if the source text changes. It works in Microsoft 365 for Windows, Excel for Mac, and Excel for the web. If you are converting a large list, keeping the input and result in separate columns also makes it easier to review the transformation before replacing anything.
Replace the original text with uppercase values
If you want the cells themselves to contain uppercase text, use a temporary output column. This avoids overwriting the source before the conversion is complete.
- Suppose the original entries are in A2:A100. Enter
=UPPER(A2)in B2. - Fill the formula down through B100 and check a few results, including any entries with numbers, punctuation, or unusual characters.
- Select the completed results in B2:B100 and copy them.
- Select A2, then choose Home > Paste > Values to put the converted text over the original entries.
- Confirm that the original column now contains the uppercase values, then delete the temporary column if you no longer need it.
Paste Values is important: a normal paste would put formulas into column A, where they would refer back to cells in the same column and could create circular references. On Windows, Excel also offers Paste Special commands, but the ribbon path is easy to recognize and works across common desktop setups. On Mac, use Home > Paste and choose the values option; ribbon layout can vary slightly by Excel release.
Use Flash Fill for a quick one-time conversion
Flash Fill can infer a transformation from an example and fill the rest of a neighboring column. For instance, if A2 contains maple street, type MAPLE STREET in B2. Select B3 or the cells where you want the rest of the results, then press Ctrl+E on Windows. You can also choose Data > Flash Fill.
Flash Fill is convenient when you do not want formulas, but its output is static: it will not recalculate if the source text changes. Check the filled values before relying on them, especially if the column contains inconsistent formats or entries that could be interpreted in more than one way. If Excel does not recognize the pattern, provide another example or use UPPER instead.
On Mac, the Data tab’s Flash Fill command is a straightforward alternative if the Windows shortcut does not work in your setup. In Excel for the web, use the formula method if Flash Fill is unavailable. The function-based approach is more predictable when the list is long or the conversion must be repeated.
Convert a range and keep the result manageable
For a long list, a formula column is usually easier to check and maintain than editing entries one at a time. Give the columns clear headings, such as Original and Uppercase, and keep the original data until you have verified the output. This is especially helpful when the values include customer names, product codes, or imported records.
In Microsoft 365, you can also use a spilling formula when you want to convert a contiguous range at once. With source text in A2:A10, enter =UPPER(A2:A10) in an empty cell outside the source range. Excel returns the uppercase results in the cells below it, provided those cells are clear. If the formula reports a spill error, check for existing content or merged cells blocking the output. For a workbook that may be opened in an older Excel version, a formula filled down one row at a time is more compatible.
When the converted results must replace the source range, copy the results and paste values over the source. Do not place a spilling formula inside the range it is trying to convert; the formula needs a separate output area.
Other ways to change letter case
Uppercase is one of several common text transformations. Excel’s built-in text functions include LOWER for lowercase and PROPER for capitalizing the first letter of each word. For example, with text in A2, =LOWER(A2) returns lowercase text and =PROPER(A2) returns a title-style result such as Maple Street. These functions also return results in another cell rather than changing the source directly.
For repeated data-cleaning work, Power Query can apply a case transformation as part of an import or refresh process. In the Power Query Editor, select the text column and choose Transform > Format > UPPERCASE. The exact availability of Power Query depends on the Excel platform and version; it is commonly used in desktop Excel for Windows. For a single column that only needs a quick conversion, a formula is generally simpler.
Find and Replace is not a practical way to convert every lowercase letter to uppercase: it replaces particular text with specified text and does not apply a general case transformation to arbitrary words. Formatting the cell with a font or number format also does not change the underlying letters.
Choose the method that fits your task
Think about whether the conversion should update when the source changes, whether you need to overwrite the original, and how much of the process you expect to repeat.
- Choose UPPER when accuracy and repeatability matter, or when you want to inspect the results before using them.
- Choose Flash Fill for a quick, one-time conversion when Excel recognizes the example pattern.
- Choose Power Query when uppercase conversion is one step in a recurring data-import or cleanup process.
- Use Paste Values after checking formula results if the final column must contain fixed uppercase text rather than formulas.
There is no need to change the source data if you only need uppercase text for a report or display. Keeping the original and converted versions side by side can be safer, particularly when case may carry meaning in a code or identifier.
Common problems and checks
If a formula appears as text instead of producing a result, check whether the cell is formatted as Text or whether an apostrophe was entered before the equals sign. Change the cell format to General, then re-enter the formula. Also confirm that the formula begins with an equals sign.
If Flash Fill changes only some rows or guesses incorrectly, undo the result and use the UPPER function. Flash Fill predicts from examples; it is not a universal case-conversion command. A formula applies the same defined transformation to every referenced value, which makes its behavior easier to verify.
Another common surprise is expecting uppercase conversion to alter numbers. It does not: ab45 becomes AB45, while 4512 remains 4512. Spaces and punctuation are retained as well. Finally, remember that formula results depend on the source cells until you paste them as values. If you delete the source too soon, a formula-based result may no longer show the intended text.
Frequently Asked Questions
What is the shortcut to make lowercase letters uppercase in Excel?
There is no dedicated direct shortcut for changing selected cells in place. Use =UPPER(A2) in a neighboring cell, or use Flash Fill with Ctrl+E on Windows after entering an uppercase example.
Does Ctrl+Shift+U change text to uppercase in Excel?
No. Excel does not use Ctrl+Shift+U as a built-in change-case command. Use the UPPER function or Flash Fill instead.
How do I make the change permanent?
Convert the text in a separate column, copy the finished results, and use Home > Paste > Values over the original cells. This replaces formulas with fixed uppercase text.
Can I change a whole column to uppercase at once?
Yes. Enter =UPPER(A2) beside the first entry and fill the formula down. In Microsoft 365, a range formula such as =UPPER(A2:A100) can spill results into empty cells.
Does UPPER change numbers or punctuation?
No. It changes lowercase letters to uppercase and leaves numbers, spaces, and punctuation intact. For example, ref-ab 23 becomes REF-AB 23.
Related
- Excel Remove Numbers From Cells and Keep Text Easily
- Excel Reference Table in a Data Validation List
- Excel RANK vs RANK.EQ: Differences, Ties, and Examples
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Delete a Blank First Page in Microsoft WordTo delete a blank first page in Microsoft Word, show formatting marks, remove any empty paragraphs or page…
- How to Compare Two Excel Sheets: A Practical GuideTo compare two Excel sheets, first make sure corresponding data is in the same positions, then use a…
- How to Archive Years of Emails in OutlookTo archive years of email in Outlook, search for messages older than a chosen date, review the results,…
- Cannot Find Data Validation in Excel? Here’s WhereIn Excel for Microsoft 365 on Windows, select a cell and open Data > Data Tools > Data…
- Conditional Formatting Access in Excel: Where to Find ItIn Excel for Microsoft 365 on Windows, access conditional formatting from Home > Conditional Formatting. Select the cells…
- Excel Data Validation Examples and Setup TipsExcel data validation examples include dropdown lists for status fields, number limits for quantities, date rules for deadlines,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.