How to Change Uppercase to Lowercase in Excel (4 Ways)

November 11, 2026 · 9 min read

How to Change Uppercase to Lowercase in Excel (Plus Title and Sentence Case)

Here's how to change uppercase to lowercase in Excel: type =LOWER(A2) in a spare column, fill it down, then paste the results back as values. Excel has no Change Case button, so formulas, Flash Fill and Power Query do the job. This guide covers all three, plus title case, sentence case and the PROPER traps.

How to Change Uppercase to Lowercase in Excel with LOWER

LOWER takes one argument, the text or the cell holding it, and returns every letter in lowercase. Numbers, spaces and punctuation come through untouched. Microsoft's own change the case of text instructions use a helper column too, so that's the standard route.

=LOWER(A2)

Typed in B2, that formula reads the text in A2 and returns a lowercase copy. Here are the steps for a whole column:

  1. Insert an empty column to the right of your data, say column B.
  2. In B2, type =LOWER(A2) and press Enter.
  3. Double-click the small square at the bottom-right corner of B2 to fill the formula down to the last row of data.
  4. Select the results, press Ctrl+C, then right-click A2 and pick Values under Paste Options.
  5. Delete column B.
Column A beforeFormula in BColumn A after
JANE DOE=LOWER(A2)jane doe
ORDER #4471 SHIPPED=LOWER(A3)order #4471 shipped
NEW YORK, NY 10001=LOWER(A4)new york, ny 10001

Step 4 is the one people skip. Column B holds formulas that point at column A, so if you delete column A first, every cell in B turns into a #REF! error. Pasting as values swaps the formulas for plain text, which makes the helper column safe to delete.

Function names aren't case-sensitive, so =lower(a2) works too and Excel tidies it to capitals when you press Enter. In Excel for Microsoft 365 and Excel 2021 or later, you can also type =LOWER(A2:A500) once and the results spill down the column.

How Do You Change Lowercase to Uppercase in Excel?

Use UPPER, the mirror of LOWER. Type =UPPER(A2) in the helper column and follow the same five steps: fill down, copy, paste as values over the original, delete the helper.

=UPPER(A2)

With gb-lon-04 in A2, that returns GB-LON-04. Capitals suit product codes, country codes, postcodes and stock tickers, where a lowercase entry looks like a typo. As with LOWER, digits and hyphens stay exactly as they were.

Title Case in Excel with PROPER, and Where It Goes Wrong

PROPER gives you a capital at the start of each word and lowercase everywhere else, which is the closest Excel gets to title case.

=PROPER(A2)

The catch is the rule behind it. According to Microsoft's PROPER reference, it capitalizes the first letter of the text and any letter that follows a character other than a letter. Apostrophes and digits count as non-letters, so some results look odd:

Input=PROPER(A2) returnsProblem
the lord of the ringsThe Lord Of The RingsShort words get capitals too
o'brienO'BrienCorrect, by luck of the rule
don't panicDon'T PanicLetter after an apostrophe is capitalized
2nd floor2Nd FloorLetter after a digit is capitalized
mcdonaldMcdonaldSecond capital is lost
NASA REPORTNasa ReportAcronyms are flattened

PROPER also isn't style-guide title case. Most style guides keep short words like of, the and in lowercase unless they start the title, and PROPER can't tell them apart.

We prefer PROPER for lists of names, but only with a manual pass afterwards for Mc, Mac and apostrophe names. For contractions, wrap it in SUBSTITUTE to repair the most common one: =SUBSTITUTE(PROPER(A2),"'T","'t") turns Don'T back into Don't. It also lowers names like O'Toole, so run it only on columns without them.

How Do I Change to Sentence Case in Excel?

Excel has no SENTENCE function, but you can combine five text functions to get the same effect. This formula capitalizes the first letter of the cell and lowercases everything after it:

=UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2)))

Here's how the parts fit together:

  • LEFT(A2,1) takes the first character, and UPPER capitalizes it.
  • MID(A2,2,LEN(A2)) takes everything from the second character to the end. LEN just supplies a length long enough to reach the end.
  • LOWER turns that remainder into lowercase, and & joins the two pieces.

