Lowercase Shortcut Key in Excel: Fast Ways to Change Case

How-to basics · Updated November 20, 2026

Excel has no built-in keyboard shortcut that directly changes selected text to lowercase. The dependable method is to use the LOWER function, then copy the results and paste them as values if you need to replace the original text; for a quick one-off pattern, Flash Fill may also work.

Why Excel Has No Direct Lowercase Shortcut

Microsoft Excel for Microsoft 365 on Windows does not provide a dedicated case-toggle key for worksheet cells. This is different from some Microsoft Office apps, where a keyboard shortcut can change the capitalization of selected text. In Excel, cell contents are data, so changing their case is generally done with a function, a data tool, or a macro rather than a formatting command.

Some familiar keys are easy to mistake for a case shortcut. Shift+F3 opens the Insert Function dialog; it does not convert selected text. Ctrl+Shift+A can insert argument names after a function name in some formula-editing situations, but it does not change cell case either. If you have seen a shortcut that changes capitalization, it may apply to Word or another program, not Excel cells.

Excel also does not have a ribbon button that simply turns the contents of selected cells to lowercase. The Home tab’s font controls affect how text looks, not whether its stored letters are uppercase or lowercase. To change the actual text, use one of the methods below.

Use the LOWER Function

LOWER converts uppercase letters in text to lowercase and returns the converted text in the cell containing the formula. It leaves spaces, punctuation, and digits as they are. For example, with the original text Quarterly Report in A2, enter this in B2:

With the text to convert in A2, enter =LOWER(A2) in B2. If A2 contains Quarterly Report, B2 displays quarterly report.

To apply the conversion to many rows, put the formula beside the first source value, then fill it down. In Windows Excel, you can select the formula cell and the cells beneath it in the same column, then press Ctrl+D to fill down from the top cell. You can also drag or double-click the fill handle, the small square at the lower-right corner of the selected cell. Check the last row of the results to make sure the fill range matches your data.

The formula result updates if the source cell changes. That is useful for a working dataset, but it also means the converted column is not an independent copy yet. If you need permanent lowercase text in place of the source, use the paste-values procedure in the next section.

Convert a Whole Column and Replace the Original Text

For a safe conversion, keep the source column until you have checked the results. Suppose the names to convert are in A2:A100. Use a spare column for the LOWER formula, fill it down through the corresponding rows, and review the output. Then copy the results and paste only their values over the original cells if replacing the source is your goal.

  1. Insert a blank helper column next to the text, or choose another empty area of the worksheet.
  2. In the first helper cell, enter the LOWER formula referring to the first source cell, then fill it down to the final row.
  3. Review a few results, including entries with spaces, punctuation, and numbers.
  4. Copy the helper cells. Select the original cells, then use Home > Paste > Values. On Windows, Ctrl+Alt+V opens Paste Special; choose Values and confirm. The ribbon command is an alternative if your keyboard layout or Excel version uses a different shortcut.
  5. After checking that the original cells now contain the intended text, remove the helper column if you no longer need it.

Paste Values removes the formulas and leaves their displayed results behind. This avoids a circular reference, which would occur if you tried to put a formula in a cell that refers to itself. It also gives you a chance to preserve the source until you know the converted values are correct. On Excel for Mac, use the Paste Values command from the ribbon or context menu if the Windows Paste Special shortcut differs on your keyboard. In Excel for the web, use the available Paste Values option in the Home ribbon or paste menu.

Convert Two Cells Into One Lowercase Result

LOWER can also convert text assembled from multiple cells. This is useful when a name, label, or address is split across columns and the output should be one lowercase string. The ampersand joins the cell contents, and the quoted space inserts a space between them.

With a first name in A2 and a surname in B2, enter =LOWER(A2&" "&B2) in C2. If A2 contains Ana and B2 contains Ng, the result is ana ng.

This formula combines the values but does not change either source cell. As with a simple LOWER formula, fill it down for additional rows. If the source cells contain unwanted spaces, the combined result keeps those spaces; LOWER changes letter case, not spacing or spelling. Clean up the source separately if you need to standardize those details.

Use Flash Fill for a Quick One-Off Change

Flash Fill can recognize a pattern from an example and fill the rest of a column. It is helpful when you want a quick set of lowercase results without writing a formula, especially for a small list. It is pattern-based rather than a live transformation, so its output will not automatically update when the source changes.

  1. Keep the original text in one column and type the lowercase version of the first item in the adjacent column.
  2. Start typing the next lowercase result if Excel has not already suggested a pattern.
  3. In Windows Excel, press Ctrl+E or choose Data > Flash Fill.
  4. Scan the filled results for mistakes before using them to replace the source.

