To make a number small and raised in Excel, first make the cell’s contents text, select only the digit or digits to raise, then open Home > Font dialog box launcher > Font and select Superscript. This changes how the selected characters look; it does not create a new numeric value for calculations.
Superscript is useful for writing exponents such as 10², ordinal endings such as 1st, or footnote markers in a cell. The key detail is that superscript formatting is a character-level text effect. If your entry must remain a number that Excel can calculate with, read the notes below before changing it to text.
What You’ll Need
- Microsoft Excel for Microsoft 365 on Windows.
- A cell containing text, or a cell you can convert to text. If the cell contains a number Excel treats as a numeric value, convert it to text before trying to format just some of its digits.
- A few seconds to select the exact characters you want to raise. You do not need an add-in, macro, or special font.
Step-by-Step
- Decide whether the entry needs to be text or a number. If you are creating a label such as 10², you usually want a visual label, not a value Excel will calculate. Superscript formatting is suitable for that. If you need Excel to multiply 10 by itself, keep the value numeric and use a calculation in a separate cell instead; formatting digits as superscript does not perform exponentiation.
- Prepare the cell as text. For a new entry, select the cell, go to Home > Number Format and choose Text before typing. Alternatively, type an apostrophe before the entry, such as
'10 squared; Excel uses the apostrophe to mark the entry as text and does not show it in the cell. For an existing numeric entry, edit it and add an apostrophe at the beginning, then press Enter. Check the result: Excel should treat the cell as text rather than a number. - Enter the complete text first. For example, type
10 2if you want the 2 to appear raised, or type a label such asItem 1stif you want to raise the ending letters. You can also enter an exponent label such asx2. The ordinary characters make it easier to see what you are selecting before applying the effect. - Open the cell for editing. Click the cell and press F2, or double-click the cell. You can also click in the formula bar. A text cursor should appear in the cell or formula bar. If F2 changes a laptop’s brightness or another system setting, use Fn+F2, or double-click the cell instead.
- Select only the characters to raise. Use the mouse to drag across the final 2 in
10 2, or across just the letters you want raised. You can also use the arrow keys while holding Shift to extend the selection one character at a time. Make sure the selection does not include the whole entry unless you intend to raise every character. - Open the Font settings while the characters are selected. On the Home tab, find the Font group and click its small dialog box launcher in the lower-right corner. In the Format Cells window, choose the Font tab. The characters must still be selected while you open the dialog; otherwise, the effect may apply to the whole cell or not to the intended characters.
- Turn on Superscript. Under Effects, select the Superscript checkbox, then click OK. The selected character or characters should now look smaller and sit above the normal text line. For instance, the text label 10 followed by a raised 2 will look like 10².
- Check the cell after editing. Press Enter if you are still in edit mode, then click another cell. Confirm that only the intended characters are raised and that the entry displays as you want. If Excel shows an apostrophe in the cell, remove it and re-enter the text marker correctly; a leading apostrophe used to mark text should not display as part of the cell contents.
Mac note: In Excel for Mac, you can use the same character-selection approach and open the Format Cells dialog from the Font group on Home. The keyboard shortcut is generally Command+1 rather than Windows Ctrl+1. Depending on your keyboard settings, you may need to hold Fn to use a function key. Excel for the web has more limited options for formatting selected characters; if you cannot find the Superscript effect there, open the workbook in the desktop app.
Common Mistakes
- Trying to raise part of a numeric value. A cell containing the number 102 is stored as one numeric value, not as three separately styled text characters. Convert the entry to text if you need only the final digit raised. Remember that the resulting text is no longer a normal numeric value for arithmetic.
- Selecting the cell instead of its characters. Clicking once selects the whole cell. To apply superscript to only part of the content, enter edit mode and highlight the characters inside the text. If nothing is selected, Excel may apply the effect to all the text you enter next or to the whole cell, depending on how you proceed.
- Expecting the display change to change the math. Making a 2 look raised does not tell Excel to square a value. It is only formatting. For a real calculation, use the caret operator in a formula, for example
=10^2, which returns 100. Keep the calculation separate from a decorative text label when both are needed. - Applying the effect to a formula result. A formula returns a value, and Excel does not preserve selected-character formatting inside the formula result in the same way it does for manually entered rich text. If the result needs a raised character, use a text label or a Unicode superscript character, or arrange the notation in separate cells.
- Confusing superscript with a custom number format. Excel number formats can change how a whole numeric value displays, such as showing decimal places, but they do not position one selected digit above the others. Use character formatting for a text label instead.
Tips
- Use superscript only for the characters that need it. For an exponent such as 10², keep 10 at the normal baseline and raise only the 2. This makes the relationship clearer than shrinking or raising the entire entry.
- Use Unicode superscript characters for simple, fixed labels. You can paste characters such as ² or ³ directly into text. This is convenient for a short label, but the available superscript forms are limited, and not every digit, letter, or symbol has a matching character. Such characters are text, not ordinary numeric digits.
- Keep a numeric value in a separate cell when calculations matter. For example, use one cell for the numeric input and another for the human-readable label. That keeps sorting, arithmetic, and references more predictable than turning a working value into text.
- Make the text before applying formatting. If you type more characters after formatting, Excel may continue using the current character style. To avoid accidentally raising later text, move the insertion point beyond the superscript, switch the style back off through the Font dialog, or finish typing before applying formatting.
- Check the result at normal zoom. Superscript can look too small at a reduced worksheet zoom level. Increase the zoom temporarily or inspect the cell in the formula bar to confirm that the intended characters are present.
Troubleshooting
The Superscript option is unavailable or has no visible effect: First check that you are editing text and that specific characters are selected. Numeric cells do not behave like character-formatted text. Convert the entry to text, re-enter edit mode, select the characters again, and reopen the Font tab. If you are using Excel for the web, try the desktop version, where the character formatting controls are more complete.
The whole entry became superscript: Undo immediately with Ctrl+Z on Windows or Command+Z on Mac. Reopen the cell for editing, highlight only the required characters, and apply the effect again. If the whole cell remains raised, select all its text in edit mode, turn off Superscript in the Font dialog, and then format just the intended characters.
The entry no longer adds or sorts like a number: That is expected after converting it to text. If you need arithmetic, keep a separate numeric version or restore the number and use a separate text label for display. Do not rely on a superscript-looking text entry as a numeric input.
The effect disappears when the value changes: Character formatting is attached to manually edited text, not reliably to the changing characters of a formula result. Use a fixed text label, a Unicode superscript symbol where suitable, or separate cells for the normal and raised parts. If the content must update dynamically, consider whether a simple label is sufficient or whether the display should be built outside the formula result.
Frequently Asked Questions
Is there a keyboard shortcut for superscript in Excel?
There is no standard single-key superscript shortcut in Excel for Windows. Select the text characters, open Format Cells with Ctrl+1, go to Font, and select Superscript. On Mac, Command+1 generally opens Format Cells.
Can I superscript just one digit in a cell?
Yes, when the cell contains text. Enter edit mode, select the digit itself, and enable Superscript in the Font tab of Format Cells. If the cell holds a numeric value, change it to text first; partial-character formatting is meant for text content.
Will Excel still calculate with a superscript number?
No, not if you converted the entry to text to format only part of it. Superscript is a visual effect, not a mathematical operation. Keep the calculation in a numeric cell and use a separate label if you need both calculation and raised notation.
Can I superscript a number produced by a formula?
Not reliably as partial-character formatting within the formula result. Formulas return values rather than manually styled pieces of text. For a fixed display, use a text entry with formatting or a suitable Unicode character; keep the actual calculation in another cell.
Can I use ² or ³ instead of formatting a digit?
Yes. Those are Unicode superscript characters that you can paste into a text label. They are useful for common fixed notation, but they are characters rather than numeric digits and may not cover the exact symbols you need.
How do I remove superscript?
Select the affected characters while editing the cell, open Home > Font dialog box launcher > Font, clear Superscript, and click OK. If you just applied it, use Undo instead.
Related
- Excel Solver Answer Report: Create and Read It
- How to Run Solver in Excel: Setup and Optimization
- K-Means Clustering in Excel: Solver and Easier Methods
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Apps Script Documentation: How to Use ItGoogle Sheets Apps Script documentation is available in Google’s official Apps Script developer documentation, especially the Spreadsheet service…
- Group Rows in Excel: Steps, Outlines, and FixesTo group rows in Excel for Microsoft 365 on Windows, select the rows, then choose Data > Outline…
- Excel Gridlines: How to Make Them Print on Every PageTo make worksheet gridlines print in Excel for Microsoft 365 on Windows, select the worksheet, open Page Layout,…
- Google Sheets Timesheet Template: Setup, Formulas and TipsTo make a timesheet template in Google Sheets, create columns for the date, start time, end time, unpaid…
- Debt Snowball Spreadsheet: Build a Payoff Tracker in ExcelBuild a debt snowball spreadsheet in Excel by listing each debt from smallest to largest balance, setting a…
- Link a PivotChart to a Different PivotTable in ExcelYou generally cannot retarget an existing Excel PivotChart directly to a different PivotTable. To make a chart use…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.