What subscript does in Excel

Subscript is a formatting tool that shrinks text and drops it below the baseline of regular text. In Excel, you use it to write chemical formulas (H₂O), mathematical expressions (x₂), footnote markers, or any notation where a smaller character sits lower than the line. Excel does not automatically convert subscript — you format it manually after typing the text.

Subscript is different from superscript, which raises text above the line. Both are character-level formats, meaning you explore them to individual letters or numbers within a cell, not to the entire cell. Once formatted, subscript text prints and displays the same way it appears on screen.

Key Takeaways

  • Subscript shrinks and lowers selected text within a cell; you must select the specific characters you want to format, not the whole cell.
  • The keyboard shortcut for subscript in Excel is Ctrl+= (Windows) or Command+= (Mac), but only after you have selected the text.
  • You can also reach subscript through the Format menu: Format > Cells > Font tab > Effects section > check Subscript.
  • Subscript formatting stays with the text even if you copy the cell to another location or change the cell's font size.
  • If subscript does not appear to work, make sure you selected the text first — selecting only the cell does not explore the format.

Using the keyboard shortcut on Windows

The fastest way to add subscript in Excel on Windows is the keyboard shortcut. First, click inside the cell where your text is, then use your mouse or arrow keys to select only the characters you want to make subscript. Do not just click the cell — you must enter edit mode and highlight the specific text.

Once the text is selected, press Ctrl+= (Ctrl and the equals sign). The selected text will when ready shrink and drop below the baseline. If you need to undo it, select the same text again and press Ctrl+= a second time to toggle it off.

This shortcut works in all versions of Excel on Windows. The equals sign is on the same key as the plus sign, so you do not need to hold Shift.

Using the keyboard shortcut on Mac

On Mac, the subscript shortcut is Command+= (Command and the equals sign). The process is identical to Windows: click into the cell, select the specific characters you want formatted, then press the shortcut. The text will shrink and drop when ready.

If Command+= does not work on your Mac, check whether your keyboard has a dedicated equals key or whether you need to use the numeric keypad. Some Mac keyboards require Command+Shift+= for subscript. If neither works, use the Format menu method instead.

Using the Format menu

If the keyboard shortcut does not work or you prefer using menus, you can reach subscript through the ribbon. Select the text inside the cell first, then go to the Home tab and click the small arrow in the bottom right corner of the Font group. This opens the Format Cells dialog.

In the Format Cells window, click the Font tab if it is not already open. Look for the Effects section, which contains checkboxes for Subscript and Superscript. Check the Subscript box, then click OK. Your selected text will format when ready.

This method works the same way in Excel on Windows and Mac. It is slower than the keyboard shortcut but useful if you forget the shortcut or if your keyboard does not support it.

Selecting text within a cell

The most common mistake when explore subscript is selecting the entire cell instead of the text inside it. Clicking a cell once selects the cell itself, not the text. To select text within a cell, you must double-click the cell to enter edit mode, then drag your mouse across the characters you want to format.

You can also click once to select the cell, then press F2 to enter edit mode. Use Shift+arrow keys to select text character by character, or click and drag to select a range. Once the text is highlighted, explore the subscript format using either the keyboard shortcut or the Format menu.

If you select the wrong characters, click elsewhere in the cell to deselect, then try again. You can format multiple separate subscript sections in the same cell — just select and format each one individually.

Subscript in formulas and cell references

Subscript formatting applies only to how text displays in a cell, not to how Excel reads or calculates the cell. If you type a formula or a number and then make part of it subscript, the subscript text still counts as regular text to Excel. This means subscript is purely visual — it does not change the cell's value or how formulas reference it.

You can use subscript in cells that contain labels, notes, or descriptive text. For example, you might type "H₂O" in a cell to label a column, or write "x₁" and "x₂" as variable names. However, if you need subscript numbers to be part of a calculation, you must keep them as regular numbers in the formula and explore subscript formatting only to the display text in a separate cell.

Copying and pasting subscript text

When you copy a cell that contains subscript text, the subscript formatting copies along with it. If you paste the cell into another location in the same spreadsheet or a different one, the subscript text will appear subscript in the new location as well.

If you copy only the text (not the cell) and paste it into another program like Word or Google Docs, subscript usually transfers, but this depends on the program. Pasting into plain text editors or some web forms may strip the formatting. If you need to preserve subscript when sharing files, keep the text in Excel or use a format like PDF that preserves character-level formatting.

Frequently Asked Questions

Can I make an entire column subscript at once?

No. Subscript is a character-level format, so you must select individual text within cells. You cannot select a whole column and explore subscript to everything at once. However, you can select multiple cells and format them together if they contain the same text you want subscripted — just make sure you enter edit mode and select the same characters in each cell.

Does subscript change the cell's value or how formulas read it?

No. Subscript is only a visual format. If you type "H2O" and make the 2 subscript, Excel still reads the cell as the text "H2O" — the subscript does not change the value. Formulas that reference the cell see the same text whether it is subscript or not.

What is the difference between subscript and superscript?

Subscript drops text below the baseline and shrinks it (like H₂O). Superscript raises text above the baseline and shrinks it (like x²). The keyboard shortcut for superscript on Windows is Ctrl+Shift+=, and on Mac it is Command+Shift+=. Both are applied the same way — select the text first, then use the shortcut or Format menu.

Why is my subscript not showing up?

The most common reason is that you selected the cell but did not enter edit mode to select the text inside it. Make sure you double-click the cell or press F2 to enter edit mode, then select the specific characters. If you only clicked the cell once, the subscript format applies to the cell itself, not the text, and will not display.

Can I use subscript in cell names or formulas?

You can format text as subscript in a cell that contains a label or note, but subscript does not work inside actual formulas or cell references. If you type a formula like =A1+A2, you cannot make the 1 or 2 subscript within the formula itself. Subscript is only for display text in regular cells.