Excel Uppercase to Lowercase Shortcut: What Actually Works

How-to basics · Updated November 19, 2026

Excel has no built-in keyboard shortcut that directly changes selected text from uppercase to lowercase. The reliable method is to enter =LOWER(A2) in a helper cell when the text is in A2, then fill the formula down; use Paste Values if you want to replace the original text. For a one-off conversion, Flash Fill can also work, while Power Query is useful for repeatable data-cleaning tasks.

What to use instead of a case-change shortcut

In Excel for Microsoft 365 on Windows, you cannot select cells and press a native shortcut equivalent to Word’s Shift+F3 case command. Excel does not provide a built-in Change Case button on the ribbon either. The LOWER function is the straightforward option: it returns text in lowercase while leaving the source cell unchanged.

For example, if A2 contains MARIA GARCIA, a formula in B2 returns maria garcia. It also changes mixed-case text, such as Maria Garcia, to maria garcia. Numbers, punctuation, and spaces are not converted into letters, so an entry such as SALE-2026! becomes sale-2026!.

The formula works in Excel for Microsoft 365 on Windows and Mac, and in Excel for the web. If you are searching for a shortcut because you need to perform this task often, you can use Flash Fill or create a macro with a keyboard shortcut, but neither is Excel’s standard, built-in case-toggle command.

Convert text with the LOWER formula

With the text to convert in A2, enter =LOWER(A2) in B2. The result appears in B2 in lowercase. To convert a list, put the formula beside the first item and copy it down through the rows you need.

  1. Insert a blank column next to the text column, or choose another empty area for the results.
  2. Enter =LOWER(A2) in the first result cell, changing A2 to the address of the cell that contains your text.
  3. Press Enter. Select the formula cell and use its fill handle, the small square at the lower-right corner, to copy the formula down. You can also copy the cell and paste it into the remaining rows.
  4. Check a few results, especially entries with punctuation, spaces, or mixed capitalization.

When you copy a formula down, Excel adjusts the cell reference automatically: the next row will refer to A3, then A4, and so on. In an Excel table, a formula entered in a column often fills the rest of that table column automatically. LOWER changes the text’s letter case; it does not remove leading or trailing spaces, correct spelling, or change the underlying source cells.

Replace the original text with lowercase results

Formulas show converted results in a separate location. If you need the original column itself to contain lowercase text, copy the formula results and paste them back as values. Keep a copy of the original data first if you may need to restore it.

  1. Select the formula results and copy them with Ctrl+C on Windows. On Mac, use Command+C.
  2. Select the original cells where those results should go.
  3. On Windows, open Home > Paste > Paste Values. You can also use Ctrl+Alt+V to open Paste Special, choose Values, and confirm. In Excel for Mac, use the Paste Special command and choose Values; the precise menu presentation can vary by Excel version.
  4. Once the lowercase values are in place, remove the helper column if you no longer need it.

Paste Values matters because copying and pasting formulas normally carries the formulas, not just their displayed text. A formula pasted back into its own source range can also change its references or create a circular reference. Pasting values avoids that problem and leaves ordinary text in the destination cells.

Use Flash Fill for a quick one-time conversion

Flash Fill can infer a text pattern from an example you type. If A2 contains MARIA GARCIA, type maria garcia in B2. Then select the next cell in that result column and press Ctrl+E on Windows, or choose Data > Flash Fill. Excel may fill the remaining rows according to the example.

Flash Fill is useful when you want a quick set of results without keeping formulas. It can also handle transformations more complicated than case, such as extracting a first name from a full name, provided the examples make the pattern clear. However, it does not create a live relationship to the source values: if the source list changes later, the filled results do not automatically recalculate.

  • Give Flash Fill a clear example in the first result row.
  • Review the filled column before using it, especially when the source entries follow inconsistent patterns.
  • If Excel does not recognize the pattern, use the LOWER formula instead; it is explicit and dependable for case conversion.

Flash Fill is available in desktop Excel versions that include the feature. For Excel for the web, the formula method is the safer choice because interface and feature availability can differ. On Mac, use Data > Flash Fill if it is present in your version rather than relying on a Windows keyboard shortcut.