For example, if A2 contains NORTH and A3 contains SOUTH, type north in B2 and south in B3. Flash Fill may infer that the adjacent column should contain lowercase versions. The result is ordinary filled-in text, not a formula linked to column A. If Excel does not recognize the pattern, use LOWER instead; it is more predictable for a straightforward case conversion.

Flash Fill is also sensitive to the pattern you demonstrate. If you change more than case in your example—for instance, remove a middle initial or rearrange a name—Excel may infer that broader transformation. Review the full output rather than assuming it has only changed capitalization.

Run a VBA Macro on Selected Cells

If you repeatedly need to convert selected text directly in place, a short VBA macro can do it. Unlike a formula, this changes cell values rather than creating a second output column. The example below changes text constants in the selection and skips formula cells; it leaves numbers and other non-text values alone.

Sub LowercaseSelectedText()
    Dim cell As Range

    If TypeName(Selection) <> "Range" Then Exit Sub

    For Each cell In Selection.Cells
        If Not cell.HasFormula Then
            If VarType(cell.Value2) = vbString Then
                cell.Value2 = LCase$(cell.Value2)
            End If
        End If
    Next cell
End Sub

To use it, open the Visual Basic Editor, insert a standard module, paste the code, and run the macro with the intended cells selected. Macros may require enabling or saving a macro-enabled workbook, and an organization may restrict them. Save a separate copy of the workbook before running the macro: changes made by VBA cannot be undone with Ctrl+Z. A formula and Paste Values are usually preferable for occasional conversions because they are easier to inspect and reverse before replacing the original.

What LOWER Changes—and What It Does Not

LOWER changes the case of letters in its text input. It does not translate words, correct spelling, remove leading or trailing spaces, or standardize punctuation. Numbers and symbols do not have uppercase and lowercase forms, so they remain visually unchanged. The function returns text, so it is not a way to apply a numeric or date format.

A related misconception is that Excel ignores letter case everywhere. Many everyday worksheet comparisons, such as standard equality tests and common lookup behavior, are not case-sensitive; however, Excel preserves the case of text in cells and displays it. A conversion is therefore useful when consistent appearance matters, even when a calculation would treat two differently cased entries as equivalent.

Case-sensitive tasks are different. The EXACT function can compare two text values while distinguishing uppercase from lowercase, which is useful for checking whether two strings match precisely. Do not lowercase data automatically if capitalization itself carries meaning, such as a case-sensitive identifier used by another system. Also consider whether formulas, downstream exports, or collaborators depend on the original spelling and capitalization before replacing the source.

Choosing the Best Method

For most worksheets, the choice is straightforward. Use a formula when you want transparent, repeatable results; use Flash Fill when you need a quick static result and the pattern is obvious; use VBA when an in-place operation is a frequent, controlled part of your workflow.

  • LOWER formula: Best for lists, repeatable work, and results that should update when source text changes.
  • Paste Values: Best for replacing original text after reviewing formula output.
  • Flash Fill: Best for a small, one-off conversion when Excel recognizes the demonstrated pattern.
  • VBA macro: Best for a recurring in-place task when macros are allowed and you understand that the change cannot be undone with Ctrl+Z.

If preserving the original matters, do not begin by overwriting it. A helper column gives you an audit trail and an easy way to compare before and after. For a particularly important workbook, save a copy first, regardless of which method you choose.

Frequently Asked Questions

What is the lowercase shortcut key in Excel?
There is no built-in key that directly converts selected cell text to lowercase in Excel for Microsoft 365 on Windows. Enter a LOWER formula, use Flash Fill with Ctrl+E, or run a macro for an in-place change.

Does Shift+F3 make text lowercase?
No. Shift+F3 opens the Insert Function dialog in Excel. It does not change the capitalization of selected cells.

How do I change uppercase text to lowercase in Excel?
With the text in A2, enter =LOWER(A2) in another cell. Fill the formula down for more rows. To replace the source, copy the results and use Paste Values on the original cells after checking them.

Can Flash Fill change text to lowercase?
Yes, if Excel recognizes the pattern you demonstrate. Type one or two lowercase examples beside the source data, then use Ctrl+E in Windows or Data > Flash Fill. Check the output because Flash Fill is pattern-based.

Can I change case without a formula?
Yes. Flash Fill can create static results from examples, and VBA can change selected text in place. For a small number of cells, you can also edit the text directly. Excel does not have a built-in lowercase ribbon button for selected cells.

Will LOWER change the original cell?
No. A formula returns its result in the cell where the formula is entered and leaves its source unchanged. Copy the result and paste values over the source only when you are ready to replace it.

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.