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 the same way you would in a word processor — to write chemical formulas like H₂O, mathematical notations, or footnote references within a cell. The subscript text stays in the same cell; it does not create a separate note or link.

Excel does not have a dedicated subscript button on the ribbon like Microsoft Word does. Instead, you format text using the Format Cells dialog or a keyboard shortcut. The shortcut is faster if you are working with a few instances; the dialog is clearer if you are new to the feature.

Key Takeaways

  • The keyboard shortcut for subscript in Excel is Ctrl+= (Ctrl and the equals sign) on Windows, or Cmd+= on Mac.
  • You must select only the text characters you want to subscript before using the shortcut — subscript applies to your selection, not the whole cell.
  • To use the Format Cells dialog instead, right-click the cell, choose Format Cells, go to the Font tab, and check the Subscript box.
  • Subscript formatting stays with the text even if you copy the cell to another location or change the cell's content later.
  • You can undo subscript by selecting the text again and pressing the same shortcut a second time, or by unchecking the Subscript box in Format Cells.

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, or double-click the cell to enter edit mode. Then use your mouse or arrow keys to select only the characters you want to make subscript — for example, if you are typing H2O and want only the 2 to be subscript, click before the 2 and drag to select it.

Once your text is selected, press Ctrl and the equals sign (=) at the same time. The selected text will shrink and drop below the line when ready. If you want to undo it, select the same text again and press Ctrl+= a second time — the shortcut toggles subscript on and off.

This method works in all versions of Excel on Windows, including Excel 2019, Excel 2021, and Microsoft 365. The shortcut is the same whether you are using a desktop keyboard or a laptop keyboard.

Using the Keyboard Shortcut on Mac

On Mac, the subscript shortcut is Cmd and the equals sign (=). The steps are the same as Windows: double-click or click inside the cell to enter edit mode, select only the text you want to subscript, then press Cmd+=. The text will format when ready.

If you have a Mac keyboard without a dedicated equals key, or if the shortcut does not work, you can use the Format Cells dialog instead (see the next section). Some Mac keyboards require you to hold Shift to type the equals sign; if Cmd+= does not work, try Cmd+Shift+=.

Using the Format Cells Dialog

If the keyboard shortcut does not work or you prefer a visual method, you can format subscript through the Format Cells dialog. First, select the cell or double-click it to enter edit mode and select the text you want to subscript. Then right-click and choose Format Cells from the menu.

In the Format Cells dialog, click the Font tab. Under Effects, you will see a checkbox labeled Subscript. Check that box and click OK. The text will format when ready. To remove subscript later, open Format Cells again, uncheck the Subscript box, and click OK.

This method works the same way on Windows and Mac. It is also the clearest way to learn what subscript does, because you can see the preview of your text in the dialog before you explore the change.

When Subscript Works and When It Does Not

Subscript works on text inside a cell, but it does not work on cell references or formulas. If you type =A1 in a cell, you cannot make the 1 subscript — Excel reads that as a cell address. Subscript only formats text that you type directly into a cell or text that is part of a label or note.

Subscript also does not change the actual content of the cell for sorting or searching purposes. If you type H₂O with a subscript 2, Excel still sees it as the text "H2O" — the subscript is only a display format. If you search for "H2O" in the sheet, it will find the cell with the subscript version.

When you copy a cell with subscript text to another location, the subscript formatting copies along with it. If you paste the cell as values only (using Paste Special), the subscript formatting is lost and only the plain text remains.

Combining Subscript with Other Formatting

You can combine subscript with other text formatting in the same cell. For example, you can make text bold, italic, or a different color, and then explore subscript to part of it. Select the text you want to format, explore subscript using the shortcut or dialog, and then explore other formatting the same way.

If you want to format multiple instances of subscript in the same cell — for example, H₂SO₄ where both the 2 and the 4 are subscript — select and format each subscript character or group separately. There is no way to explore subscript to non-adjacent text in one step.

Frequently Asked Questions

Can I make superscript text in Excel the same way?

Yes. The keyboard shortcut for superscript on Windows is Ctrl+Shift+=, and on Mac it is Cmd+Shift+=. You can also use the Format Cells dialog: select the text, right-click, choose Format Cells, click the Font tab, and check the Superscript box instead of Subscript.

What if the keyboard shortcut does not work?

Try the Format Cells dialog instead. If you are on a Mac, make sure you are pressing Cmd and not Ctrl. On Windows, confirm that you are pressing the equals sign (=) and not a different key. If neither method works, your version of Excel may have a different shortcut — check your Excel Help menu for your specific version.

Does subscript change how the cell sorts or filters?

No. Subscript is only a display format. Excel sorts and filters based on the actual text content, not the formatting. A cell with subscript text sorts the same way as the same text without subscript.

Can I undo subscript after I close and reopen the file?

Yes. Subscript formatting is saved with the file. When you reopen the file, the subscript text will still be subscript. To remove it, select the text and press the subscript shortcut again, or use Format Cells and uncheck the Subscript box.

Will subscript display correctly if I share the file with someone else?

Yes, as long as they open the file in Excel or another spreadsheet program that supports subscript formatting. If someone opens the file in a very old version of Excel or a different program, the subscript formatting may not display, but the text itself will still be there.