Excel guide · 5 min read
How to superscript and subscript in Excel
=SUBSTITUTE(A2,"m2","m²").Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|---|
| 1 | Room | Length (m) | Width (m) | Area | Label | Typed | Fixed | |
| 2 | Office 1 | 4.2 | 3.5 | 14.7 | 14.7 m² | CO2 per desk (kg) | CO₂ per desk (kg) | |
| 3 | Office 2 | 3.8 | 3.1 | 11.78 | 11.8 m² | Floor area (m2) | Floor area (m²) | |
| 4 | Meeting room | 6.4 | 4.5 | 28.8 | 28.8 m² | Volume (m3) | Volume (m³) | |
| 5 | Kitchen | 3.6 | 2.4 | 8.64 | 8.6 m² | H2O usage (L) | H₂O usage (L) | |
| 6 | Store room | 2.5 | 2 | 5 | 5.0 m² | Revenue 1 | Revenue¹ | |
| 7 | Reception | 5 | 4 | 20 | 20.0 m² |
Download this sheet as an Excel practice file (.xlsx)
Superscript or subscript part of a cell
Superscript raises characters and shrinks them (the 2 in m²); subscript lowers them (the 2 in CO₂). Excel has no ribbon button for either: the options live in the Font part of Format Cells.
- Double-click the cell or press F2 so you're editing it.
- Select just the characters to change, for example the 2 at the end of m2.
- Press Ctrl+1. While you're editing, Excel opens a Format Cells box with only the Font tab.
- Under Effects, tick Superscript or Subscript.
- Click OK, then press Enter.
Is there a keyboard shortcut for superscript in Excel?
There's no single built-in key. On Windows, the fastest route is F2, select the characters, Ctrl+1, then the underlined letter in the dialog (in English Excel, Alt+E ticks Superscript and Alt+B ticks Subscript) and Enter. Ctrl+Shift+F also opens the Font tab. On a Mac, use Cmd+1 and tick the box.
Can I add Superscript buttons to the toolbar?
In current Microsoft 365 versions, File > Options > Quick Access Toolbar with Choose commands from set to All Commands lists Superscript and Subscript. Add them and they're one click away (or Alt plus their position number). If your version doesn't list them, use Ctrl+1.
Why it won't work on numbers and formulas
Partial formatting only works on text you typed. A number is one value, so Excel applies a font effect to the whole cell or not at all. Type 102 and try to raise the 2, and it doesn't stick. A formula result can't be partly formatted either; the Superscript box applies to the whole result or is ignored.
The workaround people reach for is to turn the number into text (type an apostrophe first: '102). That works for a label, but the cell is no longer a number, so SUM, sorting and charts stop seeing it. For anything you calculate with, use one of the methods below.
Use the characters ² ³ ¹ and ₂ instead
Unicode has real superscript and subscript characters: ¹ ² ³ and ₂ ₃ among them. They're ordinary characters, so they work in formulas, headers, chart titles and anywhere text goes, and they survive copying to email or a CSV. Paste them from a site or from Insert > Symbol, or on Windows type Alt+0178 for ² and Alt+0179 for ³ on the number pad.
If a column of labels was typed with plain digits, SUBSTITUTE fixes them all at once. Column H of the sample does this for m2, m3, CO2 and H2O.
Result: CO₂ per desk (kg)
CO₂ per desk (kg): the plain 2 swapped for the subscript character. The same pattern turns Floor area (m2) into Floor area (m²).
Is there a function that returns ²?
On Windows, CHAR(178) returns ², CHAR(179) returns ³ and CHAR(185) returns ¹, because CHAR uses the Windows character set. A Mac uses a different set, so CHAR(178) gives another symbol there. UNICHAR (Excel 2013 and later) takes a Unicode code number instead and works the same on both; Insert > Symbol shows each character's code.
Result: Area (m²)
Area (m²) in Windows Excel.
Do all fonts have these characters?
Common fonts such as Aptos, Calibri and Arial have ¹ ² ³. Subscript digits like ₂ are missing from some fonts and can show as boxes; check after you change the font.
Units on numbers: keep them as numbers
Column E builds labels like 14.7 m² by joining the area to text. It looks right, but every label is now text, and totals quietly break.
Result: 0
0: SUM skips text, so the six labelled areas add up to nothing. =E2+E3 gives #VALUE! instead. SUM(D2:D7) on the real numbers gives 88.92.
So how do I show m² and still add the cells up?
Put the unit in a custom number format, not in the value. Select D2:D7, press Ctrl+1, choose Custom and type 0.0" m²". The cell shows 14.7 m² but still holds 14.7. The TEXT function uses the same code, so you can check it first. See format numbers with text for more.
Result: 88.9 m²
88.9 m²: the total formatted with the unit. In the Format Cells box you type #,##0.0" m²" with single quotes; the doubled quotes are only for inside a formula.
Footnote markers and the Equation tool
For a footnote marker after a heading, such as Revenue¹ with a note under the table, typed text with partial superscript is fine, because a heading isn't calculated. If the heading is built by a formula, add ¹ as a character instead.
For real formulas with fractions, powers and Greek letters, Insert > Equation places an equation in a floating box over the sheet. It looks right on a printout but isn't a cell, so nothing can calculate with it. To calculate a power, use the ^ operator or POWER: =3^2 or =POWER(3,2).
Result: Revenue¹
Revenue¹: the footnote marker as a character, which keeps working if the heading comes from a formula.
Excel for the web, phones and Mac
Superscript and subscript have long been missing from Excel in the browser and the phone and tablet apps. If you can't find them there, open the file in the desktop app; formatting you add there is kept and displays everywhere. The Unicode characters work in every version.
On a Mac, select the characters while editing and press Cmd+1 (or Format > Cells) to reach the same Superscript and Subscript boxes.
Common mistakes
Trying to superscript part of a number
It won't stick. Use a custom format like 0.0" m²" or the ² character.
Turning areas into text labels to show the unit
SUM returns 0 on text. Keep the number and put the unit in the number format.
Selecting the whole cell before ticking Superscript
Edit the cell with F2 and select only the characters to raise.
Using CHAR(178) in a file Mac users open
CHAR depends on the system character set. Paste the ² character into the formula or use UNICHAR.
FAQ
How do I type m² in Excel?
On Windows hold Alt and type 0178 on the number pad, or type m2, select the 2 while editing and tick Superscript in Ctrl+1. For a number with a unit, use the custom format 0.0" m²".
How do I write CO2 with a small 2 in Excel?
Edit the cell, select the 2, press Ctrl+1 and tick Subscript. Or replace it with the ₂ character, for example =SUBSTITUTE(A2,"CO2","CO₂").
Why is superscript greyed out in Excel?
You're probably in Excel for the web or the mobile app, or you selected a number or formula cell. Use the desktop app and select characters in typed text while editing the cell.
Can I superscript in an Excel formula?
Not with formatting. Put the character itself in the formula, such as "m²", or use CHAR(178) in Windows Excel.
How do I remove superscript in Excel?
Edit the cell, select the raised characters, press Ctrl+1 and clear Superscript. Home > Clear > Clear Formats removes it from whole cells.
Functions used
SUBSTITUTEReplaces textCHARCharacter from its code numberSUMAdds numbersTEXTNumber to formatted text
Related guides
- How to insert the degree symbol in Excel
- How to change the default font in Excel
- How to combine text with numbers and dates in Excel
- Combine cells with a line break in Excel
- How to insert the euro symbol (€) in Excel
- Excel Tab key not working: why it happens and how to fix it
Updated