Adding superscript or subscript to text in an Excel cell sounds like a small formatting task, but Excel handles it less elegantly than Word or PowerPoint. There is no one-click ribbon button for superscript on the Home tab the way there is in Word.
The formatting only applies to selected characters within text cells — it does not survive being typed into formulas, and most importantly, it cannot be applied to numbers that are being used in calculations. Once you understand why these limits exist, the workarounds become obvious and you can write H₂O, m², x³ and footnote markers cleanly anywhere in your spreadsheet.
This guide walks through every reliable method for putting superscript or subscript into an Excel cell, the keyboard shortcuts that experienced users rely on, the Unicode character approach that survives copying and pasting between Office applications, and the UNICHAR formula approach that lets you build superscripts dynamically inside concatenations. The aim is to turn a frustrating formatting problem into a routine workflow you can apply in a few seconds whenever you need it.
The reason Excel handles superscript differently from Word is rooted in how the two applications treat their content. Word treats every cell of text as a stream of characters that can carry their own formatting attributes, including superscript and subscript styling. Excel treats cells primarily as data containers, with formatting layered on top, and the underlying data layer does not naturally support character-level styling within a cell. The Format Cells dialog superscript option is essentially a special case where Excel allows character-level styling for visual purposes only.
Primary method: Format Cells dialog (Ctrl+1 → Font tab → check Superscript or Subscript). Office 365 shortcuts: Ctrl+Shift+= (superscript), Ctrl+= (subscript). Quick Access Toolbar: add the Superscript and Subscript commands for one-click access. Permanent alternative: Unicode characters (¹²³, ⁰⁻⁹, ₀₋₉) that survive copy-paste and work inside formulas. Limitation: standard formatting cannot be applied to numbers used in calculations or to formula outputs.
The most reliable way to add superscript or subscript in Excel is the Format Cells dialog. Select the specific characters you want to format inside the formula bar — not the entire cell, just the characters you want elevated or lowered. Press Ctrl+1 to open Format Cells, click the Font tab, and check the Superscript or Subscript checkbox. Click OK. The selected characters now appear smaller and elevated above the baseline (superscript) or smaller and dropped below (subscript). The rest of the cell text is untouched.
The trick to making this work is selecting the right characters. If you click the cell once and press F2 to enter edit mode, you can use the mouse or keyboard to highlight just the characters you want formatted. If you select the entire cell instead, the format applies to all the text in the cell, which is rarely what you want. Practising this character-level selection on a quick test cell before tackling a real workbook saves frustration. Once you have the muscle memory, formatting H₂O takes less than five seconds.
One small frustration with the Format Cells approach is that the dialog opens to whichever tab you used last. If you have been working with number formats, the dialog opens on Number rather than Font, requiring an extra click. There is no way to default the dialog to a specific tab. Power users who frequently use superscript usually adopt the Quick Access Toolbar workaround for this reason — adding the Superscript and Subscript commands as direct toolbar buttons sidesteps the dialog entirely and reduces the operation from four steps to one.
Select characters in formula bar, Ctrl+1, Font tab, check Superscript or Subscript. Most reliable method, works in all desktop Excel versions. Slightly slow because of the multi-step dialog flow.
Office 365 introduced Ctrl+Shift+= for superscript and Ctrl+= for subscript. Select characters and press the shortcut. Significantly faster than the dialog method but only available in newer Excel versions.
Add the Superscript and Subscript commands to the Quick Access Toolbar via File → Options → Quick Access Toolbar. One-click formatting from then on. Works across all desktop Excel versions.
Type or paste Unicode superscript characters (¹²³⁰⁻⁹) and subscript characters (₀₋₉) directly into the cell. Works in formulas, survives copy-paste, but covers a limited character set.
=UNICHAR(178) returns ². Build superscript text dynamically inside concatenations like =A1 & UNICHAR(178). Useful when the superscript value comes from a calculation rather than fixed text.
Insert tab → Symbol opens a dialog where you can find and insert any Unicode character. Useful when you need a less common superscript like ⁺ or ⁻ that you cannot easily type.
Microsoft 365 added direct keyboard shortcuts for superscript and subscript in Excel. Ctrl+Shift+= toggles superscript on the selected characters; Ctrl+= toggles subscript. These shortcuts match the equivalents in Word and PowerPoint, so the same keystrokes work consistently across the Office suite. The shortcuts are not available in older Excel versions like 2016 or 2019, so users still on those versions need to use the Format Cells dialog or the Quick Access Toolbar workaround.
The Quick Access Toolbar workaround turns the Format Cells dialog method into a one-click operation. Right-click the Quick Access Toolbar at the top of the Excel window and choose Customize Quick Access Toolbar. In the dialog, switch the Choose commands from dropdown to All Commands, scroll to find Superscript and Subscript, add both to the toolbar, and click OK.
Two new buttons appear at the top of Excel that toggle the format on selected characters with a single click. This is the workflow most experienced Excel users adopt because it works in every version of Excel and beats the dialog every time.
The Quick Access Toolbar approach has another advantage worth noting. Custom Quick Access Toolbar layouts can be exported and imported, which means a power user can set up the perfect Excel toolbar once and copy it to other computers, other users or fresh installs in seconds. The export file is small and can be shared by email or stored in a personal config repository. Shifting standard formatting commands like Superscript and Subscript onto the Quick Access Toolbar across an entire team's machines harmonises the workflow.
1. Click the cell containing the text.
2. Press F2 to enter edit mode or click into the formula bar.
3. Highlight just the characters you want to format.
4. Press Ctrl+1 to open Format Cells.
5. Click the Font tab.
6. Check the Superscript or Subscript box.
7. Click OK.
1. Click the cell and press F2.
2. Highlight the target characters.
3. Press Ctrl+Shift+= for superscript or Ctrl+= for subscript.
4. Press Enter to commit. Toggle the same shortcut to remove the formatting.
1. Right-click the Quick Access Toolbar.
2. Choose Customize Quick Access Toolbar.
3. Set Choose commands from to All Commands.
4. Scroll to Superscript and Subscript, add both.
5. Click OK. Two buttons appear at the top of Excel for one-click access.
1. Locate the Unicode character you need (¹²³⁰⁻⁹ for superscripts, ₀₋₉ for subscripts).
2. Copy from a reference list or type from a system character map.
3. Paste directly into the Excel cell.
4. The character is permanent and survives copy-paste between cells, sheets and applications.
1. Identify the Unicode code point for your character (178 for ², 179 for ³, 8304-8313 for ⁰⁻⁹).
2. Use =UNICHAR(178) inside a formula or concatenation.
3. Combine with text using ampersand: ="x"&UNICHAR(178) returns x².
4. Useful for dynamic outputs where the superscript value comes from another formula.
1. Click into the cell and press F2.
2. Position the cursor where you want the symbol.
3. Insert tab → Symbol on the ribbon.
4. Search or scroll to find the superscript character.
5. Click Insert and Close. The character is now in the cell.
The biggest weakness of the standard superscript formatting in Excel is that it is purely visual. The underlying text remains the same characters; only the rendering changes. That means the formatting does not survive being passed through formulas, does not always copy correctly into other applications, and cannot be applied to numbers used in calculations. The Unicode character approach solves these problems by using actual superscript and subscript characters from the Unicode standard rather than visually formatting normal characters to look elevated.
The Unicode character set includes superscript digits ¹²³⁰⁻⁹, superscript letters and symbols, and subscript digits ₀₋₉. These are real distinct characters that look like superscripts everywhere they appear — in Excel, Word, web browsers, email and any other Unicode-aware application. They survive copy and paste flawlessly.
They can be used inside formulas, as part of concatenated strings, and as cell values that get sorted and filtered like any other text. The trade-off is that not every character has a Unicode superscript form. Standard digits and a few symbols are available, but unusual letters or formulas may not have equivalents and you fall back to formatting the rendering instead.
Reference tables of Unicode superscript and subscript characters are easy to find online and are worth bookmarking once. The most useful page covers digit superscripts and subscripts, mathematical operators, and the small set of letters available as superscripts. Save a small workbook locally with the characters in named cells so they can be copied quickly during real work. Once you have done this once, you never have to look up the characters again — they are a few clicks away in your reference workbook.
The UNICHAR function takes a Unicode code point as input and returns the corresponding character. Combined with concatenation, it lets you build dynamic strings that include superscripts based on values from other cells or formulas. The most common code points are 178 for ², 179 for ³, and 8304 through 8313 for the digits ⁰ through ⁹. Subscript digits run from 8320 to 8329. Other useful superscript code points include 8314 (⁺) and 8315 (⁻).
A formula like ="Area: " & B2 & " m" & UNICHAR(178) produces "Area: 12 m²" if B2 holds 12. The output is a string that contains a real Unicode superscript character. The cell remains a formula and updates automatically when B2 changes. This pattern is particularly useful in dashboard labels, scientific reports and any output where the units involve squared or cubed values. UNICHAR also pairs cleanly with TEXT for combining formatted numbers with superscript units in the same string.
UNICHAR's counterpart UNICODE returns the code point of the first character in a string. =UNICODE("²") returns 178. This is occasionally useful for verifying that text really contains a Unicode superscript rather than a visually-formatted ordinary digit. The two functions together let you write small testing formulas that confirm the character composition of a cell, which is helpful when troubleshooting unexpected sort or search behaviour involving superscript characters.
Superscript in Excel shows up most often in scientific and engineering workbooks. Chemical formulas like H₂O, CO₂, NaCl₂ and HSO₄⁻ benefit from genuine subscript and superscript rendering. Mathematical expressions like x², 10⁻⁶, mc² and a²+b²=c² become much more readable with proper superscripts. Engineering units such as m², m³, ft³, kg/m³ and W/m² fit naturally with superscript exponents. Footnote markers — small numerals next to a column header that point to a footnote at the bottom of the report — also use superscript formatting routinely.
Outside of scientific contexts, superscript shows up in legal documents (1ˢᵗ, 2ⁿᵈ, 3ʳᵈ ordinals), trademark and registered marks (™, ®), and footnote-style citations in business reports. Excel's formatting lets you produce these clean visual outputs without resorting to text boxes or other workarounds that complicate the workbook structure. The result is a more professional-looking deliverable, particularly for printed reports and PDF exports where the visual layout matters as much as the underlying calculations.
Genealogy and historical records also use superscripts heavily for ordinal indicators, abbreviations and footnotes. Family tree spreadsheets often include footnote markers next to names referencing source documents or birth records. Properly formatted superscripts make these references readable without breaking the layout. The same applies to legal billing spreadsheets where footnote markers point to engagement letter clauses or fee schedules attached as separate appendices.
Several limitations of Excel's superscript handling regularly trip up users. The first is that the format only persists within an individual cell. If you copy the cell and paste-special as values to another location, the visual formatting transfers but the underlying text is the same characters that originally showed as superscripts. Pasting into a formula bar, email body or another application that does not respect Excel's character-level formatting flattens the text back to ordinary baseline characters. This is the single biggest reason advanced users prefer Unicode characters for any data that may travel.
The second limitation is that formulas referencing a cell with superscript-formatted text often discard the formatting. A formula like =A1 returns the text content of A1 without the visual superscript. The third limitation is that filters and sorting treat superscript-formatted text as identical to non-formatted text in the same characters. "H2O" with a superscript 2 sorts the same as plain "H2O". Combine these limitations with the inability to apply the format to numbers used in math and the result is that Excel's built-in superscript is best treated as a final-display feature rather than a data-layer construct.
Some workflows successfully avoid the limitations entirely by treating Excel cells as pure data and producing the visual output through a connected reporting tool. Power BI, Tableau and Google Looker Studio have richer text formatting options than Excel cells and accept superscript-formatted strings without difficulty. When the spreadsheet is the source of truth and another tool generates the report, keeping data clean in Excel and applying formatting in the visualisation layer is often the cleaner approach.
Word has a dedicated X² and X₂ button on the Home tab for one-click superscript and subscript. Same Ctrl+Shift+= and Ctrl+= shortcuts as Excel 365. The format applies to selected characters and stays with the text on copy-paste within Word.
PowerPoint also offers ribbon buttons for superscript and subscript on the Home tab. Behaviour matches Word closely. PowerPoint text boxes preserve the formatting cleanly through animation and save cycles.
Excel does not include superscript or subscript on the default ribbon. The Format Cells dialog or the Quick Access Toolbar workaround are required. Many users do not realise Excel can do superscript at all because the path is hidden.
Excel for the Web does not support the Format Cells superscript option. Unicode characters and UNICHAR formulas are the only path. This is one of the larger gaps between Excel desktop and Excel for the Web.
Copying superscript text from Word into Excel preserves the formatting because both applications use the same character-level styling. Copying from Excel out to plain text destinations like email body or Slack typically loses the visual formatting unless Unicode characters were used.
Save As PDF from Excel preserves the superscript and subscript visual formatting in the resulting PDF. Print preview also shows the formatting correctly. The PDF treats the formatted characters as discrete glyphs, not as actual Unicode superscript code points.
The most common superscript problem is that the format does not appear after the dialog is closed. Almost always this means the user selected the entire cell rather than the specific characters before opening Format Cells. The fix is to enter edit mode with F2, highlight only the characters you want elevated, and reopen the dialog. The same issue affects the Office 365 shortcut — selecting the cell instead of characters means the shortcut has nothing to apply the format to.
Another frequent issue is the format disappearing after the cell is referenced by a formula. Formulas pull the text content of the cell, not the rendering, so the superscript appearance is lost. The workaround is to use Unicode characters in the source cell so that the formula carries actual superscript characters rather than visually-formatted ordinary characters. A third issue is the format vanishing when the workbook is opened in Excel for the Web — desktop-only formatting features generally do not survive in the web client. Switching to Unicode-based superscripts solves this case as well.
One subtle issue worth knowing is that the Office 365 superscript shortcut Ctrl+Shift+= conflicts with the equivalent shortcut in some non-English keyboard layouts. Users on French AZERTY or German QWERTZ keyboards sometimes find that the shortcut produces unexpected characters instead of toggling superscript. The fix is either to switch to the international US layout for the duration of the formatting work or to fall back on the Format Cells dialog. The Quick Access Toolbar workaround sidesteps this issue entirely because it does not depend on keyboard layout.
The deeper lesson from working with superscript in Excel is that visual formatting and data structure are best kept in separate layers when the workbook will be used for analysis. Whenever a formatting feature has consequences for sorting, filtering or formula behaviour, it pays to think about whether the right home for the styling is in the data layer or in a separate display layer. The same principle applies to colour-coded cells, conditional formatting tied to data values, and merged cells used for visual layout. Each of these is a tool worth using thoughtfully rather than reaching for by default.
Used carefully, superscript formatting adds polish to deliverables that print and share well; used carelessly, it leaks into data and creates problems later.