Change All Text to Lowercase in Excel

How-to basics · Updated November 20, 2026

To change text to lowercase in Excel, use the LOWER function in a helper column, fill it down, then copy the results and paste them as values over the original text if you want to replace it. If the text is in A2, enter =LOWER(A2) in another cell on the same row. This converts letters to lowercase while leaving numbers and punctuation unchanged. Excel has no built-in ribbon command that changes the case of selected cells in place, so keep a copy of the original data until you have checked the results.

What You’ll Need

  • A workbook in Microsoft Excel for Microsoft 365 on Windows. The LOWER function is also available in older Excel versions and in Excel for Mac and the web.
  • A source range containing the text you want to convert, plus an empty column or range where the formula results can go.
  • Edit access to the workbook. If the worksheet is protected, you may need permission to edit cells before you can add formulas or paste values.

You do not need an add-in, macro, or special setting. For an important list, save a copy of the workbook first. The formula method leaves the source untouched until you choose to replace it, which makes it easier to review the conversion and recover the original data if something is wrong.

Step-by-Step

  1. Find the text and make room for results. Identify the column or range to change, such as product names in A2:A100. If the adjacent column is empty, use it for the converted text; otherwise insert a temporary column or choose another empty area. Keep the header row separate from the data unless you also want to convert the header. If several columns need converting, plan a matching output area for each one.
  2. Enter the LOWER formula beside the first text value. With the original text in A2, select B2 and enter =LOWER(A2), then press Enter. For example, if A2 contains North WIND Road, B2 displays north wind road. The cell reference tells Excel which value to convert. LOWER changes letters regardless of their original capitalization, but it does not translate words or remove spaces, punctuation, or digits.
  3. Fill the formula down through the data. Select B2 and drag the small square at its lower-right corner down to the last row. You can also select the destination range, such as B2:B100, with B2 as the active cell and use Home > Fill > Down. On Windows, Ctrl+D fills down; on Mac, Control+D is the corresponding shortcut in Excel. Check that each row refers to the source cell on the same row: the formula copied to B3 should refer to A3, for example.
  4. Handle blank rows if your range contains them. A direct reference to a truly empty cell can display 0 in the result, depending on how the formula is evaluated, so use a blank-safe formula if your range has empty cells. With original values in A2:A100 and the result formula starting in B2, enter =IF(A2="","",LOWER(A2)). This returns an empty string when A2 is empty and otherwise converts its contents. If A2 contains the text BLUE, the formula returns blue; if A2 is blank, B2 appears blank. Fill this formula down as in the previous step.
  5. Review the converted results. Compare several rows near the top, middle, and bottom of the list, including rows with apostrophes, hyphens, numbers, or accented letters. Confirm the output range covers every source row and that nothing important was overwritten. If you used filters, check whether you intended to process only visible rows or the entire range. Fix any incorrect source values before replacing the originals.
  6. Replace the original text only if that is your goal. Select and copy the completed formula results, then select the corresponding original cells. Choose Home > Paste > Values to paste the displayed text rather than the formulas. Make sure the first copied result aligns with the first original cell and that the selected ranges are the same size. Once you have checked the pasted values, delete the temporary helper column if you no longer need it. Save the workbook.

If you only need lowercase text for a report, formula-driven output may be enough; you can leave the original data in place. If you paste values over the source, the result no longer updates when the original changes. Keep the helper column until you are certain you do not need to compare or restore the original capitalization.

Common Mistakes

Typing the formula into the source cell. A formula such as =LOWER(A2) in A2 would refer to its own cell and create a circular reference. Put the formula in a separate cell, such as B2, then copy and paste the values back only after checking them.

Copying formulas when you meant to replace text. If you copy the helper cells and use a regular paste over the source, Excel may paste formulas that refer to the wrong locations. Use Home > Paste > Values for a static text replacement. Before pasting, verify that the copied and destination ranges begin on corresponding rows.

Including the heading by accident. If your column has a heading in A1, begin the formula in B2 and fill only through the data rows. Otherwise the heading will also become lowercase, which may not match your preferred presentation.

Expecting a visual formatting change. LOWER changes the cell’s text result; it is not a font setting or a display format. Changing the font, number format, or cell style will not convert uppercase letters to lowercase.

