Excel for Microsoft 365 on Windows has no built-in keyboard shortcut that changes selected text to lowercase. The dependable method is to enter =LOWER(A2) in a neighboring cell, then fill the formula down; for a one-time pattern conversion, Flash Fill may be quicker.
Is there a lowercase keyboard shortcut in Excel?
No. Unlike Microsoft Word, Excel does not include a Change Case command that cycles selected text between lowercase, uppercase, and title case with a keyboard shortcut. The familiar Shift+F3 case shortcut belongs to Word; it does not convert cell contents in Excel. Excel’s ribbon also has no general Change Case button.
That means the best approach depends on what you need. A formula is reliable and updates if the original text changes. Flash Fill can create a one-time result by recognizing a pattern you demonstrate. A macro can provide a custom shortcut for repeated conversions, but it changes cell contents and needs extra setup.
- For accurate, repeatable conversion: use the LOWER function.
- For a quick one-off conversion: try Flash Fill.
- For a frequently repeated action: consider a macro, after weighing its risks.
Use the LOWER function
LOWER converts letters in a text value to lowercase. It does not change numbers, and it leaves punctuation and spaces in place. The simplest workflow is to keep the original text in one column and put the converted version next to it.
With the original text in A2, enter this formula in B2:
=LOWER(A2)
If A2 contains North WIND, B2 displays north wind. Press Enter, select B2, and drag the fill handle at the lower-right corner of the cell down the column. Excel adjusts the reference for each row, so the next row uses A3, then A4, and so on. You can also double-click the fill handle when the neighboring column contains data to guide the fill range.
LOWER returns a result in a separate cell; it does not overwrite the source cell. This is useful when you want to check the conversion or keep the original values. If the source text changes later, the formula result updates automatically.
Make converted text permanent
If you need lowercase entries in the original column rather than formula results in a helper column, convert the results to values and then replace the source. First, fill the LOWER formula down. Check a few results, especially if the data includes unusual characters or important codes.
- Select the formula results and copy them.
- Use Home > Paste > Values to paste a static copy. This replaces formulas with their displayed text results.
- Move or copy those values over the original cells if that is your goal. Be careful not to paste over the source before you have copied the formula results.
After pasting values, the results no longer depend on the original text. They will not change if the source changes. Keep a backup column or save a copy of the workbook first if the original capitalization may matter later—for example, in names, product identifiers, or source data that may need to be audited.
Use Flash Fill for a one-time conversion
Flash Fill detects a pattern from examples and fills a neighboring column. To try it, put the original text in column A. In B2, manually type the lowercase version of A2. Start entering the next example in B3; if Excel recognizes the pattern, it may preview the remaining values. Accept the preview, or use Data > Flash Fill. In Excel for Microsoft 365 on Windows, Ctrl+E also runs Flash Fill.
For instance, if A2 contains BLUE SKY, type blue sky in B2. If the preview matches the rest of the column, accept it. Flash Fill produces values rather than live formulas, so a later edit to column A will not automatically update the filled text.
Flash Fill is pattern-based, not a dedicated case-conversion function. It can be less predictable when examples contain inconsistent spacing, mixed formats, or exceptions. Review the output before replacing any source data. When exact and repeatable results matter, use LOWER instead.
Choose the right method for the job
These methods solve slightly different problems. Choosing based on whether you need a live result, a static result, or a reusable command avoids unnecessary steps.
- LOWER formula: Best for lists that may change, large ranges, or workbooks where the conversion should be easy to inspect. The original remains intact, but the result is a formula until you paste values.
- Flash Fill: Best for a quick, one-time transformation when Excel correctly recognizes your example. It creates static output and does not recalculate.
- Macro: Best for people who repeatedly need to convert selected text in place and are comfortable enabling and managing VBA. A macro requires setup and can modify data directly.
For a short column, manually editing each cell may seem faster, but it is easy to miss a row or introduce a typo. A formula or Flash Fill makes the conversion consistent and easier to verify. For a very large dataset that is part of a repeatable import-and-clean process, Power Query can also transform text to lowercase as part of its data preparation steps.
Common problems and limits
LOWER changes letter case, not the underlying meaning or structure of the text. It does not remove spaces, fix misspellings, or standardize punctuation. If a cell contains New York with spaces at the beginning and end, LOWER keeps those spaces.
To lowercase text and remove ordinary leading and trailing spaces while reducing repeated internal spaces, use TRIM around the reference. With the original text in A2, enter this in B2:
=LOWER(TRIM(A2))
For example, if A2 contains North WIND , the result is north wind. TRIM is not a universal cleanup tool: it targets ordinary spaces and does not remove every special whitespace character that may arrive from a website or another system. If unusual spaces remain, data cleaning may require identifying and replacing that specific character.
Another important limit is that lowercase can be inappropriate for some values. Excel treats text case as usually insignificant in many common comparisons, but capitalization may still matter to a person or to an external system. Converting a password, a case-sensitive code, or a source field that must be preserved could cause problems. Keep the original data until you know the lowercase version is acceptable.
Excel on Mac and Excel for the web
The LOWER formula works in Excel for Microsoft 365 on Windows, Excel for Mac, and Excel for the web. The formula syntax is the same. The main difference is the available shortcut and interface, not the function itself.
On Excel for Mac, Flash Fill can be run from Data > Flash Fill; Control+E is the keyboard shortcut in current Excel for Mac versions that support it. If the shortcut does not work on your setup, use the ribbon command. On Windows, use Ctrl+E or Data > Flash Fill. In Excel for the web, using a LOWER formula is the straightforward option; desktop commands and shortcut availability can differ from the browser experience.
If a keyboard shortcut is intercepted by your operating system, keyboard layout, or another application, the ribbon command or formula remains a dependable alternative. There is no separate lowercase shortcut to memorize for Excel itself.
Create a custom shortcut with a macro
If you regularly need to change selected text in place, a VBA macro can apply lowercase to text constants in the current selection. The example below skips formulas and non-text values. It changes the selected text directly, so use it only when you are comfortable replacing the original capitalization.
To add it, open the Visual Basic Editor, insert a standard module, and paste in the procedure. In Excel for Windows, you can open the editor with Alt+F11. To assign a shortcut, return to Excel, open Developer > Macros, select the macro, choose Options, and set a shortcut key.
Sub LowercaseSelectedText()
Dim cell As Range
' Change text constants only; leave formulas and other values unchanged.
For Each cell In Selection.Cells
If Not cell.HasFormula Then
If VarType(cell.Value2) = vbString Then
cell.Value = LCase$(CStr(cell.Value2))
End If
End If
Next cell
End Sub
Save a copy of the workbook before running a macro. Macro changes cannot be undone with Ctrl+Z, and VBA may be disabled by workbook or organization security settings. Assigning a shortcut also means choosing one that does not conflict with a shortcut you rely on; use the macro only in files where macros are permitted.
Frequently Asked Questions
What is the Excel shortcut to make text lowercase?
Excel has no built-in lowercase keyboard shortcut. Use =LOWER(A2) in a neighboring cell, or use Flash Fill for a one-time pattern conversion.
Does Shift+F3 change case in Excel?
No. Shift+F3 is associated with changing case in Word, not with converting selected cells in Excel. In Excel, use LOWER, Flash Fill, or a macro.
Can I change a whole column to lowercase?
Yes. Enter a LOWER formula beside the first populated cell, fill it down, then paste the results as values if you need a static lowercase column. Review the output before replacing the source.
Will LOWER change numbers or formulas?
LOWER changes letters in the text it receives. Numeric values have no letters to lowercase. In a separate cell, the function returns a result; it does not edit the referenced cell or rewrite the formula that produced that value.
How do I make lowercase text uppercase or proper case instead?
Excel provides the related worksheet functions UPPER and PROPER. UPPER makes letters uppercase; PROPER capitalizes the first letter of each word and lowercases the remaining letters, which may not suit every name or abbreviation.
Can I lowercase text without a formula?
Yes. Flash Fill can infer the lowercase pattern from an example and produce static values. For a repeatable in-place action, a VBA macro is another option, but it requires setup and should be used with a backup.
Related
- Excel Phone List Template: Create a Contact List
- Excel Paste Numbers as Text? Keep IDs, Zeros, and Codes
- Excel Paste in Reverse Order: Practical Methods
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Set an Out of Office Reply in Microsoft OutlookTo set an out-of-office reply in Outlook, open Automatic Replies, turn them on, write your message, and—if available—choose…
- How to Make a Flowchart in Word 365: Step-by-Step GuideTo make a flowchart in Word 365, choose Insert > SmartArt > Process for a quick linear diagram,…
- Excel Import Multiple CSV Files as Separate SheetsYes. In Excel for Microsoft 365 on Windows, you can import each CSV manually with Data > Get…
- How to Set an Out of Office Invite in Outlook CalendarTo set an out of office invite in Outlook, create a calendar event, choose Show as > Out…
- Excel Heat Map Conditional Formatting: Setup and TipsIn Excel for Microsoft 365 on Windows, select the numeric cells, then choose Home > Conditional Formatting >…
- Excel Shortcut Cheat Sheet for Windows and MacAn Excel shortcut cheat sheet is a quick reference to keyboard commands for editing cells, moving around worksheets,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.