Subscript formatting in Excel shrinks text and lowers it below the baseline, useful for chemical formulas, mathematical notation, and footnote references

Excel does not have a dedicated subscript button on the ribbon like Word does. Instead, you format text as subscript through the Format Cells dialog or by using a keyboard shortcut. The process works the same whether you are typing a new formula label, editing an existing cell, or formatting text that is already in place.

Subscript only works on text within a cell — not on the cell reference itself or on formula operators. If you need H₂O to appear in a cell, you type the text directly into that cell and then apply subscript formatting to just the characters that should be smaller and lowered.

Key Takeaways

  • Use Ctrl+1 to open Format Cells, then check the Subscript box under the Font tab to format selected text.
  • On Mac, press Ctrl+Command+B after selecting the text you want to subscript.
  • You must select only the characters you want subscripted — subscript applies to the selection, not the whole cell.
  • Subscript text appears smaller and sits below the baseline of regular text in the same cell.
  • Subscript formatting is purely visual and does not change the actual cell value or how Excel treats the text in calculations.

How to subscript text using the Format Cells dialog

Open the cell you want to edit by double-clicking it or pressing F2. This puts the cell into edit mode so you can select individual characters within it. Click and drag to highlight only the characters that should be subscripted — for example, if your cell reads "H2O", select just the "2".

Press Ctrl+1 to open the Format Cells dialog. On the Font tab, check the box next to Subscript. Click OK. The selected characters will immediately shrink and drop below the baseline. Exit edit mode by pressing Enter or clicking elsewhere.

If you need to subscript text in a cell that already contains formatted text, the same process applies — enter edit mode, select the specific characters, and apply subscript. You can mix regular, subscript, and superscript text in a single cell this way.

Subscript on Mac

Mac users follow the same process to enter edit mode: double-click the cell or press F2, then select the characters you want subscripted. Instead of Ctrl+1, press Ctrl+Command+B to open the Format Cells dialog. Navigate to the Font tab and check Subscript, then click OK.

Alternatively, some Mac versions of Excel support the keyboard shortcut Ctrl+Command+Minus (the minus key on the main keyboard, not the numeric keypad) to toggle subscript on selected text. Test this in your version first, as the shortcut behavior varies.

Subscript versus superscript and when to use each

Subscript lowers text below the baseline; superscript raises it above. Excel handles both the same way — select the text, open Format Cells, and check either Subscript or Superscript on the Font tab. Use subscript for chemical formulas (H₂O, CO₂), mathematical subscripts (x₁, a₂), and some footnote styles. Use superscript for exponents (x², 2³), trademark symbols (™), and footnote markers.

Both formatting options reduce the text size automatically. The exact size depends on your base font size, but Excel scales subscript and superscript proportionally so they remain readable.

Subscript in formulas and cell references

You cannot apply subscript to a formula itself or to cell references within a formula. If you write =A1+B2, the "1" and "2" in those cell references will not subscript no matter what formatting you apply. Subscript only affects text that appears as content in a cell, not the formula code.

If you need a label next to a formula result to include subscript text, put the label in a separate cell and format that cell. For example, put your formula result in C1 and the label "Result₁" in D1, then subscript the "1" in D1.

Removing subscript formatting

To remove subscript from text, enter edit mode in the cell, select the subscripted characters, press Ctrl+1, and uncheck the Subscript box. You can also select the subscripted text and press Ctrl+Spacebar to clear all direct formatting, though this removes bold, italic, and color as well.

If you want to remove subscript from multiple cells at once, select all the cells, press Ctrl+H to open Find & Replace, and use the Format button to search for subscript formatting and replace it with normal formatting. This is faster than editing each cell individually.

Common reasons subscript does not appear to work

The most common issue is that you selected the entire cell instead of just the characters you want subscripted. Subscript formatting applies only to your selection. If the whole cell is selected, Excel will not let you subscript it — you must enter edit mode first and select individual characters.

Another issue is that the font size is already very small. Subscript reduces the text further, and if your base text is already tiny, the subscripted portion may become nearly invisible. Increase the base font size if subscript text is hard to read. Some fonts also render subscript less clearly than others; if readability is critical, test your subscript text in the font you plan to use.

Frequently Asked Questions

Can I subscript numbers in a cell reference like A₁?

No. Cell references in formulas cannot be subscripted because they are part of the formula code, not cell content. You can only subscript text that appears as the visible content of a cell. If you need a subscripted label, put it in a separate cell.

Does subscript formatting change the actual value in the cell?

No. Subscript is purely visual formatting. If a cell contains "H2O" with the "2" subscripted, the cell value is still the text "H2O" — the subscript does not change how Excel stores or calculates anything. It only changes how the text appears on screen and in print.

Can I subscript text in a formula result?

Not directly. Formulas return values, and you cannot format part of a formula result. If you need a subscripted label for a result, create the label in a separate cell and subscript it there. Alternatively, use a formula to concatenate text with subscript formatting applied to the text cell afterward.

What if subscript text is too small to read?

Increase the base font size of the cell. Subscript scales proportionally, so larger base text produces larger subscript text. If you are using a very small font, subscript may become illegible — moving to a larger font size solves this.

Does subscript work the same way in Excel Online?

Excel Online has limited formatting options. You can apply subscript through the Format Cells dialog, but the interface is slightly different. Open the cell, select your text, click the Format button in the ribbon, choose Cells, and check Subscript on the Font tab. The result appears the same as in desktop Excel.