How to Make a Number Superscript in Excel

To make part of an entry superscript in Excel for Microsoft 365 on Windows, edit a text cell, select the character or digits, press Ctrl+1, open the Font tab, check Superscript under Effects, and select OK. This changes how selected text looks, not its numeric value; if the cell must remain a number for calculations, use a superscript Unicode character only when the symbol you need is available, or keep the calculation and its label separate.

What You’ll Need

Excel for Microsoft 365 on Windows for the steps below. Excel for Mac has a similar Format Cells dialog, while Excel for the web may not offer the same character-level formatting controls.
A cell containing text, such as 10th, m2, or a label that includes a number. You can also enter a new text entry as a starting point.
A keyboard and mouse or trackpad so you can select only the characters to raise. If you need a particular superscript digit in plain text, you can instead copy a Unicode character such as ² or ³.

Step-by-Step

Decide whether the entry is for display or calculation. Superscript is a visual character format. It is useful for things such as ordinal endings, footnote markers, and units like square metres. It does not make Excel calculate an exponent. If the cell needs to be a numeric value for sorting, arithmetic, or charting, do not turn the whole entry into text just to change its appearance. Keep the numeric value in one cell and put the formatted label in another if that suits your worksheet.
Enter or locate text in a cell. For example, enter 10th if you want only the letters “th” raised, or m2 if you want the 2 raised as part of a unit label. Excel normally treats entries containing letters as text. If you need a number-looking entry such as 10 to be treated as text, format the cell as Text before typing, or type an apostrophe before the entry. Excel uses the apostrophe to mark text and does not display it in the cell.
Open the cell for editing. Select the cell and press F2, or double-click the cell. You can also click in the formula bar and edit the text there. The cell must be in edit mode before you can select a character within its contents; selecting the cell once is not the same as selecting its characters.
Select exactly the characters to raise. Drag across the target characters in the cell or formula bar. For example, in 10th, select just th if the ordinal ending should be superscript. In m2, select just the 2. Check the selection before continuing: if the entire entry is highlighted, the formatting will affect the entire entry rather than only the intended part.
Open the Format Cells dialog. With the characters still selected, press Ctrl+1. Alternatively, on the Home tab, open the Font dialog using the small dialog box launcher in the lower-right corner of the Font group. In the dialog, select the Font tab if it is not already open.
Apply the superscript effect. Under Effects, select the Superscript check box, then select OK. The selected characters should appear smaller and higher than the surrounding text. If the full entry is raised, go back into edit mode and repeat the selection with only the intended characters highlighted.
Finish editing and check the result. Press Enter to commit the change, then click a different cell. Look at the result at normal worksheet zoom and, if relevant, in Print Preview. Superscript can look subtle at a small zoom level, and the final appearance can vary with the font and row height.

On a Mac: The same character-selection approach works in desktop Excel for Mac. Edit the cell, highlight the relevant characters, and open Format Cells with Command+1 in versions where that shortcut is available. Use the Font tab and Superscript effect. If the shortcut differs in your setup, use the Format Cells command from Excel’s menus. On Excel for the web, character-level formatting can be limited or unavailable depending on the current interface; if you cannot select and format individual characters, open the workbook in the desktop app.

For a standalone superscript digit: When the entry is plain text and you do not need to apply Excel’s character formatting, you can paste a Unicode superscript character directly. Common examples include ⁰, ¹, ², ³, ⁴, ⁵, ⁶, ⁷, ⁸, and ⁹. This is often convenient for a label such as m². It is a different character, not an ordinary digit with a formatting effect, so check that the font and the app where the workbook will be opened display it correctly. Superscript Unicode characters are not available for every letter or symbol.

Common Mistakes

Formatting the whole cell instead of selected characters: A single click selects a cell, not part of its contents. Enter edit mode first, then highlight the specific characters. When you reopen Format Cells, confirm that the intended text remains selected.

Expecting superscript to change a calculation: Superscript changes appearance only. It does not tell Excel to raise one value to a power. In a mathematical expression, the caret operator represents exponentiation, but that is a calculation feature, not character styling. Keep the two ideas separate: use superscript formatting or a superscript symbol for labels, and use Excel’s arithmetic operators for computed results.

Trying to apply rich-text formatting to a formula result: A cell displaying text returned by a formula is controlled by the formula, and Excel does not let you format just a few characters of a formula result as if it were a manually typed text entry. The same issue applies to values that change as calculations update. Use a separate manually formatted label, or build a display string with a Unicode superscript character if that meets your needs. Do not replace a useful numeric result with text if other formulas depend on it.