If some cells start with a space, LEFT grabs the space, so the real first letter comes out lowercase. Wrap each reference in TRIM to fix that:

=UPPER(LEFT(TRIM(A2),1))&LOWER(MID(TRIM(A2),2,LEN(TRIM(A2))))

Know the limit before you rely on it. The formula only capitalizes the first letter of the cell, so THE INVOICE IS OVERDUE. PAY BY FRIDAY. becomes The invoice is overdue. pay by friday. It also lowercases names and acronyms in the middle. It's ideal for one-sentence cells such as product descriptions, and weak for paragraphs. True sentence case keeps proper nouns and acronyms capitalized, so fix those by hand.

Is There an Excel Uppercase to Lowercase Keyboard Shortcut?

No. Excel has no keyboard shortcut that changes case, and Microsoft's own documentation says it lacks the Change Case button that Word has.

People often try Shift+F3 because it changes case in Word. In Excel it opens the Insert Function dialog instead, so pressing it on a selection won't touch your text.

The fastest keyboard-only route is Flash Fill. Type the first result by hand in the next column, move to the cell below, and press Ctrl+E. Microsoft's Flash Fill guide gives both routes: Data, then Flash Fill, or Ctrl+E. On a Mac, use the Data menu route if the shortcut doesn't respond.

How to Change Lowercase to Uppercase in Excel Without a Formula

You've got three ways to skip formulas, each suited to a different job.

Flash Fill. Next to jane doe in A2, type JANE DOE in B2. Then select B3 and press Ctrl+E, or go to Data, then Flash Fill. Excel guesses the pattern from your example and fills the column. Flash Fill writes plain values, not formulas, so if you edit column A later, run it again. Check a few rows, because Flash Fill guesses and occasionally guesses wrong on mixed data.

Power Query. This suits a cleanup you repeat every week. Select your data and choose Data, then From Table/Range. In the Power Query editor, select the column, open the Transform tab, click Format and pick lowercase, UPPERCASE or Capitalize Each Word. Click Close & Load, and Excel puts the result in a new table on a new sheet.

Next time the source data changes, refresh the query and the case change runs again. Under the hood these commands use the M functions Text.Lower, Text.Upper and Text.Proper.

Our case converter. For a one-off column, select it in Excel, copy it, and paste it into the case converter. Choose lower case, UPPER CASE, Title Case or Sentence case, copy the output and paste it back over the column. Each line stays on its own line, so the rows line up again. It runs in your browser and there's no limit on how often you use it.

The limitation is real, though. The converter works on plain text only. It doesn't open .xlsx files, can't see formulas, and won't change cells in place, so paste back one column at a time. For a column of email addresses or URLs, stick with LOWER.

Changing case truly in place, with no helper column, takes a script such as a VBA macro. Macros can't be undone with Ctrl+Z, so save a copy of the workbook first.

Which Case-Change Method Should You Use?

MethodUpdates when the source changesNeeds a formulaBest for
LOWER, UPPER or PROPER helper columnYes, until you paste valuesYesData you'll keep editing
Flash FillNoNoQuick one-off cleanups
Power QueryOn refreshNoRepeated imports and reports
Case converter pasteNoNoOne column, any Excel version

We reach for formulas when the data is still changing and Flash Fill when it's settled. Power Query earns its setup time only when the same file comes back every week or month. For styles Excel has no function for, such as camelCase or snake_case, see our letter case converter guide.

Is your cleaned column headed for documentation rather than another spreadsheet? See how to turn CSV data into a Markdown table. The Markdown table guide covers alignment and formatting.

Changing Text Case in Google Sheets

Google Sheets has the same LOWER, UPPER and PROPER functions, and you use them the same way. To fill a whole column from one cell, use =ARRAYFORMULA(LOWER(A2:A)). Google's PROPER help page carries the same warning about names: it lowercases every letter that doesn't start a word, so McLeod becomes Mcleod.

That's how to change uppercase to lowercase in Excel: LOWER in a helper column, then paste as values. UPPER, PROPER and the sentence-case formula cover the other styles, and Flash Fill's Ctrl+E is the closest thing to a shortcut. For a quick one-off column, paste it through the case converter. If the tidy data ends up in a README or report, draft it in the editor and preview the table as you type.