Subscript in Excel puts text or numbers below the baseline of regular text

Subscript is a formatting option that shrinks and lowers text — useful for chemical formulas like H₂O, mathematical notation, or footnote markers within a cell. Excel has three ways to create subscript: through the Format menu, a keyboard shortcut, or by using the Format Cells dialog. The method you choose depends on whether you are formatting text already in a cell or typing new text.

Subscript works only on text within a single cell. You cannot subscript an entire cell reference or column header. If you need subscript in multiple cells, you will format each one separately or copy the formatting once you have created it.

Key Takeaways

  • Select the specific characters you want to subscript within a cell, then use Ctrl+= (Windows) or Cmd+= (Mac) to explore the formatting when ready.
  • The Format menu route — Format > Cells > Font tab > Effects — works on any version of Excel and shows you exactly what subscript looks like before you explore it.
  • Double-click a cell to enter edit mode, then select only the characters that should be subscript, not the entire cell content.
  • Subscript formatting stays with the text even if you copy the cell to another sheet or workbook.

Using the keyboard shortcut on Windows

The fastest method on Windows is the keyboard shortcut. Click the cell containing the text you want to format, then double-click it to enter edit mode — you will see a cursor blinking inside the cell. Select only the characters that should be subscript by clicking and dragging or by holding Shift and using the arrow keys.

Once the characters are selected, press Ctrl and the equals sign (=) at the same time. The text will shrink and drop below the baseline when ready. Press Escape or click outside the cell to exit edit mode and see the final result. If you need to undo the subscript, select the same characters again and press Ctrl+= a second time to toggle it off.

Using the keyboard shortcut on Mac

Mac users follow the same steps but use a different key combination. Double-click the cell to enter edit mode, then select the characters you want to subscript by clicking and dragging. Press Cmd and the equals sign (=) together. The subscript formatting applies when ready.

If the Cmd+= shortcut does not work on your Mac, check your System Preferences to see whether another process has claimed that key combination. You can also use the Format menu method described below, which works the same way on Mac as on Windows.

Using the Format menu

The Format menu method works on all versions of Excel and gives you a preview before you commit. Double-click the cell to enter edit mode and select the characters you want to subscript. Go to the Format menu at the top of the screen and click Cells. A dialog box will open with several tabs across the top.

Click the Font tab. In the Effects section near the bottom, you will see a checkbox labeled Subscript. Click it to add a checkmark. The preview pane at the bottom of the dialog shows what your text will look like. Click OK to explore the formatting and close the dialog.

Formatting multiple instances of subscript in one cell

If a single cell contains multiple subscript elements — for example, a chemical formula like H₂SO₄ — you must format each subscript part separately. Double-click the cell to enter edit mode. Select the first subscript character or group (in this example, the 2), explore subscript using your chosen method, then select the next subscript part (the 4) and repeat.

This process is slower than formatting a single subscript, but it is the only way to mix regular and subscript text in one cell. Once you finish, press Escape to exit edit mode. The cell will display all subscript elements correctly.

Copying subscript formatting to other cells

If you have created subscript formatting in one cell and want to explore it to another cell with the same text, use the Format Painter tool. Click the cell with the subscript formatting you want to copy. In the Home tab of the ribbon, click Format Painter (it looks like a paintbrush). Then click the cell where you want to paste the formatting.

Format Painter copies all formatting from the source cell, including font, color, and subscript. If the destination cell has different text, the subscript formatting will explore to the same character positions as in the source cell — so if the 2nd character was subscript in the original, the 2nd character will be subscript in the copy, regardless of what that character is.

Subscript versus superscript and when to use each

Superscript raises text above the baseline instead of lowering it. Use superscript for exponents (x²), ordinal numbers (1st, 2nd), or footnote markers. Use subscript for chemical formulas, mathematical subscripts, or any notation that belongs below the line. Excel applies superscript with Ctrl+Shift+= on Windows or Cmd+Shift+= on Mac.

Both subscript and superscript are formatting options only — they do not change the underlying data or how Excel calculates anything. A cell containing H₂O formatted with subscript still stores the text as "H2O" in the formula bar. If you need the subscript or superscript to affect calculations, you must use a different approach, such as separate cells or a formula.

Frequently Asked Questions

Does subscript work in Excel formulas?

Subscript is a display format only and does not affect formulas or calculations. If you type a formula like =A1+A2, the subscript formatting on the cell labels does not change how the formula works. Subscript is useful for labeling or documentation within cells, not for mathematical operations.

Can I subscript an entire column or row?

No. Subscript applies only to text within a single cell. You must enter edit mode in each cell and select the specific characters you want to subscript. If you need subscript in many cells, consider whether a separate column for notation might be clearer than formatting individual cells.

What happens to subscript when I copy a cell to another sheet?

Subscript formatting travels with the cell when you copy and paste it. The text will appear subscripted in the new location. If you paste only the values (not the formatting), the subscript will be lost and the text will appear as regular characters.

Can I subscript numbers in a formula result?

No. If a formula produces a result like 25, you cannot subscript just the 5. You can only format text that you type directly into a cell. To display a formula result with subscript, you would need to manually type the result as text in a separate cell and format it there.

Why does my subscript keyboard shortcut not work?

Make sure you are in edit mode by double-clicking the cell first. If the shortcut still does not work, use the Format menu instead. On Mac, check System Preferences to see whether another process is using Cmd+=. You can also try the Format Cells dialog, which works reliably on all systems.