What subscript does and when you need it

Subscript is a formatting option that shrinks text and moves it below the baseline of regular text. In Excel, subscript is most useful when you're writing chemical formulas (H₂O), mathematical notation, or footnote references within a cell. The text stays in the same cell — it doesn't create a separate note or link.

Excel treats subscript as character formatting, the same way it treats bold or italic. You apply it to individual letters or numbers within a cell, not to the whole cell. Once formatted, subscript text prints and displays at a smaller size and lower position than the surrounding text. This is different from superscript, which moves text above the baseline instead of below it.

Key Takeaways

  • Select the specific characters you want to make subscript, then use Ctrl+= (Windows) or Cmd+= (Mac) to apply the formatting.
  • 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 in the spreadsheet.
  • To remove subscript, select the formatted text and press Ctrl+= again (or use the Format menu) to toggle it off.
  • Subscript works only on text within cells, not on chart titles, axis labels, or other chart elements.

Using the keyboard shortcut on Windows

The fastest way to apply subscript on a Windows computer is the keyboard shortcut Ctrl+= (hold Control and press the equals sign). First, click inside the cell where your text is, then highlight only the characters you want to make subscript by clicking and dragging across them. You must be in edit mode inside the cell for this to work — double-click the cell or press F2 to enter edit mode if you are not already there.

Once those characters are selected, press Ctrl+= and they will shrink and drop below the line. If you want to remove subscript from the same text, select it again and press Ctrl+= a second time — the shortcut toggles the formatting on and off. This method works consistently across all Windows versions and keyboard layouts that have a standard equals sign key.

Using the keyboard shortcut on Mac

On a Mac, the subscript shortcut is Cmd+= (hold Command and press the equals sign). Click into your cell and enter edit mode by double-clicking or pressing F2, then select the characters you want to format by dragging across them.

The same toggle rule applies: pressing Cmd+= again removes the subscript formatting. If your Mac keyboard does not have an equals sign in the same location as a Windows keyboard, look for the key that produces = without holding Shift. On some Mac keyboards, this may require adjusting for your keyboard layout or language settings.

Accessing subscript through the Format menu

If the keyboard shortcut does not work or you prefer using menus, you can reach subscript through Excel's Format menu. First, enter edit mode in your cell by double-clicking it, then select the characters you want to format by dragging across them. Click Format in the menu bar and choose Cells.

In the Format Cells dialog, click the Font tab. Look for the Effects section, which contains a checkbox labeled Subscript. Check that box and click OK. The text will immediately drop below the baseline and shrink. Unchecking the box removes the formatting. This method works the same way on both Windows and Mac versions of Excel.

Subscript in formulas versus text

Subscript formatting only changes how text appears — it does not change how Excel reads or calculates the cell. If you type a formula like =H2O and make the 2 subscript, Excel still reads it as text, not as a chemical formula or calculation. The subscript is purely visual and does not affect any calculations or references in your spreadsheet.

If you need subscript in a formula result (for example, displaying H₂O as the output of a calculation), you must format the cell after the formula calculates. The formula itself produces plain text, and then you apply subscript formatting to the result. This two-step process ensures that your formula works correctly while still displaying the text the way you want it to appear.

Copying and pasting subscript formatting

When you copy a cell that contains subscript text, the subscript formatting travels with it. Paste the cell anywhere in your spreadsheet and the subscript will appear in the new location exactly as it did in the original. This makes it easy to reuse formatted text across multiple parts of your spreadsheet without having to reapply the formatting each time.

If you want to copy only the formatting (subscript and any other formatting like bold or color) without copying the text itself, use Paste Special. Right-click the destination cell, choose Paste Special, and select Formats only. This copies the subscript formatting to new text you type in that cell, saving time when you are working with repeated formatting patterns.

Frequently Asked Questions

Can I make an entire column subscript at once?

No. Subscript formatting applies only to individual characters within a cell, not to whole cells or columns. You must select the specific text you want to format. If you select an entire cell or column and apply subscript, nothing happens because Excel has no characters selected to format.

Does subscript work in Excel charts or titles?

Subscript formatting works in cell text, but not in chart titles, axis labels, or other chart elements. Charts in Excel do not support subscript formatting. If you need subscript in a chart, you may need to create the text in a cell, format it there, and then reference that cell in the chart title.

What if the keyboard shortcut does not work?

Some keyboards or keyboard layouts may not recognize Ctrl+= or Cmd+=. Try using the Format menu instead: Format > Cells > Font tab > Subscript checkbox. If that also does not work, check whether your keyboard has the equals sign in the expected location or whether another program is intercepting the shortcut.

Can I use subscript and superscript in the same cell?

Yes. Select different characters within the same cell and apply subscript to some and superscript to others. For example, you could write E=mc² by making the 2 superscript while leaving E, =, m, and c at normal size.

Does subscript formatting print the same way it appears on screen?

Yes. When you print a spreadsheet, subscript text prints at the same reduced size and lower position as it appears on your screen. The formatting is preserved in printed output, so chemical formulas, mathematical notation, and other subscript text will look correct on paper.