To use superscript in Excel for Microsoft 365 on Windows, edit the cell, select only the characters to raise, press Ctrl+1, open the Font tab, check Superscript, and select OK. Excel applies this as character formatting, so it works for labels such as x² or a footnote marker, but it does not calculate an exponent or change the cell’s underlying value.
What Superscript Means in Excel
Superscript is text that appears smaller and higher than the surrounding characters. In a spreadsheet, common examples include the 2 in m², the 3 in cm³, an exponent written as x², or a raised number used to point to a note. The formatting changes how selected text looks; it does not give the character a special mathematical function.
Excel treats superscript differently from formatting a whole cell. A cell can have a general font, size, and color, but you can also format individual characters in a text entry. That lets a cell contain both ordinary text and a superscript character. A formula cell is different: formulas return values or text, and Excel cannot ordinarily apply rich-text formatting to just part of a formula’s result.
Apply Superscript to Part of a Cell
In desktop Excel, the reliable method is the Format Cells dialog. First enter or edit the text, then select the exact character or characters to raise. You can select text while editing in the cell or by clicking the formula bar and highlighting the relevant characters there.
- Enter the text in a cell, or select a cell that already contains text.
- Press F2 to edit the active cell, or click in the formula bar. Highlight only the characters that should be superscript.
- Press Ctrl+1 to open Format Cells. Select the Font tab.
- Under Effects, select Superscript, then select OK.
For example, to display x², enter x2 as text, select just the 2 while editing, and turn on Superscript. The x remains at its normal position and size. If you select the whole entry before choosing Superscript, the entire entry is raised, which is rarely the intended result.
You can also open the same font settings from the ribbon: on the Home tab, select the small dialog box launcher in the Font group, then use the Font tab and the Superscript checkbox. The dialog is useful because it exposes the character-level effects together with other font options. Selecting text inside the cell is the essential step; opening the dialog alone does not tell Excel which characters to raise.
Keyboard Shortcuts and Mac Differences
Excel for Windows does not have a dedicated one-keystroke shortcut that directly toggles superscript on selected characters. Ctrl+1 is the shortcut for Format Cells; from there, choose the Font tab and Superscript. F2 begins editing the active cell, which can make it quicker to select the characters before opening the dialog.
On a Mac, Command+1 opens the Format Cells dialog. Select the text within the cell or formula bar, then use the Font tab and Superscript option. Depending on the keyboard and macOS settings, you may need to press Fn with a function key to send F2 to Excel. The names and placement of some controls can differ slightly between Mac and Windows, but the character-selection principle is the same.
Do not confuse Ctrl+1 with a superscript toggle: it opens the full cell-formatting dialog. Excel’s ribbon may also display different controls depending on window size and version, so the dialog is the most dependable route when you need the Superscript effect.
Formatting Several Characters or Cells
To format more than one character in the same cell, select the whole relevant span before opening the Font dialog. For example, in a text label such as CO2, selecting only the 2 raises that character; selecting the O and 2 raises both. You can also apply superscript to multiple separated characters by formatting them one selection at a time.
Applying the effect to an entire cell is different from applying it to part of its text. If you select a cell without entering edit mode and turn on a font effect, Excel generally formats the cell’s contents as a whole. This can be suitable when every character in a short entry should be raised, but it is not the way to format just a suffix or footnote marker.
When filling or copying cells, inspect the result rather than assuming the character-level formatting will behave like a formula. Copying a cell usually carries its formatting, but replacing its contents or generating new text with a formula may not preserve a particular rich-text effect. If a worksheet has many entries with carefully formatted characters, test the copy, fill, or import process on a small sample first.
Using Superscript in a Formula Result
Excel formulas do not provide a standard function that marks only selected characters in their result as superscript. A formula can join text with a Unicode superscript character, but that inserts a different character; it is not the same as applying the Superscript font effect. This distinction matters if the output must be edited, searched, copied to another program, or interpreted as ordinary text.
For a fixed label, a Unicode character can be convenient. With B1 available for the output and no source cell needed, enter this formula in B1:
= "x" & UNICHAR(178)
The result is x². UNICHAR(178) returns the Unicode superscript two character, and the ampersand joins it to the letter x. The result is text, not the numeric calculation of x squared. For a label such as square metres, the same character can be typed directly or inserted with a suitable character picker; it is not necessary to use a formula if the text is static.
Unicode has superscript forms for many commonly used digits, but it is not a complete set of perfectly interchangeable raised versions of every letter, symbol, and punctuation mark. Appearance can also depend on the font and the application displaying the workbook. A Unicode superscript may not match the size or vertical position of Excel’s font effect exactly, and it may be less convenient for accessibility or later editing.
Superscript Is Not an Exponent Calculation
Visual superscript and mathematical exponentiation are separate tasks. If you type x² into a text label, Excel displays a symbol; it does not calculate x multiplied by itself. To calculate a power, use the caret operator in a formula. With the number 5 in A1 and the calculation entered in B1, use =A1^2. The result is 25. The cell contains a numeric result, so it can be used in further calculations.
If the goal is to show an exponent in an explanatory label while also calculating a result, keep the roles clear. A heading might say x², formatted as text, while a separate formula cell calculates the value. Mixing labels and numerical results in one cell can make sorting, calculations, and later maintenance more difficult.
Scientific notation is another frequent source of confusion. Excel may display a large or small number using an E notation such as 1E+06. That is a number format indicating a power of ten, not a superscript character that you can select and format independently. If the requirement is a mathematical-looking text label, create a text label; if the requirement is a numeric value, retain the number and use an appropriate number format.
Common Uses and Practical Examples
Superscript is useful when the raised character is part of a readable label, rather than a value Excel must interpret. Typical uses include:
- Units such as m², km², and cm³ in headings, reports, or chart labels.
- Footnote markers in a title or note, provided the notes are managed clearly elsewhere in the workbook.
- Scientific or educational notation in explanatory text.
- Brand names or abbreviations whose established styling includes raised characters.
For units, consider whether the cell will also be used in calculations. A text entry such as 12 m² is readable, but Excel cannot treat that whole entry as the number 12 without additional processing. For data used in formulas, keep the numeric measurement in one cell and put the unit in a heading or a separate cell. For example, storing 12 as a number and placing m² in the column heading keeps the data easier to sum and compare.
For footnotes, a raised marker alone does not create a link or a footnote system. The reader still needs a matching note, and the workbook should make the relationship clear. A superscript number can be a visual cue, but avoid relying on position alone when the note is important; use a nearby explanation or another accessible way to identify it.
Excel for the Web and Display Considerations
These steps target the desktop version of Microsoft Excel for Microsoft 365 on Windows. Excel for the web does not expose every desktop Format Cells control in the same way, and the available character-level formatting options can depend on the current web interface. If you cannot find a Superscript control for selected characters, open the workbook in the desktop app and apply the effect there. A workbook may display formatting created in desktop Excel even when the web editing controls differ.
Superscript appearance can vary slightly across fonts, operating systems, and applications. A workbook opened in another spreadsheet program may preserve the appearance, substitute a similar font, or handle rich-text formatting differently. For documents that will be exported or shared broadly, check a PDF or recipient-facing copy rather than assuming every viewer renders the characters identically.
Common Problems and Fixes
- The whole entry moved upward. You likely selected the whole cell’s contents or formatted the cell rather than highlighting only the target characters. Edit the text, select the smaller range, and apply the effect again.
- The Superscript option is unavailable or has no effect. Confirm that you are editing text and have selected characters. A formula result cannot usually be given character-level formatting in the same way as a typed text entry.
- The result looks like a normal 2. Check that only the 2 was selected and that the Superscript checkbox was enabled. Also check that the displayed cell is not showing a different value than the text you edited.
- A formula-generated label does not retain superscript styling. The formula creates a result; it does not carry rich-text instructions for selected characters. Use a Unicode character for a simple fixed label or keep the formatted label as typed text.
- The text looks different on another computer. Fonts and applications can render characters differently. Use a widely available font and inspect the workbook in the format recipients will actually use.
Frequently Asked Questions
Is there a keyboard shortcut for superscript in Excel?
There is no dedicated direct toggle in Excel for Windows. Select the characters, press Ctrl+1, open the Font tab, and check Superscript. On Mac, Command+1 opens Format Cells.
Can I superscript just one number in a cell?
Yes. Edit the cell, select only that number, and apply Superscript through Format Cells. Selecting the entire cell’s text instead will raise the whole entry.
Can a formula return superscript text?
A formula can return Unicode characters such as ², but it cannot ordinarily apply Excel’s rich-text Superscript effect to only part of its result. Unicode is a character substitution, not character formatting.
Does superscript make Excel calculate a power?
No. Superscript changes appearance. Use the caret operator in a numeric formula, such as =A1^2, to calculate a square when A1 contains a number.
Can I superscript text in Excel for the web?
The web app’s formatting controls do not always offer the same character-level effects as desktop Excel. If the Superscript option is unavailable, open the workbook in desktop Excel and format the selected characters there.
Related
- To-Do List Template in Excel: Create and Use Yours
- To Do List Excel Sheet Template: Make a Useful Tracker
- To-Do List Excel Spreadsheet: Setup, Columns and Tips
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 Undo in Excel With a Keyboard Shortcut on WindowsTo undo your most recent action in Excel for Microsoft 365 on Windows, press Ctrl+Z. Press the shortcut…
- How to Create School Labels in Microsoft Word EasilyTo create school labels in Microsoft Word, open the Mailings tab, choose Labels, select the label stock that…
- Outlook Address Book Cache: How to Clear It SafelyTo clear Outlook’s saved recipient suggestions in classic Outlook for Windows, go to File > Options > Mail…
- Subscript in Excel: Shortcut Key and How to Apply ItExcel has no dedicated keyboard shortcut that directly applies subscript. In Excel for Microsoft 365 on Windows, select…
- How to Create Mail Rules in Outlook and Manage ThemCreate a mail rule in Outlook by choosing a condition, such as a sender or a subject phrase,…
- Excel AutoFit Column Width Shortcut and How It WorksIn Excel for Microsoft 365 on Windows, select the column or columns, then press Alt+H, O, I in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.