The easiest way to superscript text in Excel for Microsoft 365 on Windows is to select the characters inside the cell, press Ctrl+1, open the Font tab, check Superscript, and click OK. On a Mac, use Command+1 to open Format Cells; the same Font tab option applies.
Apply superscript with Format Cells
Superscript is character formatting: it raises selected characters and usually makes them smaller than the surrounding text. To apply it to part of a text entry in the desktop version of Excel, follow these steps:
- Double-click the cell, or select it and press F2, to edit its contents. You can also click in the formula bar.
- Select only the character or characters to raise. For example, in the text m2, select the 2, not the whole entry.
- Press Ctrl+1 on Windows or Command+1 on Mac to open the Format Cells dialog.
- Choose the Font tab, select the Superscript checkbox under Effects, and click OK.
- Press Enter to finish editing the cell if you are still in edit mode.
The ribbon route reaches the same dialog: select the characters while editing, then choose Home and click the small dialog launcher in the Font group. In Format Cells, use Font > Effects > Superscript. The checkbox is not the same as a number format, and it will not raise every character in the cell unless you select the entire text.
Select the characters you want to raise
Excel distinguishes between selecting a cell and selecting text within a cell. A single click normally selects the whole cell, so applying a font effect at that point changes the appearance of all its contents. To superscript just part of a label, enter edit mode first. Double-clicking the cell places an insertion point in the text; F2 is a keyboard alternative on Windows. You can also select the cell and use the formula bar to locate and highlight the characters.
Once the insertion point is active, drag across the target characters or use the arrow keys while holding Shift to extend the selection. The selection needs to remain visible when you open Format Cells. If you accidentally select the entire cell, the effect may apply to the whole entry; reopen the cell, select the intended characters, and change the setting again.
For a short example, suppose a text cell contains x2 and you want the 2 raised. Edit the cell, select just the 2, apply Superscript, and the display becomes x² in appearance. The underlying characters are still x and 2; Excel has applied a visual font effect to the selected character. If the cell is a formula result rather than typed text, see the limitations below.
What superscript does—and what it does not do
Superscript changes how selected text is drawn; it does not create an exponent calculation. A raised 2 in a label such as x² is not the same as raising a number to the power of two in a formula. For arithmetic, use Excel’s exponent operator, the caret. For example, if A1 contains 5, entering =A1^2 in another cell returns 25. That formula calculates a value; the superscript effect only changes how characters look.
Likewise, applying superscript to a character does not change its meaning for sorting, searching, or calculations. It is useful for presentation—such as unit labels, footnote markers, and scientific notation typed as explanatory text—but should not be used to make a numeric value behave differently. A cell that needs to participate in calculations should contain a real number, with units or explanatory notation kept in a separate text label when practical.
Common uses and concrete examples
Superscript is most helpful when it makes a compact label easier to read without changing the data itself. Common examples include:
- Area units: Display m2 as m² by superscripting the 2 in a text label.
- Ordinal endings: In a heading or note, raise the letters in 1st, 2nd, or 3rd when that style is required.
- Footnote references: Raise a small number beside a heading or sentence, then place the corresponding note elsewhere.
- Scientific or mathematical notation: Format a typed character such as the 2 in x2 as a visual exponent in an explanatory label.
Use the effect only when the distinction is clear to readers. For example, if a table column contains measured areas, a header such as Area (m²) is clearer than superscripting digits in every numeric measurement. The data cells can remain ordinary numbers, so they continue to total and sort as expected.
Superscript formatting versus Unicode characters
There are two different ways to make text look raised. Format Cells applies a font effect to selected characters. Alternatively, you can insert or paste a Unicode superscript character, such as ², ³, or ⁴, directly into a cell. Unicode is often the quickest choice for a short, fixed label: copy a symbol from an existing source and paste it where needed.
The trade-off is that Unicode symbols are separate characters, not ordinary digits with Excel’s superscript formatting. The set of available superscript letters and symbols is limited, and the exact appearance can vary with the font. If you need a wide range of characters or want to control their appearance consistently, use character formatting in desktop Excel. If you need a quick unit label such as m², a Unicode character may be perfectly convenient.
Keep the data implications in mind. A value that includes a superscript Unicode character is text, not a plain numeric value. It will not work as a number in a sum or arithmetic formula. Similarly, a label containing units is usually best kept separate from the numeric measurement. Avoid substituting a Unicode symbol into a column that is intended to hold numbers for calculations.
Limits with formulas and Excel for the web
Excel’s superscript checkbox is designed for selected characters in cell text. A formula returns a value, and Excel does not provide ordinary character-by-character rich-text formatting for the formula’s displayed result in the same way it does for typed text. If a formula produces a label that needs a raised character, consider keeping the result as plain text and using a Unicode superscript symbol where suitable, or put the label and calculated value in separate cells.
Excel for the web has fewer options for character-level formatting than the Windows and Mac desktop apps, and the Superscript control may not be available there. If you cannot find it, open the workbook in the desktop app and use Format Cells. When you only need a simple symbol, pasting a Unicode character is a practical alternative that does not depend on the Superscript checkbox.
On Mac, the general workflow is similar, but keyboard shortcuts differ: Command+1 opens Format Cells rather than Windows Ctrl+1. If a shortcut is intercepted by your system or keyboard settings, open the dialog through the Home tab’s Font group instead.
Fix common superscript problems
- The whole cell changed: You formatted the cell rather than a character selection. Edit the cell, select only the intended text, and apply the effect again.
- The superscript option is unavailable: Check that you are in the desktop app and editing text. A formula result or a selection made outside the cell’s text may not support the character-level change you expect.
- The text looks too small: Superscript is intentionally raised and reduced in size. If a footnote or label is hard to read, use fewer superscript characters or increase the overall font size.
- The effect disappears after replacing the text: Re-entering or replacing cell contents can remove character-level formatting. Reapply the effect to the new characters.
- The symbol looks different on another computer: Fonts render Unicode symbols differently. For a workbook that must look consistent, use a commonly available font and check the file on the devices where it will be viewed.
One frequent misconception is that a raised character is a special numeric format that Excel can calculate with. It is not. Formatting is visual, while the cell’s stored content determines what calculations can use. If a report needs both a precise numeric value and a superscript-style unit, keep the value numeric and put the unit in a header, adjacent text cell, or chart label.
Make superscript readable and maintainable
Use superscript sparingly, especially in worksheets that readers may view on phones or print at reduced scale. A raised character can become difficult to distinguish when the base font is small. Use a clear heading or note to explain a footnote marker, and make sure the matching footnote is easy to find.
For shared workbooks, choose one approach and use it consistently. Character formatting is appropriate when only part of a typed text label needs to rise. Unicode is efficient for a small number of stable symbols. Separate cells are usually the clearest structure when labels and numeric data have different purposes. These choices also make it easier for another person to edit the worksheet without confusing appearance with the underlying value.
Frequently Asked Questions
What is the shortcut for superscript in Excel?
There is no dedicated one-key superscript shortcut in Excel for Windows. Select the characters, press Ctrl+1, and choose Superscript on the Font tab. On Mac, use Command+1 to open Format Cells.
Can I superscript only one number in a cell?
Yes, if the cell contains editable text. Enter edit mode, select the number itself, and apply the Superscript effect. A numeric value or formula result may not support the same partial character formatting as typed text.
How do I type squared in Excel?
For a label, type the base and use a superscript 2, either by formatting the 2 with Format Cells or by inserting the Unicode character ². For a calculation, use the caret operator instead; for example, =5^2 returns 25.
Can Excel superscript a formula result?
Not as ordinary character-by-character rich-text formatting of the formula’s displayed result. Use a Unicode symbol for a suitable text label, or separate the calculated value from the explanatory notation.
Does superscript change the cell’s value?
No. The Superscript effect changes appearance, not the underlying text or number. A pasted Unicode superscript character is different: it is part of the cell’s text and does not behave like a numeric digit.
Related
- Convert Excel to ZIP: How to Compress and Share a Workbook
- Convert an Excel Binary Worksheet (.XLSB) to Excel
- Content Calendar Template Excel: Create and Use One
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Adding a Checkbox in Google Sheets: Steps and TipsTo add a checkbox in Google Sheets in a web browser, select the cell or range where you…
- 0 in Excel Conditional Formatting: 10 Practical RulesTo highlight zero values in Excel for Microsoft 365 on Windows, select the cells, then choose Home >…
- Excel Row and Column Select Shortcut Keys ExplainedIn Excel for Microsoft 365 on Windows, press Shift+Spacebar to select the entire row containing the active cell,…
- Encrypt an Excel File on Mac: Passwords, Limits & TipsTo encrypt an Excel workbook on a Mac, open it in Excel, choose File > Passwords, enter a…
- Snowflake SPLIT: How to Split Strings by DelimiterYes. In Snowflake, use SPLIT(string, delimiter) to divide a string wherever the exact delimiter occurs; it returns the…
- Locking Cells in Google Sheets: Protect Specific RangesTo lock cells in Google Sheets, select the cells, then choose Data > Protect sheets and ranges. In…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.