Subscript formatting makes text appear smaller and lower than the baseline
In Excel, subscript is a character format that shrinks text and positions it below the line of regular text. It's useful for chemical formulas (H₂O), mathematical notation, footnote markers, and any situation where you need smaller text sitting lower on the line. Excel offers three ways to apply subscript: through the Format menu, through a keyboard shortcut, or through the Format Cells dialog.
The quickest method depends on whether you're formatting a single character, a word, or multiple instances across your spreadsheet. All three approaches produce the same visual result — they just differ in speed and convenience.
Key Takeaways
- Select the specific text you want to format as subscript before applying any formatting — Excel won't subscript an entire cell, only the characters you choose.
- The keyboard shortcut Ctrl+= (Windows) or Cmd+= (Mac) is the fastest way to toggle subscript on and off for selected text.
- The Format menu path is Format > Cells > Font tab > Effects section > Subscript checkbox, which works if you prefer not to memorize shortcuts.
- Subscript formatting only works on text within cells — you cannot subscript cell references or formulas themselves.
- Once you apply subscript to text, you can remove it by selecting the text again and pressing the same keyboard shortcut or unchecking the box in Format Cells.
Using the keyboard shortcut (fastest method)
On Windows, select the text or character you want to subscript, then press Ctrl+= (Ctrl and the equals sign). On Mac, use Cmd+= instead. The text will immediately shrink and drop below the baseline. Press the same shortcut again to remove subscript formatting.
This method works only if you double-click the cell first to enter edit mode, then select the specific characters you want to format. If you select a cell without entering edit mode, the shortcut won't work — Excel will think you're trying to insert a row instead.
Using the Format Cells dialog
Double-click the cell to enter edit mode, then select the text you want to subscript. Right-click and choose Format Cells, or use the menu path Format > Cells. In the dialog that opens, click the Font tab, then look for the Effects section. Check the Subscript box and click OK.
This method is slower than the keyboard shortcut but gives you a visual confirmation that subscript is selected before you apply it. You can also access superscript (text raised above the baseline) from the same Effects section if you need it.
Formatting multiple instances of subscript text
If you need to subscript the same text in many cells, the fastest approach is to format one instance, then copy that cell and paste it into the others. Excel preserves formatting when you paste, so the subscript will carry over.
Alternatively, use Find & Replace (Ctrl+H) to find the text, then replace it with itself while applying subscript formatting. Open Find & Replace, type the text in the Find field, type the same text in the Replace field, click Format in the Replace section, choose Font, check Subscript, then click Replace All. This works across your entire spreadsheet at once.
What subscript cannot do in Excel
Subscript formatting applies only to text displayed in cells — it does not affect cell references, formulas, or numbers used in calculations. If you subscript the number 2 in a cell, Excel still treats it as the number 2 for any math that references that cell. Subscript is purely visual.
You also cannot subscript an entire cell at once. Excel requires you to enter edit mode and select individual characters or words. If you select a cell without entering it and apply subscript, nothing will happen.
Subscript in headers and labels
Subscript works well for labeling columns or rows with chemical formulas, mathematical variables, or footnote references. Type the text normally, then double-click the cell, select the characters that should be subscript, and apply the formatting. The subscript text will stay in place even if you resize columns or rows.
If you're building a table with many subscripted labels, format one cell as a template, copy it, and paste it into the others. Then edit the text in each copy — the subscript formatting will remain on whatever characters you leave in subscript position.
Removing subscript formatting
To remove subscript from text, double-click the cell, select the subscripted characters, and press Ctrl+= (Windows) or Cmd+= (Mac) again. The text will return to normal size and position. Alternatively, select the text, open Format Cells, uncheck the Subscript box, and click OK.
If you accidentally subscripted the wrong text, Ctrl+Z (Undo) will reverse the last formatting change. This is faster than manually removing subscript from multiple characters.
Frequently Asked Questions
Can I subscript numbers in a formula?
No. Subscript formatting only changes how text looks in a cell — it doesn't change how Excel treats the numbers in calculations. If you need subscripted numbers for display purposes, put them in a separate cell as text and format that cell, rather than trying to subscript numbers within a formula.
Does subscript work in Excel on Mac the same way as Windows?
Yes, except the keyboard shortcut uses Cmd+= instead of Ctrl+=. The Format Cells dialog path is identical. All three methods produce the same result on both platforms.
Can I subscript text in a chart title or axis label?
Yes. Double-click the chart to enter edit mode, then double-click the title or axis label you want to edit. Select the text you want to subscript and use Ctrl+= (Windows) or Cmd+= (Mac), or use the Format Cells dialog the same way you would in a regular cell.
What's the difference between subscript and superscript?
Subscript positions text below the baseline (like H₂O). Superscript positions text above the baseline (like E=mc²). Both are in the Format Cells dialog under the Font tab, Effects section. Use superscript for exponents and footnote markers; use subscript for chemical formulas and mathematical notation.
If I save my Excel file as a PDF, will subscript formatting stay?
Yes. Subscript formatting is preserved when you export to PDF, so the text will appear subscripted in the PDF file as well.