Excel Uppercase to Lowercase: Shortcut and Formula

Formulas & functions · Updated November 20, 2026

Excel has no dedicated keyboard shortcut that changes selected text from uppercase to lowercase. The dependable method is to enter =LOWER(A2) in a neighboring cell, assuming the text to convert is in A2, then fill the formula down; for a one-off conversion, Flash Fill with Ctrl+E may be quicker.

Is there a dedicated shortcut?

No. Microsoft Excel for Microsoft 365 on Windows does not provide a built-in case-toggle key for turning selected cell contents into lowercase. Shortcuts such as Shift+F3, which changes letter case in some other Microsoft Office applications, do not perform that task in Excel. Pressing Ctrl+E in Excel runs Flash Fill; it is a pattern-based tool, not a direct command to lowercase a cell.

This distinction matters because Excel cells can contain formulas, numbers, dates, and other values as well as text. A shortcut that silently rewrote a selection could damage data or formulas. Excel instead offers functions and fill tools that let you create converted text in a separate location and decide whether to keep it.

If you need the original capitalization preserved, use LOWER in a new column. If you need to replace the source text, convert it first and then paste the results as values. Keeping the source until you have checked the output is the safest approach, especially for names, identifiers, and imported lists.

Convert text with the LOWER function

LOWER is Excel’s standard function for converting text to lowercase. It changes uppercase letters to their lowercase equivalents, leaves lowercase letters as they are, and does not change numbers or punctuation. It is useful whether a cell contains all-capital text, mixed case, or text that is already lowercase.

With the text to convert in A2, enter this in B2; if A2 contains HELLO, the result in B2 is hello:

=LOWER(A2)

Press Enter to calculate the result. The formula does not alter A2: it displays a lowercase result in B2 while the original remains in place. If A2 contains a phrase such as EXCEL SHORTCUTS!, the returned text is excel shortcuts! The space and exclamation mark stay the same because LOWER changes letter case, not the contents or order of the text.

To convert a range, copy or fill the formula down alongside the source cells. For instance, if the source list runs from A2 through A100, put the formula in B2 and drag its fill handle down to B100, or select B2:B100 after entering the first formula and use Ctrl+D to fill down. Excel adjusts the reference in each row, so the formula in B3 refers to A3 and the one in B100 refers to A100.

Apply the conversion to a whole column

A simple two-column workflow is often best for a list of product names, email addresses, or imported records. Keep the source in one column, create lowercase output next to it, and check a sample before replacing anything. These steps work in Excel for Microsoft 365 on Windows:

  1. Add a heading such as Lowercase in the column next to your original data.
  2. In the first data row, enter the LOWER formula using that row’s source cell.
  3. Fill the formula down through the last row. Double-clicking the fill handle can extend it alongside a neighboring continuous data range; check that it reaches the intended final row.
  4. Review the output for blanks, unusual characters, and any rows where a value should retain special capitalization.
  5. If a fixed text result is needed, copy the converted cells and use Home > Paste > Paste Special > Values to replace formulas with their displayed text.

In a structured Excel table, entering a formula in the first row of a new table column usually fills the calculated column automatically. If it does not, fill the formula down as you would in an ordinary range. Formulas are useful when the source may change: if A2 is edited later, its LOWER result updates. Pasted values do not update, which can be an advantage for a final export or a fixed record.

Use Flash Fill for a quick one-off

Flash Fill can infer a text pattern from examples and fill neighboring cells with matching results. To use it for lowercase conversion, type the lowercase version of the first source value into the adjacent cell. If the source cell contains JORDAN LEE, type jordan lee beside it. Start the next example if needed, then press Ctrl+E on Windows or choose Data > Flash Fill. Excel fills the remaining rows when it recognizes the pattern.

Flash Fill is convenient when you want a quick set of results without writing a formula. Unlike LOWER, it produces fixed text rather than a live calculation linked to the source. If the original entry changes afterward, the filled result will not automatically follow it. Flash Fill can also misunderstand a pattern, so inspect the results before using them in a report or replacing original data.

On Excel for Mac, use Data > Flash Fill when the command is available in your version; Control+E is the corresponding shortcut in supported versions. Excel for the web may not offer the same Flash Fill controls as the desktop app, so use the LOWER formula there if the command is unavailable. The formula-based approach is also more predictable when the list is long or must stay synchronized.

Replace the original text safely