Converting a value to text without noticing: A leading apostrophe or the Text number format can preserve a number-looking entry as text, but text is not interchangeable with a number in every calculation, sort, or chart. Use this approach only for entries intended as labels. Keep original numeric data in numeric cells, especially when the values will be summed or compared.

Using the wrong character: A normal 2 and the Unicode character ² may look similar in a sentence, but they are distinct characters. Searching, replacing, matching, and calculating can treat them differently. Choose the formatted ordinary digit when you need to retain the original text characters, and choose Unicode only when its character-level difference is acceptable.

Tips

For ordinal text, select only the ending letters: in 1st, raise st; in 2nd, raise nd; and in 3rd, raise rd. This keeps the main number at its usual baseline and makes the treatment consistent. For unit labels, apply superscript only to the exponent digit, as in cm2 with the 2 raised, rather than raising the whole unit.

If you are entering many similarly formatted labels, set up one correctly formatted example and copy it as a starting point, then edit the text. Inspect each copied entry because Excel may carry the character formatting into newly typed characters, depending on where you edit. If an unintended character remains superscript, select it and clear the Superscript check box in Format Cells.

Choose a font and size that remain legible when printed. Superscript characters are smaller, and very small worksheet text may become difficult to read on paper or in a screenshot. Adjust the column width or row height if the result appears clipped, but do not assume a larger row height will fix every display issue. Check both the worksheet and Print Preview when the output is for a report.

For repeatable formatting, consider using a separate column for the underlying value and another for its display label. For example, a numeric measurement can remain available for formulas while a text label shows the unit with a raised digit. This arrangement helps avoid accidental text conversions and makes it clearer to future users which cells are meant for calculations.

Troubleshooting

The Superscript option is unavailable or has no effect: Make sure you are editing a text entry and have selected characters within it, rather than selecting a whole cell containing a number or a formula result. Excel’s character-level formatting is intended for text. If the cell contains a formula, make a separate text label or use an appropriate Unicode character for display instead.

The entire entry changes size or position: Re-enter edit mode and carefully select only the target characters. If the whole cell was selected when you changed the effect, Excel may apply it to all the text. You can correct it by selecting the whole entry in edit mode, clearing Superscript, and then selecting only the desired characters and applying the effect again.

The superscript looks too high, too small, or clipped: The visual result depends on the font, font size, and zoom. Try a different font or slightly increase the cell’s font size, then inspect the row height. If the entry is a label and precise positioning matters more than retaining ordinary characters, test a Unicode superscript symbol in the intended font. Check the printed or exported result as well as the screen display.

The number stops working in a calculation: Check whether it was entered as text, perhaps because of a leading apostrophe or a Text-formatted cell. Restore or re-enter the underlying value as a number in a separate cell, and keep the superscripted version as a display label. Avoid relying on a visually superscripted string as a numeric input.

The formatting disappears in Excel for the web or another program: Open the workbook in desktop Excel and check whether the workbook is being viewed in a compatible app. Rich-text formatting and Unicode display can vary between applications, fonts, and export formats. If the file is shared, test it in the recipient’s likely app and use a separate label or a simple Unicode symbol when that gives more reliable display.

Frequently Asked Questions

Can I make only one digit in a cell superscript?
Yes, when the cell contains editable text. Enter edit mode, select that digit, and apply Superscript through Format Cells. This does not work as character formatting on a formula’s calculated result.

What is the keyboard shortcut for superscript in Excel?
Excel for Windows does not provide a default one-key shortcut that directly toggles superscript on selected characters. Use Ctrl+1 to open Format Cells, then choose Font and Superscript. On Mac, Command+1 commonly opens Format Cells.

Will a superscript number still be a number?
Applying superscript to part of a text entry changes its display, not its meaning as an exponent. A standalone numeric value and a text label are different things in Excel. Keep values used in calculations numeric, and use a separate formatted label for presentation when needed.

How do I type ² or ³ quickly?
Copy and paste the character into a text entry, or use your computer’s character picker if available. These are Unicode characters, so they can display differently across fonts and apps. Excel does not treat ² as an ordinary 2 with a superscript effect.

Can I superscript an entire cell?
You can apply the Superscript effect to all the text in an editable text cell by selecting the entire entry before opening Format Cells. It is usually more useful to raise only an exponent, ending, or reference marker. Applying it to a numeric value does not change the value’s calculation behavior.

Does superscript work in Excel for the web?
Some formatting controls in the web app differ from desktop Excel, and selecting only part of a cell’s text may not be supported in the same way. If you cannot select individual characters or find the effect, open the workbook in desktop Excel for Windows or Mac and apply the formatting there.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.