The fastest way to convert text to lowercase in Excel

Excel has a built-in function called LOWER() that converts any text to lowercase letters. You type the function into a new column, point it at the cells you want to change, and it produces lowercase versions when ready. The original text stays unchanged unless you copy the results and paste them back as values.

If you have a lot of text to convert, this takes about two minutes. If you need to replace the original text permanently, you'll do a copy-and-paste step at the end. There's no single button that says "make lowercase"—you're using a formula instead, which is actually faster than hunting through menus.

Key Takeaways

  • The LOWER() function converts text to lowercase; type =LOWER(A1) in a new column and it will convert the text in cell A1.
  • You can explore the formula to an entire column at once by clicking the cell and dragging the fill handle down, or by selecting the range and pressing Ctrl+D.
  • The formula creates new lowercase text in a separate column; the original text is not changed unless you copy the results and paste them as values over the original.
  • If you want to replace the original text, copy the lowercase results, select the original cells, and use Paste Special with the Values option.

Using the LOWER() function step by step

Open your spreadsheet and locate the column with the text you want to convert. Click on an empty cell in the row next to your first piece of text—usually one column to the right. Type =LOWER(A1), replacing A1 with the cell reference of your text. Press Enter.

Excel will when ready show the lowercase version of that text in your new cell. The original text in A1 stays exactly as it was. Now you need to copy this formula down to every row that has text. Click the cell with your formula, then look at the small square in the bottom-right corner of the cell—that's the fill handle. Click and drag it down to the last row with text, or select from your formula cell down to the last row you need and press Ctrl+D to fill down.

Replacing the original text with the lowercase version

Once your formula has created lowercase versions in the new column, you have two choices: keep both columns, or replace the original text. If you want to replace it, select all the cells in your new column that contain the lowercase text. Press Ctrl+C to copy them.

Click on the first cell of your original column—the one with the capitalized text. Right-click and choose Paste Special. A dialog box will open. Click the Values option and then click OK. This pastes only the text, not the formula, so your original column now contains lowercase letters. You can then delete the helper column with the formulas.

Converting multiple columns at once

If you have several columns of text to convert, you don't need to do them one at a time. Create your LOWER() formulas for the first column as described above, then select all the formula cells you've created. Copy them across to the right, one column for each original column you need to convert. Excel will automatically adjust the cell references—the formula in column B will reference column B, the formula in column C will reference column C, and so on.

Once all your lowercase versions are created, you can select all the formula results at once, copy them, and paste them as values back over your originals in a single step. This is much faster than converting one column, replacing it, and then moving to the next.

Other text conversion functions in Excel

Excel has two other text functions you might find useful. UPPER() does the opposite—it converts text to all capital letters. PROPER() capitalizes the first letter of each word and makes the rest lowercase, which is useful for names or titles that are in all caps or all lowercase.

All three functions work exactly the same way: type the function name, put the cell reference in parentheses, and press Enter. You can use them in the same column or different columns, and you can combine them with other formulas if you need to do more complex text work.

What to do if the formula doesn't work

The most common problem is typing the cell reference wrong. Make sure you're using the correct column letter and row number—A1, not A or 1 by itself. If you see #NAME? in the cell, you've misspelled the function name. It should be LOWER with no spaces or extra characters.

If the text doesn't look lowercase after you paste it as values, check that you used Paste Special with Values selected, not regular Paste. Regular Paste will paste the formula instead of the result, and when you delete the original column, your new column will show errors.

When to use this instead of Find and Replace

Excel also has a Find and Replace feature, but it doesn't have a built-in option to change case. The LOWER() function is the standard way to do this because it's reliable and works on any amount of text. Find and Replace is better for swapping one specific word or phrase for another, not for changing the case of every letter in a cell.

If you're working with a very small amount of text—just a few cells—you could manually retype it in lowercase, but the formula method is faster even for small jobs because you don't have to think about it. You set it up once and it's done.

Frequently Asked Questions

Can I change the case of text without creating a new column?

Not directly—Excel doesn't have an in-place case converter. You always create the lowercase version in a new location first, then copy it back over the original if you want to replace it. This protects your original data in case something goes wrong.

Does LOWER() work on numbers or special characters?

LOWER() only affects letters. Numbers, spaces, punctuation, and symbols stay exactly as they are. If a cell contains "ABC123", LOWER() will produce "abc123"—only the letters change.

What if I have text in multiple sheets?

You'll need to repeat the process for each sheet. Create your LOWER() formulas on each sheet separately, or copy the data from all sheets into one sheet, convert it, and then move it back if needed. There's no single command that converts text across multiple sheets at once.

Can I undo this if I accidentally replace the original text?

Yes, as long as you haven't saved the file. Press Ctrl+Z to undo the paste operation and restore your original text. If you've already saved, you'll need to reopen the file without saving the changes, or manually retype the text.

Does this work in Google Sheets?

Yes, Google Sheets has the same LOWER() function and it works identically. The steps are the same: type the formula, press Enter, and fill down. Paste Special with Values also works the same way in Google Sheets.