Overlooking extra spaces or hidden characters. LOWER does not clean the text. A result may look lowercase but still contain leading spaces, trailing spaces, or nonprinting characters. If those matter, clean the source separately and review the output rather than assuming LOWER fixes every text problem.

Tips

  • Work on a copy for bulk changes. A duplicate worksheet or a saved workbook copy gives you a way back if you paste over the wrong range. This is especially useful for imported customer, inventory, or survey data.
  • Use a clear temporary heading. Label the helper column something like “Lowercase result” while reviewing it. Remove or rename the heading when you finish so the workbook remains understandable to other people.
  • Convert multiple columns systematically. For text in A2 and an output cell B2, the formula is =LOWER(A2). For text in C2 and a separate output cell D2, use =LOWER(C2). Fill each output down only as far as its matching source data, and avoid putting results on top of source cells you still need.
  • Use an Excel Table when the list grows. If your data is formatted as a table, adding a formula in a new table column typically fills it through the table. Review the first and last rows, especially after adding new records, to confirm the calculated column includes them.
  • Keep the formula if ongoing updates matter. A formula result recalculates when its referenced text changes. Paste values only when you want a fixed conversion and no longer need the lowercase column to follow future edits.
  • Remember that case is not the same as sorting. Converting the text does not rearrange the rows or remove duplicate entries. If you need to sort or deduplicate the list, do that as a separate task after checking how it could affect related columns.

Troubleshooting

The formula appears as text instead of producing a result. 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, edit the cell, and press Enter again. Check that Show Formulas is not turned on; on Windows, Ctrl+` toggles that view. The Mac shortcut can vary with keyboard layout, so use Formulas > Show Formulas if available in your ribbon.

The formula returns an error or the wrong row. Confirm that the formula points to the source cell, not to itself or an unrelated cell. If you filled down, select a few output cells and inspect their references in the formula bar. A formula in B10 should normally refer to A10 when the source is in column A. If the formula was copied sideways or the columns differ, correct the first reference and refill the range.

Blank source rows show a zero. Replace the simple LOWER formula with the blank-safe IF formula shown in the steps, then fill it down. Check that the formula is pointing to the intended source column. A cell that looks empty may contain spaces; in that case, the test for an empty cell will not treat it as blank.

Some letters do not change as expected. LOWER affects letters that have uppercase and lowercase forms. Numbers, punctuation, symbols, and many characters without case remain the same. If the source contains unusual characters or text imported from another system, try a few representative examples and compare the results before processing the full list.

Only some rows changed after pasting. Check whether the copied range included all rows and whether filters or hidden rows affected your selection. Undo immediately if the paste landed in the wrong place, then select matching source and result ranges and use Paste Values again. If the workbook is protected or shared with restricted permissions, resolve that restriction before attempting the replacement.

Frequently Asked Questions

Can I change text to lowercase without a formula?
Excel for Microsoft 365 does not provide a standard Change Case button for worksheet cells. The LOWER formula is the built-in method. You can keep the formula results in a separate column or paste them as values to replace the original text.

Does LOWER change numbers or punctuation?
No. It changes uppercase letters to lowercase and leaves digits, punctuation, and symbols as they are. For example, a product code containing letters and numbers keeps its digits and hyphen while its letters become lowercase.

Will the original text change when I enter the formula?
No. A formula in a separate cell creates a converted result and leaves the source cell unchanged. The original changes only if you deliberately paste the results as values over the source cells.

Can I use this method in Excel for Mac or Excel for the web?
Yes. LOWER works in both. The ribbon layout and keyboard shortcuts may differ slightly by platform; in Excel for the web, use the formula and fill handle, then use the available Paste Values option if replacing the source.

Can I convert only part of a cell to lowercase?
LOWER converts the entire text value supplied to it. To preserve part of a cell in a different case, you would need to build a more specific text formula or edit that value separately; LOWER alone does not select individual words.

Does changing case affect formulas or linked data?
It can if other formulas, lookups, or systems depend on the original text or exact displayed values. Excel’s ordinary text comparisons are generally not case-sensitive, but an external application or a case-sensitive process may treat the changed text differently. Keep a backup and check important downstream uses before replacing source values.

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.