Cellwise Start free

Excel guide · 5 min read

How to superscript and subscript in Excel

Quick answerDouble-click the cell (or press F2), select only the characters you want raised or lowered, press Ctrl+1 to open Format Cells, tick Superscript or Subscript under Effects, and click OK. This works on typed text only. For numbers and formula results, use the ready-made characters ² ³ ¹ or ₂ instead, for example =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.

RowABCDEFGH
1RoomLength (m)Width (m)AreaLabelTypedFixed
2Office 14.23.514.714.7 m²CO2 per desk (kg)CO₂ per desk (kg)
3Office 23.83.111.7811.8 m²Floor area (m2)Floor area (m²)
4Meeting room6.44.528.828.8 m²Volume (m3)Volume (m³)
5Kitchen3.62.48.648.6 m²H2O usage (L)H₂O usage (L)
6Store room2.5255.0 m²Revenue 1Revenue¹
7Reception542020.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.

  1. Double-click the cell or press F2 so you're editing it.
  2. Select just the characters to change, for example the 2 at the end of m2.
  3. Press Ctrl+1. While you're editing, Excel opens a Format Cells box with only the Font tab.
  4. Under Effects, tick Superscript or Subscript.
  5. 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.

=SUBSTITUTE(G2,"CO2","CO₂")

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.

="Area (m"&CHAR(178)&")"

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.

=SUM(E2:E7)

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.

=TEXT(SUM(D2:D7),"#,##0.0"" m²""")

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).

=SUBSTITUTE(G6," 1","¹")

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

Related guides

Updated