Convert a whole dataset with Power Query

Power Query is a good fit when lowercase conversion is one step in a repeatable import or cleanup process. In Excel for Microsoft 365 on Windows, make the source data a table, select a cell in it, and choose Data > From Table/Range. In Power Query Editor, select the text column and choose Transform > Format > lowercase.

Then choose Home > Close & Load to return the transformed data to Excel. The query records the conversion step, so you can refresh the query when the source data is updated. This differs from a one-off LOWER formula: a formula recalculates from worksheet cells, while a query applies its recorded transformation when the query runs.

Power Query may not be necessary for a short list, and its exact availability or interface can differ between Windows, Mac, and web versions. If the relevant commands are not available in your Excel installation, use the formula approach. Before loading transformed data over existing content, check where the query output will go and whether you need to retain the original column.

How to choose the right method

The best option depends on whether you need a quick result, a live formula, or a repeatable data-import step. These methods do not all behave the same way after the source text changes.

  • Choose LOWER when you want a transparent, reliable conversion that updates if the original cell changes.
  • Choose Paste Values after using LOWER when the finished cells should be plain text rather than formulas.
  • Choose Flash Fill for a quick transformation based on examples, and verify the results because Excel infers the pattern.
  • Choose Power Query when lowercase conversion belongs in a recurring import or cleanup workflow.
  • Consider a macro only if you repeatedly need to convert selected cells in place and are comfortable enabling and saving macro-enabled workbooks.

For most people converting names, labels, or email addresses once, a helper column with LOWER followed by Paste Values is the simplest balance of control and speed. It lets you inspect the results before replacing anything.

Common problems and misconceptions

Shift+F3 does not change case in Excel. That shortcut is associated with changing case in Word, not with a native Excel case-conversion command. Excel has other shortcuts that happen to involve Shift and function keys, but they are not a substitute for LOWER or Flash Fill.

The formula appears as text instead of calculating. The cell may be formatted as Text, or the formula may have been entered with an apostrophe before the equals sign. Change the cell format to General, then edit and re-enter the formula. Simply changing the format may not make an already-entered text string calculate until you confirm it again.

The source column did not change. That is expected: LOWER returns a result in the formula cell and does not edit its input. Copy the results and paste values over the source only after checking that the converted text is correct.

Only some rows were converted. Check that the formula was filled through the intended range and that the source cells actually contain text. Blank cells remain blank-looking, and numeric values have no letters for LOWER to change. If your list has gaps, select the full intended destination range and fill the formula deliberately rather than relying on a double-click of the fill handle.

Lowercase conversion is not data cleaning by itself. LOWER does not trim spaces, remove duplicate records, or standardize spelling. If you need to handle extra spaces as well, inspect the data and use a separate cleaning step rather than assuming a case function will fix every inconsistency.

Frequently Asked Questions

What is the Excel shortcut to change uppercase to lowercase?

Excel has no dedicated built-in shortcut for changing selected cells to lowercase. Use =LOWER(A2) in a helper cell, or use Flash Fill with an example. You can create a custom macro shortcut, but that requires a macro-enabled workbook.

Can I change text to lowercase without a formula?

Yes. Type a lowercase example in a neighboring column and use Flash Fill, or apply Power Query’s lowercase transformation during data cleanup. These options do not behave exactly like a formula: Flash Fill creates static results, while Power Query applies its step when the query runs.

How do I make the lowercase results permanent?

Copy the formula results, then use Paste Values in the destination cells. This replaces formulas with their displayed text. Make a backup or retain the original column until you have confirmed the conversion.

Does LOWER work in Excel for Mac and Excel for the web?

Yes. LOWER is a standard Excel worksheet function and works in current Excel for Mac and Excel for the web as well as Microsoft 365 for Windows. The formula syntax is the same; keyboard shortcuts and the availability of tools such as Flash Fill can differ.

Can I use a macro to assign a lowercase shortcut?

Yes, but a macro is optional and changes selected text in place, so save a copy of the workbook first. Macros cannot be undone with Ctrl+Z, and you must save a workbook containing VBA in a macro-enabled format such as .xlsm. Use a macro only if that trade-off is worthwhile for your workflow.

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.