How to Do Superscript in Excel — Complete Guide (2026)

You've typed a formula into Excel, and now you want the 2 in x² to sit above the baseline — or you need a footnote number¹ tucked neatly after a cell's text. That's superscript, and it's one of those formatting tricks Excel handles differently than Word. The good news: it works. The catch: it only works on text, not on values you're calculating.

Superscript raises selected characters above the normal text line. You'll use it for mathematical notation (x², n³), chemical compounds written as text (like labeling a column "CO²" for display purposes), trademark symbols (™), ordinal numbers (1st, 2nd), and footnote references. If you've ever stared at a cell trying to figure out how to type superscript in Excel, you're not alone — Microsoft buried the option a few clicks deep.

There's a common misconception worth clearing up right away. Excel doesn't have a single keyboard shortcut that toggles superscript the way Word does with Ctrl+Shift+=. Instead, you'll use the Format Cells dialog (Ctrl+1), add a button to the Quick Access Toolbar, or use the UNICHAR function for static symbols like ² and ³. Each method has its place — and we'll cover all of them.

One hard rule: superscript formatting only applies to text cells. If a cell contains a formula or number that Excel treats as a value, you can't apply superscript to part of it. You can format the entire cell as text first, but then it's no longer usable in calculations. This is the core limitation, and it trips up a lot of people who want something like a cell showing x² that also computes. That's not how Excel works — for that, you'd use =A1^2 for the calculation and a separate display cell with formatted text.

It's also worth understanding where superscript fits in your workflow. If you're building a report that mixes calculations and labels, superscript is a label tool. Use it in header rows, unit labels, footnote references, and text annotations. Keep your formulas in separate cells. That separation — calculations here, formatting there — is the Excel way, and superscript is no exception.

If you want to brush up on the full range of Excel formatting techniques — not just superscript — the excel cheat sheet covers shortcuts, formulas, and formatting tricks in one place. It's worth bookmarking alongside this guide.

This guide walks through every method: Format Cells dialog, the ribbon keyboard path, Quick Access Toolbar setup, the UNICHAR workaround, subscript, and what to do when you're hitting the formula limitation. By the end, you'll know exactly which method fits your situation — and why the shortcut you expected to find doesn't exist. Let's get into it.

Method 1: Format Cells Dialog (Ctrl+1)

This is the method you'll use most often. It's a few steps, but once you know the path it takes under ten seconds. Here's exactly how to do it.

Step 1 — Enter your text. Click the cell where you want the superscript text. Type the full text first — for example, x2 if you want x². Don't format as you go; finish the whole cell content first. It's much easier to select specific characters after the text is complete than to try to apply formatting mid-typing.

Step 2 — Click into the formula bar. This is critical — and it's the step most beginners miss. You can't select individual characters by clicking on the cell itself in normal view; you need to be inside the formula bar at the top of the screen. Click once on the formula bar to place your cursor there. The formula bar is the long white input bar just above the spreadsheet grid, to the right of the Name Box.

Step 3 — Select only the characters to superscript. Using your mouse or keyboard, highlight just the characters you want raised — in our x2 example, select only the 2. You can click and drag, or use Shift+Arrow keys. If you select the whole cell content, Excel will apply superscript to everything, which isn't what you want for mixed text.

Step 4 — Open Format Cells. Press Ctrl+1. The Format Cells dialog opens. You'll land on whatever tab was last used, so click the Font tab if it's not already selected. The Font tab is the second tab in the dialog.

Step 5 — Check Superscript. Under the Effects section, you'll see checkboxes for Strikethrough, Superscript, and Subscript. Check Superscript. A preview at the bottom shows your text with the selected characters raised.

Step 6 — Click OK. The selected characters now appear raised above the baseline. Press Escape to deselect and see the final result.

The ribbon keyboard shortcut path — pressing Alt, then H, then navigating through the ribbon — eventually gets to Font options, but it's slower than Ctrl+1 and not worth memorizing unless you're avoiding the mouse entirely. The path involves multiple key presses and lands you in the font size or font name field, not directly on the Superscript checkbox. Most Excel power users stick with Ctrl+1 because it's direct.

If you run into related formatting challenges — like wanting to style multiple rows quickly or applying superscript across a range — the guide on adding superscript in Excel covers edge cases around applying superscript to multiple cells in a batch and handling merged cells.

One thing to watch: if the cell is currently in edit mode (cursor blinking inside the cell body rather than in the formula bar), Ctrl+1 might not open Format Cells in some Excel versions. Click directly on the formula bar text first. You can tell you're in the formula bar because the cursor appears in the bar, not in the cell grid itself.

Also worth noting: Format Cells superscript works differently than font size reduction. Some people try to fake superscript by making a character smaller — but that doesn't raise it above the baseline. Real superscript both raises the character and reduces its size. Excel's native Format Cells option does both automatically.

Setting Up the Quick Access Toolbar for Faster Superscript

If you find yourself adding superscript regularly — maybe you're building a worksheet full of chemical formulas, or you're formatting a table with footnote references — the Quick Access Toolbar method saves real time. Instead of Ctrl+1 → Font tab → checkbox every time, you get a one-click button right at the top of your Excel window. For some people, this becomes the default method after the initial setup.

Here's how to add it. Go to File → Options → Quick Access Toolbar. In the "Choose commands from" dropdown at the top, select All Commands — superscript isn't in the popular commands list by default, so you need to expand the search. Scroll down through the alphabetical list until you find Superscript. Click it, then click the Add button in the middle to move it to the right-hand panel (the QAT). Click OK.

You'll now see a small superscript button in the Quick Access Toolbar — it typically shows as an "x²" style icon or a small raised character indicator. To use it: click your cell, click in the formula bar, select the specific characters you want raised, and click the QAT button. Done in one click after the selection. You can also add a Subscript button the same way — just search for Subscript in All Commands and add it right below the Superscript entry.

