How to Apply Superscript and Subscript in Microsoft Excel

Unlike Microsoft Word, which includes prominent one-click Superscript and Subscript icons on the standard Home ribbon, Microsoft Excel omits these tools from its default interface. For spreadsheet users who frequently compile engineering reports, scientific datasets, mathematical exponents (such as x² or 10³), chemical formulas (such as H₂O or CO₂), and trademark notices (® or ™), formatting baseline-offset text can initially appear challenging.

Fortunately, Microsoft Excel provides several flexible methods to apply superscript and subscript formatting. Whether you prefer using keyboard shortcuts, customising your Quick Access Toolbar, typing direct Unicode character codes, or combining text formulas, this guide covers every technique step by step.

Method 1: Apply Superscript or Subscript Using the Format Cells Dialogue

The standard way to offset text in Excel is through the Font tab inside the Format Cells dialogue box. This method allows you to format individual characters within a cell while leaving the rest of the text unchanged.

1. Click the cell containing the text you wish to format, or press F2 (or double-click the cell) to enter cell edit mode.
2. Highlight only the specific character or characters you want to make superscript or subscript (for instance, the number 2 in CO2). You can also highlight characters directly within the Formula Bar at the top of the worksheet.
3. Right-click the highlighted character and select Format Cells from the context menu, or press the keyboard shortcut Ctrl + 1 on Windows (Cmd + 1 on Mac).
4. In the Format Cells window, look under the Effects section in the lower-left area.
5. Check the box next to Superscript to raise the text above the baseline, or check Subscript to lower the text below the baseline.
6. Click OK and press Enter to commit your cell changes.

The selected character will now display in reduced font size at the appropriate vertical elevation.

Fast Keyboard Shortcuts for Format Cells

You can execute the Format Cells dialogue and apply the effect without touching your mouse by memorising these key sequences after highlighting your text:

• Superscript Shortcut: Press Ctrl + 1, then press Alt + E, followed by Enter.
• Subscript Shortcut: Press Ctrl + 1, then press Alt + B, followed by Enter.

Method 2: Add Superscript and Subscript to the Quick Access Toolbar

If you regularly format scientific notation or equations, adding permanent one-click buttons to your Excel Quick Access Toolbar (QAT) saves substantial time:

1. Click the downward-pointing arrow at the far end of the Quick Access Toolbar (located at the top of the Excel window or just below the ribbon).
2. Select More Commands… from the drop-down list to open Excel Options.
3. Under the Choose commands from drop-down menu, select Commands Not in the Ribbon.
4. Scroll down alphabetically to locate Subscript and Superscript.
5. Click Superscript, then click the Add >> button in the centre.
6. Click Subscript, then click Add >>.
7. Click OK in the bottom-right corner to save your changes.

Both icons will now reside permanently on your Quick Access Toolbar. When editing a cell, simply highlight any character and click the toolbar icon for instant formatting.

Method 3: Enter Superscript Numbers and Symbols Using Alt Codes

For common numerical exponents and symbols, typing direct numeric keypad Alt codes inserts native Unicode superscript characters immediately without modifying cell font formatting:

• Superscript 1 (¹): Hold Alt and type 0185 on the numeric keypad.
• Superscript 2 (²): Hold Alt and type 0178 on the numeric keypad.
• Superscript 3 (³): Hold Alt and type 0179 on the numeric keypad.
• Degree Symbol (°): Hold Alt and type 0176 on the numeric keypad.
• Registered Trademark (®): Hold Alt and type 0174 on the numeric keypad.
• Trademark Symbol (™): Hold Alt and type 0153 on the numeric keypad.

Method 4: Generate Superscript in Formulas Using UNICHAR

When generating labels, header strings, or dynamic concatenated text using formulas, Excel font formatting cannot be applied to individual pieces of formula output. Instead, use the UNICHAR function to embed Unicode characters dynamically:

Squared and Cubed Exponents

To produce dynamic area or volume labels such as 150 m² or 75 m³:

=A2 & " m" & UNICHAR(178)
=B2 & " m" & UNICHAR(179)

Superscript Digits 0 through 9

Unicode provides characters for all ten digits in superscript:

• UNICHAR(8304) produces ⁰
• UNICHAR(185) produces ¹
• UNICHAR(178) produces ²
• UNICHAR(179) produces ³
• UNICHAR(8308) through UNICHAR(8313) produce ⁴ through ⁹

Understanding the Calculation Limitation with Numbers

A crucial technical distinction to remember when working in Microsoft Excel involves numeric calculations:

• Text Conversion: Applying Format Cells superscript to individual digits inside a cell forces Excel to convert the entire entry into a Text string. The cell can no longer be evaluated directly using mathematical operations like =SUM() or =AVERAGE().
• Recommended Workflow: Always keep your raw numeric calculation data in dedicated columns without font formatting. Use adjacent presentation columns for displaying formatted units, scientific notation, and superscript labels intended for visual reporting and printing.

Mastering these superscript and subscript workflows ensures your Excel spreadsheets display clear, professional technical notation while maintaining structural calculation integrity.