The simplest way to add a subscript in Excel

Excel does not have a built-in subscript button in the toolbar like Word does. To write a subscript character — a number or letter that sits below the baseline, like the "2" in H₂O — you have three working routes: use the Format Cells dialog, type a Unicode character directly, or paste a pre-formatted subscript from another program.

The most reliable method for a single cell is the Format Cells dialog. Select the cell containing your text, highlight only the characters you want as subscript, then press Ctrl+1 (Windows) or Command+1 (Mac) to open Format Cells. Click the Font tab, check the Subscript box, and click OK. The selected characters will drop below the line.

This method works for any character and preserves your work when you save and reopen the file. It does not require special fonts or external tools.

Key Takeaways

  • The Format Cells dialog (Ctrl+1 or Command+1) is the most reliable way to subscript text in Excel and works across all versions and operating systems.
  • You must select only the characters you want subscripted before opening Format Cells — the subscript formatting applies only to the highlighted text.
  • Unicode subscript characters like ₂ and ₃ can be typed directly if your keyboard supports them, but they are actual characters, not formatting, so they may not print or display consistently.
  • If you need subscripts frequently, consider whether a different tool like Google Sheets or LibreOffice Calc offers features that better match your workflow.

Using the Format Cells dialog on Windows

Open your Excel file and click the cell that contains the text you want to modify. Click inside the cell or press F2 to enter edit mode so you can select individual characters within the cell.

Highlight only the characters that should appear as subscript. For example, if your cell reads "H2O", click and drag to select only the "2". Then press Ctrl+1 to open the Format Cells dialog. Click the Font tab if it is not already selected, locate the Subscript checkbox under Effects, and click it. Click OK. The "2" will now sit below the baseline of the other letters.

Save your file. The subscript formatting stays in place when you close and reopen the file, and it prints correctly on paper.

Using the Format Cells dialog on Mac

Click the cell containing your text and press F2 or double-click the cell to enter edit mode. Highlight the characters you want to subscript by clicking and dragging across them.

Press Command+1 to open the Format Cells dialog. Click the Font tab, find the Subscript checkbox under Effects, and click it. Click OK. The selected characters will drop below the baseline.

Mac versions of Excel sometimes place the Subscript option under a different name or location depending on your Excel version. If you do not see it under Effects, look for a dropdown menu labeled "Position" or "Baseline" and select "Subscript" from the list.

Typing Unicode subscript characters directly

If you need only a few subscript numbers or letters, you can type Unicode subscript characters directly into your cell. These are actual characters, not formatting, so they behave differently than formatted subscripts.

Common subscript Unicode characters include: ₀ ₁ ₂ ₃ ₄ ₅ ₆ ₇ ₈ ₉ for numbers, and ₐ ₑ ₓ ₙ for letters. On Windows, you can type them by holding Alt and typing the Unicode number on the numeric keypad (this varies by character). On Mac, you can copy and paste them from a Unicode character map or from a web search result.

The drawback is that these characters are not true formatting — they are separate Unicode glyphs. They may not display the same size or position across different computers, and some printers or PDF converters may not handle them consistently. For scientific or technical work where consistency matters, the Format Cells method is safer.

When to use subscript versus other formatting options

Subscript is the right choice when you are writing chemical formulas (H₂O, CO₂), mathematical notation (x₁, x₂), or footnote references. It is not the same as superscript, which sits above the baseline and is used for exponents (2³) and footnote markers.

If you need superscript instead, use the same Format Cells dialog but check the Superscript box. If you need both subscript and superscript in the same cell, you will need to format each part separately — select the subscript characters, explore subscript formatting, then select the superscript characters and explore superscript formatting.

For very long documents with many subscripts, consider whether a different tool might serve you better. Google Sheets has a similar Format Cells method. LibreOffice Calc and Microsoft Word both offer subscript buttons in the toolbar, which is faster if you are formatting many instances.

Troubleshooting subscript that does not appear

If you format text as subscript but it does not look subscripted, check that you are in edit mode. Click the cell and press F2 (or double-click it) to enter edit mode, then highlight the characters again and reapply the subscript formatting. Subscript formatting sometimes does not display correctly in normal cell view until you press Enter to confirm the edit.

If the subscript appears in the cell but not in the formula bar, that is normal — the formula bar shows the raw text, and formatting displays only in the cell itself. If the subscript prints incorrectly or appears too small, your printer driver or PDF converter may not support Excel's subscript formatting. Test by printing a small sample first.

If you copied the cell from another program, the subscript formatting may not have transferred. Reapply it using the Format Cells dialog in Excel.

Frequently Asked Questions

Can I make multiple characters subscript at once?

Yes. Highlight all the characters you want subscripted together — they do not have to be consecutive, but it is easier if they are — then open Format Cells and check Subscript. All highlighted characters will drop below the baseline at the same time.

Does subscript formatting work in Excel formulas?

No. Subscript is a display-only format that affects how text looks in a cell, not how Excel calculates it. If you type "H2O" and format the "2" as subscript, Excel still reads it as the text "H2O" and does not recognize it as a chemical formula. Subscript is for labels and display, not for calculations.

What is the difference between subscript and using a smaller font size?

Subscript moves the text below the baseline and usually shrinks it slightly — it is a single formatting option. A smaller font size only makes text smaller without moving it. Subscript is the correct choice for chemical formulas and mathematical notation because it positions the character correctly, not just because it is small.

Can I undo subscript formatting?

Yes. Select the subscripted characters, open Format Cells (Ctrl+1 or Command+1), uncheck the Subscript box, and click OK. The characters will return to normal baseline position.

Does subscript work the same way in Google Sheets?

Google Sheets has a similar method but uses the menu instead of a keyboard shortcut. Highlight the characters, click Format in the menu, select Text, then choose Subscript. The result is the same as Excel, though the interface is different.