The QAT button does the same thing as Ctrl+1 → Font → Superscript — it's just faster once it's set up. The downside is it's per-machine and per-user profile: if you're working on a shared computer or opening Excel on a different device, you'd need to set it up again. The Ctrl+1 method works everywhere without any setup, which is why it's the safer default for most people.

Speaking of keyboard-based operations, if you handle a lot of row management, the guide on keyboard shortcut to delete row in excel is worth a read — same idea of cutting down repetitive mouse-clicks with faster keyboard paths. Excel rewards users who invest a few minutes learning keyboard patterns like this.

One more QAT tip: you can assign a keyboard shortcut to the QAT button by position. If your Superscript button is the first item in the QAT, pressing Alt+1 triggers it. If it's the fourth item, Alt+4. This effectively gives you a keyboard shortcut for superscript — just one that's based on button order, not a traditional key combination. If you move the buttons around later, the Alt+number assignments shift too, so keep the order consistent once you've memorized it.

For Excel 365 users: Microsoft occasionally updates the ribbon layout or QAT options across versions, but the Superscript option in All Commands has been there for many versions. If you can't find it, try searching for "super" in the search box at the top of the All Commands list in newer Excel versions — it filters the list as you type.

When to Use UNICHAR vs Format Cells

The UNICHAR approach shines when you need the superscript character to be part of the actual string — think a formula like ="Speed: "&A1&" m"&UNICHAR(178)&"/s" that builds a display label dynamically. The character becomes part of the cell value, so it survives copy-paste as plain text, exports cleanly to CSV (as the actual ² Unicode character), and doesn't depend on the font rendering of a formatting property.

Format Cells superscript is better when you're formatting existing content you've typed — a heading, a label, a note — and you just want specific characters to look raised. It's more flexible (works on any character, any position in the text) but it's a display-layer property, not part of the string value itself. If you read the cell value programmatically in a VBA macro using .Value, you'll get the plain unformatted string. The superscript property lives in .Characters(n).Font.Superscript — character-level formatting, separate from the value.

The rule of thumb: use UNICHAR when the symbol needs to travel with the value (formulas, exports, programmatic reads). Use Format Cells when it's a visual formatting decision for a static label you're maintaining manually.

Superscript in Formulas: The Limitation and Workarounds

Here's where a lot of users hit a wall. You want a cell to show x² and also compute the square of whatever x is. Excel won't do both in the same cell. It's a fundamental distinction between value cells and text cells — and understanding it saves a lot of frustration.

When Excel sees a number or a formula result, it stores and displays a value. You can't apply character-level formatting to part of a formula result — there's no individual character to target, only a rendered number. The Superscript checkbox in Format Cells is literally grayed out (disabled) when the selected cell contains a formula. Excel is telling you: this isn't a text cell, there's nothing to format at the character level.

The standard workaround is to use two cells: one for the calculation (=A1^2), one for the display label formatted as text ("x²"). This is how most professional Excel workbooks handle it — a results table with numeric values in one column, and a formatted text label in an adjacent column or header row. You might also see this in unit labels: a column of numbers calculated in formulas, with a header cell formatted as "m²" or "kg/m³" using superscript on the non-numeric characters.

Another approach: the UNICHAR function lets you build strings that look like they contain superscript. ="x"&UNICHAR(178) produces x² as an actual character string. You can then use this in a text display cell alongside a separate numeric result cell. It's not the same as applying superscript formatting — it's the actual Unicode superscript-2 character (U+00B2) — but visually it achieves the same appearance and it works inside formula concatenation without the text-only restriction.

For complex calculations that need formatted output — engineering reports, financial models with footnotes, scientific data tables — many Excel users build a structured table where calculation cells are purely numeric, and label cells are purely text. The countifs excel function is a good example of where you'd have calculated values in one column (formula cells) and clearly labeled, formatted text headers in another. Superscript footnote markers work perfectly in those label cells because they're text-only, separate from any calculation logic.

There's also a VBA approach for power users: you can write a macro that iterates through cells and applies .Characters(start, length).Font.Superscript = True to specific character ranges. This is useful if you're batch-formatting a large table. But for most users, the manual Format Cells method or the UNICHAR approach covers every real-world scenario without needing code.

Copying Superscript from Word or Google Docs

If you've already formatted text as superscript in Word, you can often paste it into Excel and keep the formatting intact. The key: paste using Paste Special → Keep Source Formatting — or try a plain Ctrl+V first, which sometimes works. Excel generally preserves character-level formatting on paste from Word, including superscript and subscript properties, because both apps use the same underlying character formatting model.

Google Docs is less reliable. The superscript might paste as plain text without the formatting. If it does, just re-apply it with Ctrl+1 after pasting — it takes a few seconds once you know the dialog path, and you're back to where you wanted to be.

One edge case: if you're pasting into a cell that's currently formatted as a number format (like Currency or Accounting), Excel may strip character-level formatting on paste. Change the cell format to Text first (Home → Number Format dropdown → Text), then paste, then apply superscript to the characters you need raised.

Indentation and Superscript Together

Some users combine superscript with cell indentation for cleaner-looking tables — especially when building formatted reports with hierarchical data. Sub-entries can have both indented text and superscript footnote markers for source references. If you're working with that kind of layout, the guide on how to indent in excel shows the indentation options in detail. Indentation and superscript are both character/cell formatting operations, and they stack cleanly on the same cell.

Finally, if you're managing a large dataset and need to format cells in a specific column consistently — not just superscript, but other text formatting too — combining the name-splitting technique from separate first and last name in excel with text formatting afterward is a common workflow for cleaning imported data before labeling and presenting it.