Excel how-to
Convert Uppercase to Lowercase in Excel
Excel has no Change Case button like Word. Use the LOWER function to convert an uppercase cell or an entire column without retyping the values.
Use the Excel LOWER formula
If the original text is in cell A2, enter =LOWER(A2) in an empty cell. LOWER changes letters to lowercase while keeping numbers, punctuation and spaces. Fill the formula down to process the rest of a column.
- Enter =LOWER(A2) beside the first uppercase value.
- Press Enter, then drag or double-click the fill handle to copy the formula down.
- Check the results before replacing any source data.
Replace the original cells with values
Formula results still depend on the source cells. To make the lowercase results permanent, copy the completed helper column, select the original cells and choose Paste Special, then Values. Confirm the pasted values before deleting the helper column so the workbook remains recoverable.
| Use | Input | Result |
|---|---|---|
| Cell reference | A2 contains CORK OFFICE | =LOWER(A2) returns cork office |
| Quoted text | =LOWER("ORDER 204") | order 204 |
Excel does not have a default case shortcut
Unlike Microsoft Word, Excel does not include a built-in shortcut that toggles selected cells between uppercase and lowercase. The LOWER formula is the safest repeatable approach. Power Query or a reviewed macro can help with a recurring data-cleaning workflow, but neither is necessary for a short list.
Convert a small copied list online
For a few cells, copy the text into FixCaseNow, choose lowercase and paste the result back. This avoids a helper column, but it also replaces formulas and formatting if you paste carelessly. Review the rows and use an undoable copy of the workbook before overwriting important data.