Subscript and superscript in Excel work differently than in Word
Excel does not have a built-in subscript or superscript button in the toolbar like Word does. Instead, you format the text after you type it by selecting the specific characters you want to shrink and shift, then using the Format menu. The process takes a few extra steps, but it works reliably in every version of Excel.
The key difference from Word: in Excel, you cannot explore subscript or superscript to text inside a cell while you are typing. You have to finish typing first, then go back and select just the characters you want formatted, then explore the formatting. This matters because it changes your workflow — you type the whole thing, then edit the appearance.
Key Takeaways
- Type your text normally first, then select only the characters you want as subscript or superscript before formatting.
- Right-click the selected characters and choose Format Cells, then check the Subscript or Superscript box under the Font tab.
- You can also use the Format menu at the top: Format > Cells > Font tab > Subscript or Superscript.
- Subscript and superscript formatting in Excel works the same way in Windows and Mac versions.
- If you need subscript or superscript in a chart label or title, you may need to use the caret symbol (^) or other workarounds instead.
How to format subscript in a cell
Start by typing your text normally into the cell. For example, if you need to write H₂O, type H2O first. Do not worry about the size or position yet.
Next, double-click the cell to enter edit mode, or press F2 while the cell is selected. The cell will show a cursor and you can now select individual characters. Click and drag to highlight only the characters you want as subscript — in this case, just the 2.
Right-click the selected characters. A menu will appear. Click Format Cells at the bottom of the menu. The Format Cells dialog box opens. Click the Font tab if it is not already selected. You will see a Subscript checkbox in the Effects section. Check that box and click OK. The selected characters shrink and move down.
Press Enter or click outside the cell to finish editing. The subscript formatting stays in place.
How to format superscript in a cell
The steps are identical to subscript, except you check the Superscript box instead. Type your text first — for example, E=mc² becomes E=mc2. Then double-click the cell, select just the 2, right-click, choose Format Cells, click the Font tab, check Superscript, and click OK.
Superscript characters move up and shrink, which is what you need for exponents, footnote markers, or chemical formulas. The formatting applies only to the characters you selected, so the rest of the text stays normal size.
Using the Format menu instead of right-click
If right-clicking does not work or you prefer the menu, you can reach the same dialog through the top menu bar. After you select the characters you want to format, click Format in the menu bar, then click Cells. The Format Cells dialog opens to the same Font tab. Check Subscript or Superscript and click OK.
This method works the same way in Windows and Mac versions of Excel. The menu path is identical. Some people find it faster than right-clicking, especially if they are already using the keyboard to navigate.
Subscript and superscript in chart titles and labels
Formatting subscript or superscript inside a chart title or axis label is more limited. Excel charts do not always recognize the subscript and superscript formatting the same way cells do. If you type a title directly into a chart and try to format it, the formatting may not stick or may disappear when you click away.
For chart labels, try typing the text with a caret (^) for superscript — for example, x^2 instead of x² — and note that in your chart. Alternatively, you can create the formatted text in a cell first, then copy it into the chart title. Test this in your specific version of Excel, because behavior varies slightly between versions and between Windows and Mac.
Removing subscript or superscript formatting
To remove subscript or superscript formatting, select the formatted characters again, right-click, choose Format Cells, click the Font tab, and uncheck the Subscript or Superscript box. Click OK. The characters return to normal size and position.
You can also select the characters and press Ctrl+Shift+Z (Windows) or Command+Shift+Z (Mac) to clear all formatting at once, though this removes other formatting too — bold, italic, color, and so on. If you only want to remove subscript or superscript, use the Format Cells dialog instead.
Keyboard shortcut for subscript and superscript
Excel does not have a dedicated keyboard shortcut for subscript or superscript the way Word does (Ctrl+= for subscript, Ctrl+Shift+= for superscript in Word). You have to use the Format Cells dialog or the right-click menu every time.
If you format subscript or superscript frequently, consider using Word for documents that need it heavily, then copying the formatted text into Excel if you need it there. Or create a template in Excel with the formatting already applied, then copy those cells as a starting point for new work.
Frequently Asked Questions
Can I type subscript or superscript directly without selecting and formatting?
No. Excel requires you to type the text first, then select the characters and explore formatting. You cannot toggle subscript or superscript on while typing the way you can in some other programs. This is a limitation of how Excel handles cell formatting.
Does subscript and superscript formatting print correctly?
Yes. When you print the spreadsheet or export it to PDF, subscript and superscript formatting prints exactly as it appears on screen. The formatting is part of the cell data, not just a display effect.
What if the subscript or superscript formatting does not appear?
Make sure you are in edit mode (double-click the cell or press F2) before you select the characters. If you select the entire cell without entering edit mode, the Format Cells dialog will format the whole cell, not just the characters you want. Also check that you are using a font that supports the size reduction — most standard fonts do, but some decorative fonts may not display subscript or superscript clearly.
Can I copy subscript or superscript formatting to other cells?
Yes. Use the Format Painter tool. Click the cell with the subscript or superscript formatting, click the Format Painter button in the toolbar (it looks like a paintbrush), then click the cell where you want to paste the formatting. This copies all formatting, including subscript or superscript.
Does subscript or superscript work in Excel formulas?
No. Subscript and superscript formatting is visual only and does not affect how Excel reads or calculates the cell. If you need to use subscript or superscript in a formula result, format the result cell after the formula calculates, not the formula itself.