To superscript text in Excel for Microsoft 365 on Windows, select the cell or the characters you want to raise, press Ctrl+1, open the Font tab, check Superscript under Effects, and select OK. This changes how text looks; it does not change the value or make Excel calculate an exponent. You can superscript a whole cell or selected characters within ordinary text.
What You’ll Need
- Excel for Microsoft 365 desktop on Windows. The steps also apply to recent desktop versions of Excel.
- A workbook with the text you want to format. Save a copy first if the workbook is important, especially before making many formatting changes.
- If you want to raise only part of a cell’s contents, the cell should contain typed text rather than a formula result. Excel does not support rich-text formatting of just part of a formula’s displayed result.
Excel for Mac has a similar Format Cells dialog, though some controls may be arranged differently. Excel for the web can show superscript formatting already present in a workbook, but its formatting controls do not offer the same full method for applying superscript. For the steps below, open the workbook in the desktop app.
Step-by-Step
- Decide whether to format the whole cell or just some characters. If every character in the cell should appear raised, select the cell once. If only a symbol, letter, or number should be raised—for example, the 2 in H2O—leave the cell unselected for now and select the characters inside it in the next step. This distinction matters: selecting the cell formats all its contents, while selecting text inside the cell lets you apply the effect to only that portion.
- Select text inside a cell, if needed. Double-click the cell, or select it and press F2, to edit its contents. Drag over the exact characters you want to raise. You can also click in the formula bar and select those characters there; this is often easier when the cell is narrow or the text is long. Check that only the intended characters are highlighted. If you are formatting the whole cell, skip this step and keep the cell selected.
- Open the Format Cells dialog. On Windows, press Ctrl+1. Alternatively, go to Home and select the small dialog box launcher at the lower-right of the Font group. If you selected characters while editing a cell, keep that character selection active as you open the dialog; do not press Enter or Escape first, since that ends the edit and removes the text selection.
- Turn on superscript. In the Format Cells dialog, select the Font tab. Under Effects, check Superscript. The preview shows the effect before you apply it. Superscript is a font effect, not a number format, so you do not need to choose a special category such as Number or Scientific.
- Apply the change and check the result. Select OK. If you formatted a whole cell, all its contents should now sit higher and appear smaller. If you formatted selected characters, only those characters should be raised. Click another cell to leave edit mode and confirm the result is visible as intended.
- Remove the effect if you applied it to the wrong text. Select the affected cell or characters again, open Format Cells, go to Font, clear the Superscript checkbox, and select OK. If the mistake was your most recent action, Ctrl+Z also undoes it. Formatting changes can be undone, but do not rely on undo after making many later edits.
For example, to make the 2 in a typed label such as x2 appear as an exponent, edit the cell, select only the 2, and apply Superscript. The x stays at its normal height. To raise every character in a cell that contains just 2, select the cell without entering edit mode and apply the same effect; the entire number will rise, which is usually not the intended appearance for an exponent.
On Mac, select the cell or characters and open Format Cells using Command+1 in Excel for Mac. You can also use the Format menu and choose Cells, then use the Font tab and check Superscript. The dialog’s labels and layout are broadly similar, but keyboard shortcuts can vary with the keyboard and macOS settings. There is no dedicated built-in keyboard shortcut that switches superscript on and off directly in Excel on Windows or Mac.
For an existing workbook in Excel for the web, use the desktop app when you need to apply superscript to selected characters. Choose Open in Desktop App from the web interface if it is available. If you only need a familiar character such as ² or ³ in a short label, you can paste that Unicode character into a cell, but it is not the same as applying Excel’s superscript effect to any character you choose.
Common Mistakes
- Selecting the whole cell instead of the intended characters. This raises everything in the cell, not just the exponent or footnote marker. Enter edit mode and highlight the precise text first when you need partial formatting.
- Expecting the effect to change a calculation. Superscript is visual formatting. It does not tell Excel to square a value, calculate a power, or change the underlying number. For a mathematical calculation, use Excel’s exponent operator in a formula; for a displayed exponent in a label, format the characters or use an appropriate Unicode symbol.
- Trying to superscript part of a formula’s result. Excel can apply a font effect to a formula cell as a whole, but it cannot independently style a few characters in the result generated by a formula. If the content is a label, consider making it typed text or constructing the presentation in another way.
- Using a custom number format to raise one digit. Custom number formats can change how values display, but they do not provide a general way to superscript just one character. Use the Font tab’s Superscript effect for rich text.
- Applying superscript to an entire value by mistake. This can make a number or label look unusually small and high. Reopen Format Cells and clear Superscript, then edit the cell and select only the characters that should be raised.
- Assuming every font will look identical. Superscript characters may look smaller or sit at slightly different heights in different fonts. This is a visual difference, not necessarily a formatting failure.
Tips
- Keep the selection visible while formatting. When working with a long label, use the formula bar to select the exact characters. Before opening the dialog, make sure the highlight covers the intended characters and not the whole cell’s contents.
- Use superscript for presentation, not data meaning. It works well for footnote markers, ordinal suffixes, and labels such as cm² when those are text. Keep the underlying data in a form that remains useful for sorting, calculations, and analysis.
- Use the caret for actual powers in calculations. In Excel formulas, the caret represents exponentiation. That is separate from formatting a character to appear raised. A formatted 2 does not perform the same job as an exponent in a calculation.
- Consider Unicode for short, fixed labels. Superscript characters such as ¹, ², and ³ can be pasted into text. This can be convenient for a heading or annotation, but the available raised characters are limited, their appearance depends on the font, and they may not behave like ordinary digits when searching or editing.
- Check the result at the size it will be read. Superscript can be hard to see in a small cell or when printed. Adjust the column width or font size if needed, and preview the worksheet before printing or sharing it.
- Copy cautiously. Copying a cell can bring along its other formatting, not only superscript. If you want the same effect on another piece of text, select the destination characters and apply the effect there, or check the result carefully after pasting.
Troubleshooting
The Superscript checkbox is missing or unavailable. Confirm that you opened the Format Cells dialog and selected the Font tab. If you are using Excel in a browser, switch to the desktop app to apply the effect. In some situations, a protected worksheet or restricted editing permission may prevent formatting; ask for permission or use an editable copy if appropriate.
The whole cell became superscript. The cell was selected as a unit when you applied the effect. Undo the change, edit the cell, highlight only the required characters, and apply Superscript again. If undo is no longer available, select the whole cell and clear Superscript first, then format the smaller selection.
Nothing changed after selecting OK. Check whether the intended text was selected before opening Format Cells. If you were editing the cell and pressed Escape or Enter, the selection may have ended. Re-enter edit mode, select the characters again, and repeat the steps. Also check that you are viewing the desktop workbook rather than a web version with limited formatting controls.
The superscript is difficult to read or appears misplaced. Try a different font or a slightly larger font size, and check whether only the intended characters are raised. For a printed worksheet, use Print Preview to see whether the small raised text remains legible at the selected scale.
The value no longer works in a formula or sort. Superscript formatting itself should not change a cell’s underlying value. However, entering a label such as x² makes the cell text, not a numeric value suitable for arithmetic. Keep calculation inputs in separate numeric cells and use a separate label for the formatted display.
Frequently Asked Questions
Is there a keyboard shortcut for superscript in Excel?
There is no dedicated shortcut that directly toggles superscript on or off. On Windows, Ctrl+1 opens Format Cells; on Mac, Command+1 generally opens the equivalent dialog. Then select the Font tab and check Superscript.
Can I superscript only one character in a cell?
Yes, when the cell contains typed text. Enter edit mode, select the character in the cell or formula bar, and apply Superscript in Format Cells. Excel does not support applying rich-text formatting to only part of a formula’s displayed result.
Does superscript change the number stored in the cell?
No. It changes the appearance of the selected text or cell, not the underlying value. To calculate a power, use an exponent in a formula; to show a raised character in a label, use formatting or a suitable Unicode character.
Can I superscript in Excel for the web?
Excel for the web may display superscript already applied in a workbook, but its controls do not provide the same full workflow for applying the effect to selected characters. Open the workbook in the Excel desktop app to format it.
How do I remove superscript?
Select the affected cell or text, open Format Cells, choose the Font tab, clear Superscript, and select OK. If you just applied it, Ctrl+Z on Windows or Command+Z on Mac can undo the change.
Can I use superscript for footnotes and units?
Yes. It is useful for footnote markers and text labels such as square units. For numerical calculations, keep the value separate from its label so the formatting does not get confused with the data Excel needs to calculate.
Related
- How to Rank in Excel When There Is a Tie: Two Methods
- How to Quick Repair Excel on Windows: Step-by-Step
- How to Randomize Excel Lists Without Any Duplicates
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Best Way to Make a Budget Sheet in Google Sheets: A GuideThe best way to make a budget sheet in Google Sheets is to keep a transaction log and…
- How to Zoom an Excel Sheet Using Keyboard ShortcutsIn Excel for Microsoft 365 on Windows, press Alt+W, then Q to open the Zoom dialog. Choose a…
- How to Export Contacts in Outlook 365 to a CSV FileTo export Outlook 365 contacts as a file you can open in Excel or import into another service,…
- How to Schedule Send an Email in New Outlook for LaterTo schedule an email in New Outlook, compose your message, open the menu beside Send, choose Schedule send,…
- How to Insert a Row in Excel After Any Specific RowTo insert a blank row after a specific row in Excel, select the row number directly below it,…
- How to Add a Cover Page in Microsoft Word Step by StepTo add a cover page in Microsoft Word for Microsoft 365 on Windows, open your document, choose Insert…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.