To add a superscript number in Excel for Microsoft 365 on Windows, edit a text cell, select just the digit or digits, press Ctrl+1, open the Font tab, check Superscript, and select OK. This changes how the selected characters look, not their mathematical value. For calculations, keep the number numeric and use an appropriate number format or a separate text label.
Superscript is useful for ordinal endings such as st in 1st, footnote markers, units such as m², and exponents shown as text. The steps below cover character formatting, plus alternatives when you need a standalone superscript digit or a number that Excel can calculate with.
What You’ll Need
- Excel for Microsoft 365 desktop on Windows for the full character-formatting steps. A keyboard and mouse make selecting individual characters easier.
- Text in a cell, such as 10th, note2, or m2. Character-level formatting is intended for text; Excel cannot make only part of a numeric value superscript while keeping that value as a normal number.
- If you are using Excel for Mac or Excel for the web, see the platform notes in the steps. The dialog or available character-formatting controls can differ.
Step-by-Step
- Enter or identify the text you want to format. For example, enter 10th in a cell if you want only the letters th to appear raised, or m2 if the 2 is a unit marker. If you are entering text that begins with a digit and Excel turns it into a number or date, format the cell as Text first using Home > Number Format > Text, then enter the text. You can also type an apostrophe before the entry, such as ’10th; Excel uses the apostrophe to keep the entry as text and does not show it in the cell.
- Open the cell for editing. Click the cell and press
F2, or double-click the cell. You should see a text cursor inside the cell. If the cell is blank, enter the full text first and then edit it. - Select only the number or characters to raise. Use the arrow keys to move the insertion point, then hold
Shiftwhile pressing an arrow key to select the desired character or range. For 10th, move to the t and select both t and h if you want the whole ending raised. Check the highlight carefully: if the entire cell entry is selected, Excel will apply superscript to all of it. - Open Format Cells. While the characters remain selected in edit mode, press
Ctrl+1. You can also use the Home tab and select the small dialog box launcher in the Font group, though the keyboard shortcut is usually quicker. Do not press Enter before opening the dialog, because that ends cell editing and clears the character selection. - Turn on Superscript. In the Format Cells dialog, select the Font tab. Under Effects, check Superscript, then select OK. The selected characters should now sit above the baseline. The characters you did not select should remain at their original size and position.
- Finish editing and inspect the result. Press
Enterto commit the cell edit, then click the cell again to make sure the superscript is legible. If it is difficult to read, widen the column, increase the font size, or use a simpler marker. Save the workbook after checking other cells that use the same notation. - For another superscript number, repeat the character selection. Formatting belongs to the selected characters, not to the whole worksheet or every occurrence of the same digit. If the same notation appears in several cells, format each cell’s relevant characters separately, or use a Unicode superscript character where rich formatting is unnecessary.
On Mac: The Format Cells dialog is generally opened with Command+1 rather than Ctrl+1. Edit the cell and select its characters first, then use the dialog’s Font tab and Superscript effect as above. Keyboard behavior and dialog labels can vary with the Excel version and macOS settings; if the shortcut does not open the dialog, use the Format Cells command from the available cell-formatting menus.
In Excel for the web: The desktop Format Cells workflow may not be available for formatting only selected characters in a cell. If the web version does not offer a Superscript control for the selected text, open the workbook in the Excel desktop app to apply rich character formatting. For a simple marker, you can instead paste a Unicode superscript digit, such as ¹ or ², into the cell.
Common Mistakes
- Selecting the whole cell instead of its characters. Clicking once selects the cell; it does not select a particular digit. Enter edit mode with F2 or a double-click, then select the exact characters inside the cell before opening Format Cells.
- Trying to superscript part of a numeric value. A numeric cell stores a value, not separately formatted characters. You cannot make just the final digit of 123 superscript and still treat the displayed entry as the ordinary number 123. Use a text label for notation, or keep the value numeric and show the notation in a nearby text cell.
- Expecting superscript to calculate as an exponent. Raising a digit visually does not create a mathematical power. A text entry such as 10² is not the same thing as a numeric calculation of ten squared. For calculations, use Excel’s normal arithmetic or a formula in a separate cell, and format any explanatory label independently.
- Applying superscript after leaving edit mode. Once you press Enter or click elsewhere, the character selection is gone. Reopen the cell and select the relevant text again before using Ctrl+1.
- Using a custom number format to raise one character. Number formats can control how a whole numeric value is displayed, but they do not provide the same character-by-character Superscript effect. Do not rely on a number format to selectively raise part of a value.
Tips
- Use superscript sparingly. A short footnote marker or unit symbol is usually clear; raising a long run of digits can become hard to scan. Check the result at the zoom level people will use.
- Consider Unicode for a one-character marker. Superscript digits such as ⁰ ¹ ² ³ ⁴ ⁵ ⁶ ⁷ ⁸ ⁹ are individual characters. You can copy one into a cell, or in desktop Excel use Insert > Symbol to look for a superscript character in the available font. Font support can affect how a symbol appears. Unicode is convenient for short labels, but it is still text and does not turn the digit into a numeric exponent.
- Keep data and presentation separate when practical. If a worksheet needs to sort, filter, or calculate with numeric values, store those values as numbers. Put a superscript note marker in a neighboring text label or use a cell comment or note for longer explanations.
- Use a consistent convention. If superscript marks footnotes, make sure each marker points to a matching note and use the same style throughout the sheet. A raised number without an explanation can be mistaken for an exponent.
- Remember formatting can be copied. You can use Format Painter for a cell’s general appearance, but it may also copy other formatting you do not want. For precise character formatting, it is often safer to select and format the characters in each target cell.
Troubleshooting
The whole entry became superscript. Reopen the cell with F2, select only the characters that should be raised, and open Format Cells again. If the whole entry is selected, turn off Superscript for that selection and repeat with a narrower selection.
Ctrl+1 opens the wrong thing or nothing happens. First make sure you are editing the cell and that the characters are selected. If a laptop uses function-key controls for system features, try the required Fn key with F2. You can also open the Font dialog from the Home tab’s Font group. On Mac, try Command+1.
The Superscript option is unavailable or has no visible effect. Confirm that the cell contains text and that you have selected characters while editing, rather than selecting only the cell. If you are using Excel for the web, open the workbook in desktop Excel for the character-level formatting workflow. Also check the font and zoom level: some fonts make small raised characters difficult to distinguish.
The entry changes into a date or a number. Undo the entry if needed, set the cell to Text with Home > Number Format > Text, and type the content again. Formatting an already converted value as Text afterward does not always restore the original characters; re-enter the intended text.
The superscript looks right but calculations fail. That is expected if the entry is text. Keep the underlying quantity in a separate numeric cell and use the formatted text only as a label, or use a calculation for the actual power and place its result in a numeric cell. Visual formatting alone never changes the arithmetic.
Frequently Asked Questions
Is there a keyboard shortcut to superscript text in Excel?
There is no dedicated single-key superscript shortcut in Excel for Windows. Select the characters in edit mode, press Ctrl+1, and check Superscript on the Font tab. On Mac, use Command+1 to open Format Cells.
Can I superscript just one digit inside a cell?
Yes, when the entry is text. Edit the cell, select the individual digit, and apply the Superscript effect. You cannot selectively raise a digit in a numeric value while preserving that value as a standard number.
How do I type a superscript 2?
For rich formatting, enter a text label such as m2, select the 2, and apply Superscript. For a standalone symbol, paste ² or use Insert > Symbol in desktop Excel if the character is available in the chosen font.
Does superscript make a number an exponent?
No. Superscript is a visual style. To calculate a power, use Excel arithmetic in a formula; to display an exponent in a heading or explanation, format text or use a suitable Unicode character.
Will superscript formatting appear when I share the workbook?
It generally appears in Excel desktop and in compatible spreadsheet viewers, but fonts and web editing features can affect the display. If the marker is important, check the workbook in the recipient’s environment or use a widely supported Unicode character for a simple digit.
Related
- Excel Shortcut to Switch Between Worksheet Tabs
- Excel Yellow Highlight Shortcut: Apply Cell Fill
- Home Clean List Excel: Build a Practical Checklist
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Apply a Dropdown to an Entire Column in Google SheetsTo apply a dropdown to a whole column in Google Sheets, select the column or enter its range…
- Excel Max Absolute Value: Find the Largest MagnitudeTo find the largest absolute value in Excel for Microsoft 365, enter =MAX(ABS(A2:A10)) in a cell, replacing A2:A10…
- Proper Excel Formatting: Clear, Reliable Spreadsheet RulesProper Excel formatting makes a spreadsheet easier to scan, understand, update, and print. In Microsoft Excel for Microsoft…
- Cut, Copy, and Paste in Excel: Shortcuts and StepsTo cut, copy, or paste in Excel for Microsoft 365 on Windows, select the cell or range and…
- How to Center Text in Excel Using Keyboard ShortcutsTo center text horizontally in Excel for Microsoft 365 on Windows, select the cell or cells and press…
- Excel Freeze Panes: Keep Columns Visible While ScrollingTo freeze columns vertically in Excel for Microsoft 365 on Windows, select the cell immediately to the right…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.