How to Write Subscript and Superscript in Excel

Subscript and superscript formatting might seem like minor details, but they matter enormously in technical documents, chemical formulas, mathematical notation, and academic reports. Excel handles these differently than Word — and understanding why shapes how you apply them correctly.

What Subscript and Superscript Actually Do in Excel

Subscript lowers text slightly below the baseline — think of H₂O or CO₂. Superscript raises text above the baseline — like E=mc² or footnote markers.

In Excel, these are purely visual formatting options. They affect how a character looks inside a cell, but they don't change the underlying value or how Excel performs calculations. This is a critical distinction: if you format a number as superscript, Excel still reads it as a plain number. Subscript and superscript are cosmetic, not mathematical.

This is different from how Word handles them, and it's the source of a lot of confusion for users moving between Office applications.

The Standard Method: Format Cells Dialog

The most reliable way to apply subscript or superscript in Excel involves the Format Cells dialog. Here's how it works:

1. Click into the cell containing your text
2. Double-click the cell (or press F2) to enter edit mode
3. Highlight only the specific characters you want to format — not the entire cell
4. Right-click the selected characters and choose Format Cells
5. Under the Font tab, check either Subscript or Superscript in the Effects section
6. Click OK

The key step most people miss: you must select individual characters, not the whole cell. If you select the entire cell without entering edit mode, the Format Cells dialog will apply formatting to everything — which can look odd and doesn't give you the fine-grained control you need.

⌨️ Keyboard shortcut path: Select your characters, then use Ctrl + 1 to open Format Cells directly, rather than right-clicking.

Using Keyboard Shortcuts (With a Catch)

Excel doesn't assign default keyboard shortcuts to subscript and superscript the way Word does (Ctrl + = and Ctrl + Shift + +). However, you can create custom shortcuts through Excel's Quick Access Toolbar or by recording macros.

To add subscript/superscript buttons to the Quick Access Toolbar:

1. Click the dropdown arrow on the Quick Access Toolbar
2. Select More Commands
3. Search for "Subscript" or "Superscript" in the command list
4. Add them to your toolbar

Once added, you can trigger them with Alt + [number] based on their position in the toolbar. This is a significant workflow improvement if you format scientific or chemical data regularly.

How Formulas and Functions Factor In

Excel's subscript/superscript formatting does not work inside formulas — it only applies to text content in cells. If you're trying to display something like x² as part of a calculated result, you'll run into a wall.

For mathematical expressions that need to render dynamically, the workarounds include:

• Text concatenation combined with manual character formatting (labor-intensive)
• Unicode characters — many subscript and superscript characters exist in Unicode (e.g., ² is Unicode U+00B2) and can be pasted directly into cells
• Equation Editor via Insert > Equation, though this creates a floating object rather than cell-bound content

Unicode Characters as an Alternative

For common scientific and mathematical notation, Unicode subscript and superscript characters are often the cleanest solution — especially when you need the formatted character to travel reliably across different systems or be read by other applications.

Common examples:

• Superscript numbers: ¹ ² ³ ⁴ ⁵ (U+00B9, U+00B2, U+00B3, U+2074–U+2079)
• Subscript numbers: ₀ ₁ ₂ ₃ (U+2080–U+2089)
• Superscript letters for units: ° (degree symbol, widely used as a near-substitute)

You can insert these through Insert > Symbol, or copy them directly from a Unicode reference. The advantage: these characters aren't "formatted" — they are those characters, so they stay consistent when exported to PDF, copied into emails, or opened in other spreadsheet applications like Google Sheets.

The tradeoff is that Unicode subscript/superscript characters have a limited range. Full alphabetic subscript coverage isn't available for every letter, which matters for chemical notation beyond basic formulas.

🔬 Where Version and Platform Differences Show Up

The Format Cells method works consistently across Excel for Windows, Excel for Mac, and Microsoft 365 desktop versions. The behavior is stable and hasn't changed meaningfully across recent versions.

Excel for the web (browser-based) has historically had limited font formatting options — subscript and superscript may not be accessible through the same dialog, depending on the current version of the web app. Microsoft updates this periodically, so the web version's capabilities are worth checking directly if that's your primary environment.

Google Sheets handles this differently entirely — it uses Format > Text > Superscript/Subscript from the menu, with no Format Cells dialog equivalent. If your workflow moves between Excel and Sheets, the two approaches don't map neatly onto each other.

What Determines the Right Method for You

The method that makes most sense depends on factors specific to your situation: how frequently you need this formatting, whether your data is static or dynamic, which version of Excel you're running, and whether your files need to stay compatible with non-Excel environments. A chemist documenting compound names in a static reference sheet has entirely different needs than someone building a live financial model with annotated labels — and the same formatting tool can behave very differently depending on that context.