Excel does not have a built-in Capitalize button like Word’s Change Case command. To change text case, use a formula such as =PROPER(A2), use Flash Fill, or create a one-click button that runs a VBA macro in the Excel desktop app.
What Excel Can and Cannot Do
Excel has no standard ribbon button that changes selected cell text to uppercase, lowercase, or title case in place. The Home tab’s font controls change a cell’s appearance—such as font, size, and color—but do not change the underlying letters. Nor is there a default keyboard shortcut that applies capitalization to selected cells.
That does not mean capitalization is difficult. The best method depends on whether you want to produce a separate corrected column, make a quick one-time conversion, or repeatedly change selected cells with a button. Formulas are dependable for a repeatable result, Flash Fill is convenient for a small set of recognizable examples, and a macro can provide a custom button for desktop use.
- Need all letters uppercase? Use
UPPER. - Want the first letter of each word uppercase? Use
PROPER. - Want one-click capitalization in the workbook? Add a button and assign a VBA macro.
Choose the Case You Actually Need
People use “capitalize” to mean several different things. Uppercase changes every letter to capitals, as in “SALES REPORT.” Lowercase changes every letter to small letters, as in “sales report.” Proper case capitalizes the first letter of each word, as in “Sales Report.” Sentence case normally capitalizes the beginning of a sentence but leaves the rest of the sentence lowercase, as in “Sales increased this month.”
These results are not interchangeable. A list of people’s names may look right in proper case, but a sentence or product description usually should not have every word capitalized. Before changing a column, decide what the text should look like and whether abbreviations, brand names, or unusual spellings need to stay as entered.
Use a Formula to Change Text Case
Formulas are a good choice when you want to preserve the original data and inspect the result before replacing anything. Put a formula in a neighboring column, then fill it down. For these examples, the source text is in A2.
- With the text
north regionin A2, enter=UPPER(A2)in B2. The result isNORTH REGION. - With
mARIA o'NEILin A2, enter=PROPER(A2)in B2. The result isMaria O'Neil. - With
Support@Example.COMin A2, enter=LOWER(A2)in B2. The result issupport@example.com.
After entering the formula in B2, use the fill handle at the lower-right corner of the cell to copy it down the rows. You can also select the destination cells and press Ctrl+D on Windows to fill down. On Mac, the equivalent shortcut is Control+D. Check the results before using them: formula results update when the source changes, and they do not overwrite the original cells automatically.
Sentence Case and First-Letter Capitalization
Excel does not have a dedicated worksheet function named “sentence case.” For a simple sentence in A2, this formula capitalizes the first character and lowercases the rest. With HELLO WORLD in A2, it returns Hello world:
=UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2)))
This is a basic transformation, not a grammar-aware sentence-case tool. It does not preserve acronyms such as “NASA,” and it only capitalizes the first character in the cell. If A2 begins with a space, that space is the first character, so the formula will not capitalize the first visible letter. Review the source text or clean it first if leading spaces are possible. Also remember that the formula converts every later letter to lowercase, which may not be appropriate for names, codes, or brand styling.
Replace the Original Text with Formula Results
If the transformed text is correct and you want fixed values rather than formulas, copy the output column and paste its values over the original data. On Windows, copy the results, select the destination, press Ctrl+Alt+V to open Paste Special, choose Values, and confirm. The ribbon route is Home > Paste > Values. Menu details can vary slightly by Excel version and platform.
Keep a copy of the original data before replacing it. Once you paste values over the source, the original capitalization is gone unless you can restore it from a backup or undo history. Pasting values is also useful when the workbook will be shared with someone who needs the corrected text but does not need the formulas that produced it.
Use Flash Fill for a Quick One-Time Change
Flash Fill can recognize a pattern from examples and fill a neighboring column with matching text. For example, if A2 contains “jANE DOE,” type “Jane Doe” in B2. Begin entering the correctly formatted version of the next name in B3. If Excel recognizes the pattern, it may preview the remaining results; press Enter to accept them. In desktop Excel for Microsoft 365 on Windows, Ctrl+E runs Flash Fill. You can also use Data > Flash Fill.
Flash Fill creates values, not a live formula. If you later edit the source names, the filled results do not automatically recalculate. It is useful for a small cleanup where Excel can infer the intended pattern, but check every result—especially with mixed formats, initials, hyphenated names, or abbreviations. If Flash Fill does not offer a suitable preview, use a formula or a deliberate manual correction instead.
Create a One-Click Capitalize Button
If you need a button that changes selected cells repeatedly, you can add a Form Control button and assign it a VBA macro. The example below applies proper case to selected text constants. It leaves formulas, numbers, and other non-text values alone. Proper case capitalizes the first letter of each word; it is not a sentence-case command.
- On Windows, show the Developer tab if necessary: go to File > Options > Customize Ribbon, then select the Developer checkbox.
- Press Alt+F11 to open the Visual Basic Editor, choose Insert > Module, and paste the macro below into the module.
- Return to the worksheet and select the cells you want to change. On the Developer tab, choose Insert > Form Controls > Button, then drag to draw the button.
- When Excel asks which macro to assign, select
CapitalizeSelection. Click the button with the target cells selected to run it.
Sub CapitalizeSelection()
Dim target As Range
Dim cell As Range
' Change text constants only; leave formulas and other values alone.
Set target = Selection
For Each cell In target.Cells
If Not cell.HasFormula Then
If VarType(cell.Value2) = vbString Then
cell.Value = Application.WorksheetFunction.Proper(CStr(cell.Value2))
End If
End If
Next cell
End Sub
Save a macro-enabled workbook as an .xlsm file; the standard .xlsx format does not store VBA macros. Save a separate copy before running the macro. Macro changes cannot be undone with Ctrl+Z, so test it on sample data first. Only enable macros in workbooks you trust. Excel for the web does not run VBA macros, so this button works in the desktop app. Excel for Mac supports VBA, although its ribbon and keyboard instructions can differ from Windows.
Power Query and Other Practical Options
For a repeatable import or data-cleaning process, Power Query can change text case while preparing data. In the Power Query Editor, select the text column and choose Transform > Format > Capitalize Each Word, Uppercase, or Lowercase. The exact choices depend on the selected column and Excel build. When you refresh the query, Excel reapplies the transformation to the refreshed source data.
Power Query is useful when the same cleanup must be repeated on incoming files, but it is not an in-cell button for editing the original worksheet values. It produces query output, and refreshes can replace that output. For a few cells, formulas or direct editing are simpler. For a reusable action on selected worksheet cells, a macro is the closer match to a capitalization button.
Common Problems and How to Avoid Them
- Proper case changes acronyms.
PROPERmay turn “USA” into “Usa.” Review abbreviations, product names, and organization names manually. - Names do not follow one universal pattern. “McDonald,” “van der Meer,” and names with particles or unusual internal capitals may need specific treatment. A formula cannot know the preferred spelling from context.
- A formula appears not to change the source. That is expected: it displays the transformed result in another cell. Copy and paste values only when you are ready to replace the original.
- The macro does not run. Confirm that the workbook is saved as .xlsm, macros are permitted by the organization’s security settings, and the button is assigned to the correct macro. The web app cannot execute VBA.
For records where exact spelling matters, keep an untouched source column and compare the result before distributing it. Capitalization is cosmetic in some datasets, but names, identifiers, and codes can be case-sensitive in other systems. Do not assume that changing case is harmless just because the spreadsheet displays the values correctly.
Frequently Asked Questions
Is there a Capitalize button in Excel?
Not as a built-in command for changing cell text case. Use UPPER, LOWER, or PROPER, use Flash Fill, or create a macro button in desktop Excel.
How do I capitalize the first letter of every word?
With the text in A2, enter =PROPER(A2) in another cell. It capitalizes each word’s first letter and lowercases other letters, so check acronyms and proper names.
Can I change text to uppercase without a formula?
Flash Fill can create uppercase results if you provide a clear example and Excel recognizes the pattern. For a repeatable one-click change to selected cells, use a VBA macro in desktop Excel.
Can I capitalize text directly in Excel for the web?
You can use worksheet formulas in Excel for the web, but it does not run VBA macros. A desktop macro button therefore will not perform its action in the browser.
Will a capitalization formula change the original cell?
No. A formula returns the changed text in the cell containing the formula. To replace the source, copy the result and paste values over it after checking the output.
Related
- Excel Borders: How to Add, Change, and Remove Them
- Excel Border Shortcuts: Apply, Change, and Remove Borders
- Bluebeam to Excel: Export Markups and Quantities
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Dynamic Calendar in Google Sheets: How to Build OneTo create a dynamic calendar in Google Sheets, enter a date in a month-control cell, then use a…
- Power Query Errors: Causes, Meanings, and FixesA Power Query error means that a query step could not interpret, retrieve, or transform something it was…
- Excel Keyboard Shortcuts to Switch Between Worksheet TabsIn Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next sheet tab, or…
- Excel Data Validation: How to Color Cells by ValueNo—Excel Data Validation cannot directly set a cell’s fill color. To color cells based on whether their contents…
- How to Add Footnotes in Word and Format Them CorrectlyTo add a footnote in Microsoft Word, place the cursor where its marker should appear, then choose References…
- How to Add Space After a Header in WordTo add space after a heading in Word, select its paragraph, open the Paragraph settings from the Home…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.