Knowing how to superscript in Excel matters more than most spreadsheet users expect. Whether you are typing footnote markers, exponents like cm², ordinal numbers (1st, 2nd, 3rd), or chemical formulas, raised characters tell the reader that a value is meta-information, not part of the main number. Excel does not advertise this feature on its ribbon by default, so plenty of accountants, students, and analysts settle for plain text that quietly muddies their reports.
You have several routes. The classic Format Cells dialog still works in every desktop version since 2007. A faster keyboard shortcut (Ctrl + 1, then Alt + E) handles repeat jobs. Power users add Superscript and Subscript buttons to the Quick Access Toolbar so a single click flips selected characters. And in Excel 365, the Home tab now hides a Superscript control inside the Font expander—handy once you spot it.
This guide walks through every method, the gotchas around numbers versus text, why superscripts vanish in formulas, and the cleaner workarounds (UNICHAR, custom number formats, and the equation editor) that fix those edge cases. Treat it as a reference: bookmark, skim, and jump straight to the technique that matches your spreadsheet task.
Superscript is a character that sits half a line above the normal text baseline and appears in a smaller font size. It is purely visual—a cell containing 10² still stores the literal characters “102,” not the value 100. That distinction matters because Excel evaluates the underlying string, not the formatting, when you run formulas. If you SUM a column that displays X², X³, X&sup4;, Excel sees them as text and refuses to add. Keep this in mind: superscript is for presentation, never calculation.
Microsoft inherited the feature from Word, but Excel implements it differently. In Word you can superscript an entire paragraph; in Excel, the formatting attaches to individual characters inside a cell’s text. Numeric cells (cells that contain a real number, not text) cannot be partially formatted at all, which is why most tutorials tell you to convert the cell to text first. Once you understand that limitation, every workaround in this guide makes sense.
Select characters, press Ctrl + 1, tick the Superscript checkbox. Works in every desktop version since Excel 2007.
Add the Superscript command once, then click the icon to format selected text in a single keystroke.
Excel 365 hides a Superscript button inside the Font group dropdown—click the small arrow to reveal it.
Use UNICHAR(178) for ² or UNICHAR(179) for ³ to insert true superscript digits inside formulas.
Apply a format string like 0"²" to numeric cells so the superscript survives calculation.
This is the technique every Excel trainer teaches first because it works on every Windows and Mac version. Start by double-clicking the cell you want to edit, or press F2 to enter edit mode. Select only the characters you want raised—not the whole cell, just the few digits or letters. Then press Ctrl + 1 (the standard shortcut for Format Cells). The Font tab opens, and near the bottom you will see three Effects checkboxes: Strikethrough, Superscript, Subscript. Tick Superscript and click OK.
The selected characters shrink and shift upward immediately. The rest of the cell text stays at the normal baseline. You can press Enter to commit, or keep typing if you want more content. The formatting persists if you copy the cell elsewhere, and it survives saving the file as .xlsx. One caution: if you save as .csv, all formatting strips out because CSV stores plain text only.
On a Mac, the equivalent shortcut is Cmd + 1, and the dialog looks slightly different but the Superscript checkbox is in the same place. Keyboard navigators can press Alt + E after Ctrl + 1 to jump straight to the Superscript checkbox without using the mouse, then Enter to apply.
Many people get stuck because clicking once on a cell selects the whole cell, not the characters inside. Press F2 first to enter edit mode, then drag across the digits you want to raise. Without this step, Ctrl + 1 will format the entire cell’s appearance, which is not what you want for superscript.
If you superscript more than once a week, the Format Cells route gets tedious. Excel lets you pin a Superscript button to the Quick Access Toolbar (QAT), the tiny strip above or below the ribbon. Once added, formatting becomes a single click after selecting text. Click the down arrow at the right edge of the QAT, choose More Commands, then in the “Choose commands from” dropdown select All Commands. Scroll until you find Superscript, click Add, and OK out.
The icon now lives on your QAT permanently. Better yet, the QAT supports keyboard shortcuts based on position: the first button is Alt + 1, the second Alt + 2, and so on. If Superscript sits in position 4, pressing Alt + 4 toggles superscript on the selected characters with zero mouse work. Power users add Subscript too, since the same dialog buries both.
This shortcut is the single biggest time-saver for anyone preparing scientific reports, footnotes, or invoices with VAT markers. It also syncs across machines if you save your QAT customization to a file via Excel Options → Quick Access Toolbar → Import/Export. Excellence in spreadsheet design often hinges on small workflow tweaks like this; for similar productivity boosts, see our guide on applying superscript in Excel.
The newest builds added a direct Superscript button. Open the Home tab, click the small arrow at the bottom-right of the Font group to expand the dialog launcher, and the Superscript and Subscript icons appear alongside Bold and Italic. You can also right-click the icon and choose “Add to Quick Access Toolbar” for permanent access.
Same Format Cells dialog as older versions. The Home tab does not show a dedicated button, so QAT customization is the fastest route. All keyboard shortcuts (Ctrl + 1, F2, Alt + E) work identically.
Identical behavior to 2019. The Ribbon layout is slightly different but the Format Cells dialog is unchanged. Mac 2016 users should use Cmd + 1 instead of Ctrl + 1.
Format Cells is the only built-in method. QAT customization is available and works the same way. No Home tab shortcut exists in these versions.
The browser version has no superscript option in the cell formatting dialog. Workaround: paste pre-formatted superscript characters from another source, or use UNICHAR(178) and UNICHAR(179) for ² and ³.
The methods above format text characters visually but break in formulas. If you need superscripts that survive concatenation, lookups, or calculation chains, switch to Unicode superscript characters. Excel’s UNICHAR function returns the character at a given Unicode code point. The most common superscript digits live at these codes: 0=8304, 1=185, 2=178, 3=179, 4=8308, 5=8309, 6=8310, 7=8311, 8=8312, 9=8313. Negative sign superscript is at 8315.
For example, the formula =“cm”&UNICHAR(178) returns cm² as a real text string that you can paste anywhere, even into a chart axis label or PowerPoint slide. The advantage: these are not formatted characters, they are actual Unicode glyphs, so they travel with your data through CSV exports, REST APIs, and email. The trade-off: you only get digits and a handful of letters in superscript form; arbitrary text cannot be raised this way.
For chemistry users, subscript digits are at codes 8320 through 8329. Combine UNICHAR calls in CONCATENATE to build formulas like H₂O for water or CO₂ for carbon dioxide. Pair this with named ranges to make a reusable subscript builder, and your titration spreadsheets gain real scientific notation without any character-level formatting.
The biggest frustration with character-level superscript is that it does not work on numeric cells. Type 25 into a cell, try to highlight just the 2, and Excel will not let you partially format a number. The fix is a custom number format that bolts a superscript-looking suffix onto the displayed value without changing the underlying number. Right-click the cell, choose Format Cells, pick Custom, and enter a format like 0"²" to display the number followed by a superscript 2.
The clever part: the cell still contains a real number, so SUM, AVERAGE, and any other math function continues to work normally. You can apply this to a whole column to label unit measurements—ft², m³, kg²—while keeping the data calculable. Combine it with conditional formatting to highlight cells over a threshold, or with data validation to enforce input ranges, and you get a clean, professional presentation layer.
One caveat: the Unicode superscript characters need to be physically present inside the format string’s quotation marks. The easiest way is to copy a ² from a web page or from another cell, then paste it into the format dialog between quotes. Once saved, the format string lives in the workbook and follows the cell wherever it is copied. Many testing workflows benefit from this approach—our Excel category overview covers the broader skill set assessed in interviews and certifications.
For research papers, statistical reports, or anything more elaborate than a single raised digit, Excel offers the Equation editor on the Insert tab. Click Insert → Equation (or Alt + N then E) and a floating math box drops onto your sheet. Inside the box, you have access to the full LaTeX-style symbol library: Greek letters, fractions, integrals, summations, and yes—true superscript and subscript through dedicated templates.
The downside is that equation objects float over the grid rather than living inside a cell. They do not auto-resize with row height, and they cannot be referenced in formulas. But for one-off labels like x² + y² = r² that need to look professional in a printed report, this is the cleanest option. Equation objects also export beautifully when the workbook is saved as PDF, which is how most published reports are distributed anyway.
You can convert handwritten math to Equation objects on touchscreens using the Ink Equation feature. Draw the expression on a tablet, Excel recognizes it, and inserts a properly typeset equation. For data analysts preparing executive dashboards, this turns a manual annotation step into a few seconds of work. Just remember that equation objects bloat file size if used heavily, so reserve them for headline metrics, not bulk labels.
If the Superscript checkbox in Format Cells is grayed out, the cell almost certainly contains a number rather than text. Excel will not partially format a numeric cell. To fix it, prefix the value with an apostrophe—type '102 instead of 102—which forces Excel to store the value as text. The apostrophe itself does not display, and you can now select the 2 and apply superscript normally. The downside is that the cell no longer participates in math, so use this only for label cells.
If your superscript looks correct on screen but prints at full size, check your printer driver. Some older drivers downsample formatting at lower quality settings. Switching to PDF export and printing from the PDF usually preserves the formatting perfectly. For dashboards distributed to clients, exporting to PDF is generally safer than relying on every recipient’s printer to render Excel cell formatting consistently.
Mac users sometimes report that the Superscript shortcut is missing on Excel 2011 and earlier. The workaround is to add the command to the toolbar via View → Customize Toolbars and Menus, then drag the Superscript command onto the toolbar. From Excel 2016 Mac onward, the standard Ctrl + 1 (or Cmd + 1) approach is fully supported. Excel for iPad and iPhone do not expose superscript formatting at all; you must format the cell on a desktop machine before opening on mobile.
Another quirky issue: when you copy a cell that contains mixed superscript and regular text and paste it into another cell using Paste Special → Values, the formatting is stripped because Values pastes only the underlying text. Use Paste Special → All or simple Ctrl + V to preserve the raised characters. When pasting into Word or Outlook, the formatting usually survives if the destination supports rich text. When pasting into Google Sheets, character-level superscripts often translate, but the safest move is to convert to UNICHAR characters before the migration so nothing depends on Excel’s proprietary formatting layer.
VBA developers sometimes need to set superscript programmatically. The relevant property is Range.Characters(start, length).Font.Superscript = True. This lets you loop through cells, find a specific substring, and raise it conditionally. It is slower than batch number formatting, but invaluable for one-off batch fixes on inherited workbooks where the formatting was applied inconsistently. Combine it with a Find loop and you can normalize hundreds of cells in seconds.
Picking the right superscript technique depends on what the cell is for. If you are labeling units in a report, custom number formats win because they preserve calculation ability. If you are writing footnote markers in commentary text, character-level formatting through Ctrl + 1 is fastest. If your spreadsheet feeds a CSV pipeline or a database, UNICHAR Unicode characters are mandatory because they survive plain-text encoding. For dense scientific notation in published reports, equation objects produce the cleanest result, even if they do bloat the file.
Once you internalize these five methods, superscript stops being a friction point. Most professional spreadsheets use a mix: number formats for the data grid, UNICHAR for any concatenated text strings, and the occasional Ctrl + 1 cell-level format for a one-off annotation. Build a small reference cell in column A of your template workbook that holds each method as a worked example, and you will never have to look up the syntax again.
Excel rewards users who learn formatting at this level of depth. Reports look more polished, data integrity is preserved through exports, and you spend less time fixing things that other people noticed. The same principle applies across the entire Microsoft Excel skills toolkit—every little visual cue you master compounds into faster, more accurate work.
One more habit worth building: document the superscript method you used directly in the workbook. A small note on a hidden Documentation sheet that says “column F uses custom number format 0'm²' to display square meters” saves your future self, and any colleague who inherits the file, from hours of detective work. Spreadsheets often outlive the people who built them, and unexplained formatting decisions are one of the most common sources of confusion during audits and handovers.
If you are training a team, demonstrate the QAT shortcut first, then the custom number format, then UNICHAR. Most people grasp the first method in seconds, the second within ten minutes, and the third only after they hit a real export problem. Layering the techniques in order of immediate utility makes the lesson stick, while presenting all five at once tends to overwhelm beginners. Cell-level formatting feels intuitive; formula-based superscripts feel powerful; the equation editor feels professional. Each has its moment.