LOWER returns its result in a different cell. It cannot be entered over the source cell as a way to convert that same cell: a formula referring to its own cell would create a circular reference. To finish with lowercase text in the original location, use a temporary output column and then replace the source with the converted values.

For a small range, copy the lowercase output, select the matching original cells, and choose Home > Paste > Paste Special > Values. On Windows, Ctrl+Alt+V opens the Paste Special dialog; choose Values and confirm. The exact dialog options can vary slightly by Excel version. On Mac, use the Paste Special or Values option from the Home tab or the context menu, since keyboard shortcuts differ between Mac and Windows.

Before replacing a large or important range, save a separate copy of the workbook or retain the source column until you have verified the pasted results. Pasting values removes formulas from the destination cells, and replacing the only copy of the original text makes the previous capitalization harder to recover. Ctrl+Z may undo a recent paste, but it should not be treated as a substitute for a backup.

What changes—and what stays the same

LOWER changes letters to lowercase; it does not clean, standardize, or validate the rest of a value. Leading or trailing spaces remain, as do internal spaces, hyphens, apostrophes, digits, and punctuation. For example, an address containing a capital letter becomes lowercase, but an accidental space at the end of the cell remains. If spaces are a problem, inspect or clean them as a separate step rather than assuming a case conversion will remove them.

Lowercasing can also affect proper names and abbreviations. The result of turning MCDONALD or NASA into lowercase is mechanically correct as a case conversion, but it may not match the preferred spelling of a person, organization, or brand. A column containing both ordinary words and special names may need individual review or a separate exception list.

Excel formulas compare text without regard to case in many common operations, but the way text is displayed still matters to readers and downstream systems. A database, website, or software import may have its own rules for identifiers and passwords. Do not assume that changing the case of an email address, username, code, or password is harmless: confirm the requirements of the system receiving the data.

Common problems and fixes

  • The formula appears as text. 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; changing the format alone may not recalculate text already entered.
  • The result does not change when the source changes. Confirm that you used a formula rather than Flash Fill or pasted values. Also check that Excel calculation is set to Automatic under Formulas > Calculation Options.
  • Only the first row converted. The formula must be filled down for the rest of the list. Use the fill handle or select the destination cells and press Ctrl+D on Windows after entering the formula in the top cell.
  • Some rows look wrong or are missing. Check for blank source cells, unexpected spaces, and special capitalization that should not be lowercased. Flash Fill results especially should be reviewed because Excel is inferring a pattern rather than applying a case function to every entry.
  • The original data disappeared. A formula normally leaves its source cell intact, but pasting values over the source replaces it. Undo immediately if possible, or restore the data from a saved copy or other source.

Choosing between LOWER and Flash Fill

Use LOWER when accuracy, repeatability, or automatic updates matter. It applies the same clear rule to each referenced cell, can be copied down a long list, and recalculates when the source changes. It is usually the better choice for recurring work, files that other people will maintain, or data that will be refreshed.

Choose Flash Fill for a short, one-time transformation when you prefer to see and review the resulting text rather than keep formulas. It can save a few steps, but its pattern recognition is not a guarantee that every row will be right. For either method, keep the original column until you have reviewed the conversion; then paste values if you need a static result.

There is no need to use a macro or add-in for ordinary lowercase conversion. LOWER is built into Excel and is easier to audit, while Flash Fill is available for many quick pattern-based tasks. If you have to preserve selected acronyms or name spellings, a simple blanket conversion may not be appropriate; handle those exceptions deliberately instead of expecting Excel to infer editorial preferences.

Frequently Asked Questions

What is the shortcut to change uppercase to lowercase in Excel?
Excel has no dedicated case-change shortcut. Use the LOWER function for a reliable conversion, or try Ctrl+E on Windows to run Flash Fill after providing a lowercase example.

Does Ctrl+E make text lowercase?
No. Ctrl+E runs Flash Fill. It may generate lowercase text if Excel recognizes the example pattern you supplied, but it is not a direct lowercase command.

Can I convert text to lowercase without a formula?
Yes. Type a lowercase example in the next column and use Flash Fill from Data > Flash Fill or press Ctrl+E on Windows. Review the generated results because Flash Fill can miss or misread a pattern.

How do I change the original cells instead of making a second column?
Convert the text in a temporary column, copy the results, and paste them into the source range using Paste Special > Values. Keep a backup or the original column until you have confirmed the replacement.

Does LOWER change numbers or punctuation?
No. LOWER changes letter case only. Digits, spaces, and punctuation remain as they are, so it will not remove extra spaces or correct spelling.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.