To make text superscript in Excel for Microsoft 365 on Windows, select the characters in the cell, press Ctrl+1, open the Font tab, check Superscript, and select OK. For an entire cell, select the cell before opening the Font tab. Superscript changes how characters look; it does not calculate a power or change the underlying value.
What You’ll Need
- Excel for Microsoft 365 on Windows, or the desktop version of Excel for Mac. Character-level formatting is easiest to set up in the desktop app.
- A cell containing the text or number you want to format. You can enter the content first or type it while editing the cell.
- If you need a superscript character that Excel’s formatting cannot provide in your situation, such as a particular symbol, you may also use a Unicode character from Insert > Symbol.
Step-by-Step
- Enter the content. Type the word, number, or label in a cell and press Enter. For example, enter m2 if you want the 2 to appear raised, or enter 1st if you want only the letters “st” raised. You can also format content that is already in the worksheet.
- Choose whether to format the whole entry or just part of it. To superscript all the text or characters in one cell, click the cell once. To superscript only a few characters, double-click the cell or select it and press F2 so you can edit its contents. Then highlight the exact characters inside the cell. You can also select the text in the formula bar while editing. Take care not to highlight characters from a neighboring cell.
- Open the Format Cells dialog. On Windows, press Ctrl+1. Alternatively, right-click the selection and choose Format Cells. If you selected characters while editing a cell, keep that text selection active as you open the dialog. In Excel for Mac, press Command+1; you can also use Format > Cells from the menu.
- Open the Font settings. In the Format Cells dialog, choose the Font tab. Find the Effects area, where Excel lists Superscript and Subscript. These are separate settings: choose Superscript to raise the selected characters.
- Apply the setting. Check the Superscript box and select OK. Excel applies the effect to the selected characters, or to the whole cell if you selected the cell without entering edit mode. If you were editing text, finish the edit and press Enter if needed.
- Check the result and the cell’s value. Confirm that the intended characters sit higher and are smaller than the surrounding text. If the superscript is part of a label, check that the cell still contains the characters you expect. Formatting changes appearance, not the underlying text or number.
Example: raise just the suffix in a cell
Suppose a cell contains “1st”. Double-click that cell, select only the letters “st”, and open Format Cells with Ctrl+1. On the Font tab, check Superscript and select OK. The “1” stays at its normal position while the suffix appears raised. The cell still contains the text “1st”; it has not become a date, a formula, or a different kind of value.
Example: format the whole cell
If a cell contains a unit such as “cm2” and you want every character raised, select the cell once without editing it, open Format Cells, and check Superscript. That applies the effect to the whole entry. If you only want the 2 raised, edit the cell and select just that character instead.
Common Mistakes
- Confusing a visual superscript with exponentiation. Superscript formatting is a font effect. It does not make a calculation such as “three squared.” For arithmetic, use Excel’s caret operator. With the base number in A1 and an exponent of 2, enter
=A1^2in another cell; if A1 contains 3, the result is 9. That calculates a power but does not display the 2 as a raised character. - Selecting the cell instead of the characters. A single click selects the cell as a whole. Excel then applies the effect to all its contents. To format only one character or a suffix, enter edit mode and highlight that portion before opening the dialog.
- Expecting the font effect to alter a formula result selectively. A formula returns a value or text; it does not preserve different font styles for individual characters in its result. Applying Superscript to a formula cell formats the displayed result as a whole. To show one raised character in a formula-generated label, consider using a separate label cell or a suitable Unicode character.
- Applying both Superscript and Subscript. These are alternative character effects. If the result looks wrong, reopen Format Cells > Font and make sure only the intended box is checked.
- Expecting every letter to have a matching Unicode superscript. Unicode has many superscript digits and some letters, but it does not provide a complete, consistently supported raised alphabet. For ordinary text, Excel’s Superscript effect is usually more flexible.
- Assuming formatting changes the value used in calculations. A number’s displayed appearance and its stored value are different things. A superscript-style number remains the same underlying number, and text containing a raised character is still text.
Tips
- Use character formatting for labels and notation. It works well for footnote markers, ordinal suffixes, chemical notation, and measurement labels when the raised characters are part of text. For example, you might raise “th” in “4th” or the 2 in a unit label.
- Keep calculation values separate from presentation text. If a number must remain easy to sort, add, or use in formulas, store the actual number in its own cell. Use a separate label or note for the version with raised characters. This helps prevent text-formatted symbols from being mistaken for numeric data.
- Use the same method for subscript when needed. In Format Cells > Font, choose Subscript instead of Superscript. Do not select both effects for the same characters.
- Use Unicode only when it suits the content. To insert a special character, select a cell and choose Insert > Symbol, then locate the character and insert it. The exact available characters and dialog layout can vary by Excel version and font. Unicode characters are literal characters, not formatting; a superscript ², for example, may not behave like the ordinary digit 2 in a calculation or text search.
- Remember the Mac shortcut difference. On Windows, Ctrl+1 opens Format Cells. On Mac, use Command+1. The dialog’s Font tab and Superscript setting serve the same purpose, though menu and dialog layouts can differ slightly.
- Consider how the sheet will be shared. Character formatting generally travels with the workbook when it is opened in desktop Excel. If a recipient uses a different spreadsheet program or font, check the appearance after sharing, especially for unusual symbols.
Troubleshooting
- Nothing appears raised: Reopen Format Cells and verify that Superscript is checked. If you meant to raise only part of a cell, confirm that you highlighted the characters while editing, rather than selecting the cell as a whole. Also check the font size and zoom level; a small raised character can be hard to see at low zoom.
- The whole cell changed: You probably selected the cell rather than individual characters. Undo with Ctrl+Z on Windows or Command+Z on Mac, enter edit mode, highlight only the intended characters, and apply the effect again. If you have made other changes since then, avoid undoing those accidentally; reopen the dialog and correct the formatting instead.
- The dialog opens, but the text selection disappears: Exit the dialog, enter the cell with F2 or a double-click, and try selecting the characters again. You can also click in the formula bar and highlight the target text there before opening Format Cells. Avoid pressing Enter until the formatting is applied, as that can finish the edit.
- Ctrl+1 does not open Format Cells: Make sure Excel has focus and that you are not typing into a different window. On a laptop, the function-key settings may require Fn with F2 for editing; Ctrl+1 itself is the Windows shortcut. Right-clicking and choosing Format Cells is an alternative. On Mac, use Command+1 or the Format menu.
- You are using Excel for the web: The web version’s formatting controls can differ from desktop Excel, and character-level font effects may not be available in every web interface. If you cannot find the Superscript option, open the workbook in the desktop app and use Format Cells > Font. Existing formatting may still be visible in a browser even when the browser does not offer the same editing control.
- A formula-generated label will not raise just one character: A formula cannot assign one font effect to only part of its returned text. Use a separately formatted cell for the raised character, or insert an appropriate Unicode superscript character if it is available and suitable. Keep in mind that a Unicode symbol may not be equivalent to the ordinary character for calculations, searching, or sorting.
Frequently Asked Questions
Is there a keyboard shortcut that directly superscripts text?
Excel for Windows does not have a standard single shortcut that toggles superscript formatting. Use Ctrl+1 to open Format Cells, then choose the Font tab and check Superscript. On Mac, Command+1 opens the corresponding dialog. Shortcuts for superscript in other Office apps do not necessarily work in Excel.
Can I superscript only one character in a cell?
Yes. Enter edit mode by double-clicking the cell or pressing F2, select the specific character, and apply Superscript through Format Cells > Font. The rest of the cell’s text can remain at its normal position and size.
Does superscript formatting change a number or formula?
No. It changes how characters appear, not the underlying value or calculation. Use the caret operator in a formula when you want to calculate an exponent. Use the Font tab’s Superscript effect when you want characters to look raised.
Can I superscript text returned by a formula?
You can apply the effect to the formula cell’s displayed result, but Excel does not let a regular formula give only some returned characters a different font style. For a mixed-style label, use separate cells or an appropriate Unicode character instead.
Can I superscript in Excel for Mac?
Yes. Select the cell or characters, press Command+1, choose the Font tab, check Superscript, and select OK. You can also use Format > Cells to reach the dialog.
Why might a superscript character look different on another computer?
Fonts and spreadsheet applications can render characters differently, and some Unicode symbols are not supported consistently. Excel’s character formatting is generally a better choice for ordinary text. For a shared workbook, reopen it in the target app or ask the recipient to check the displayed result.
Related
- IFS Syntax in Google Sheets: Examples and Common Errors
- IF vs IFS in Google Sheets: Which Formula Should You Use?
- Forward Google Sheets: What Happens When You Share?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Insert Row Below Shortcut on Windows and MacIn Excel for Microsoft 365 on Windows, select the worksheet row directly below where you want the new…
- Excel Scatter Plot With Named Points: Add Name LabelsTo show names beside points in an Excel scatter plot, put the names in worksheet cells, select the…
- Inventory Spreadsheet Template for Google SheetsFor an inventory spreadsheet, use Google Sheets rather than Google Docs: Sheets is Google’s spreadsheet app, while Docs…
- Remove Formatting in Word on a Mac: Step-by-Step GuideTo remove formatting in Word on a Mac, select the text or paragraphs, open the Home tab, and…
- How to Create a Template Form in Word: Step by StepCreate a reusable form in Word by adding content controls for text, dates, checkboxes, and dropdowns, restricting editing…
- How to Insert an Image as a Watermark in Excel for PrintingTo add an image watermark to an Excel printout, place the image in the worksheet’s header: in Excel…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.