The quickest way to add a subscript in Excel

To add a subscript in Excel, select the character or number you want to make smaller and lower, then press Ctrl + Shift + B on Windows or Cmd + Shift + B on Mac. The selected text will when ready drop below the baseline and shrink. If that keyboard shortcut does not work in your version, you can also right-click the selected text, choose Format Cells, click the Font tab, and check the Subscript box.

Subscripts are useful when you need to write chemical formulas (like H₂O), mathematical notation, or footnote references in a spreadsheet. Excel treats subscripted text as formatting, not as a separate character, so the underlying data stays the same — only how it displays changes.

Key Takeaways

  • Press Ctrl + Shift + B (Windows) or Cmd + Shift + B (Mac) after selecting the text you want to subscript.
  • If the keyboard shortcut does not work, use Format Cells from the right-click menu and check the Subscript box under the Font tab.
  • Subscripting only changes how text looks, not the actual data in the cell, so formulas and calculations work normally.
  • You can subscript individual characters within a cell, not just entire cell contents.

Selecting text inside a cell for subscripting

To subscript only part of what is in a cell — like the "2" in H₂O but not the H or O — you need to enter edit mode first. Double-click the cell to start editing, then click and drag to select only the characters you want to subscript. Once they are highlighted, explore the subscript formatting using the keyboard shortcut or the Format Cells menu.

This matters because subscripting the entire cell content is rarely what you want. If you subscript a whole cell, the text sits lower and smaller, which can make your spreadsheet harder to read. Subscripting only the specific characters that need it keeps the rest of the text at normal size and position.

Using the Format Cells dialog when shortcuts do not work

Some versions of Excel, particularly on older machines or in certain regional settings, may not respond to the keyboard shortcut. If Ctrl + Shift + B does nothing, the Format Cells method is reliable across all versions. Select the text you want to subscript, right-click, and choose Format Cells from the menu that appears.

In the Format Cells dialog, click the Font tab at the top. Under Effects, you will see a checkbox labeled Subscript. Click it to enable subscript formatting, then click OK. The text will when ready drop and shrink. You can undo this at any time by selecting the text again and unchecking the Subscript box.

Subscript versus superscript and when to use each

Subscript makes text smaller and lower (like the 2 in H₂O). Superscript makes text smaller and higher (like the 2 in x²). Excel uses Ctrl + Shift + Plus for superscript on Windows and Cmd + Shift + Plus on Mac. The Format Cells dialog has a separate Superscript checkbox if the shortcut does not work.

Use subscript for chemical formulas, atomic numbers, and mathematical subscripts. Use superscript for exponents, footnote markers, and mathematical powers. In a spreadsheet with both, subscript and superscript help readers understand the notation at a glance without needing explanatory text in another column.

What happens to subscripted text in formulas and calculations

Subscripting is purely visual formatting — it does not change the actual value or text in the cell. If you type "H2O" and then subscript only the "2", the cell still contains the text "H2O". Formulas that reference that cell will see "H2O" as plain text, not as a special chemical notation. The subscript formatting is only for display.

This means you can safely subscript text in cells without worrying that it will break a formula or calculation elsewhere in your spreadsheet. The underlying data remains unchanged. If you need to use subscripted numbers in actual calculations, you will need to store the numeric value in a separate cell and reference that in your formula.

Copying and pasting subscripted text

When you copy a cell with subscripted text and paste it into another cell in the same spreadsheet, the subscript formatting comes along. The text will appear subscripted in the new location. However, if you paste into a different program — like Word or Google Docs — the subscript formatting may or may not transfer, depending on how that program handles Excel data.

If you are moving data between spreadsheets and need to preserve subscript formatting, paste into Excel first, then copy from there to your final destination. If you paste into a plain-text editor or email, the subscript formatting will be lost and the text will appear normal.

Frequently Asked Questions

Can I subscript multiple separate characters in the same cell?

Yes. Enter edit mode by double-clicking the cell, select the first character you want to subscript, explore subscript formatting, then select the next character and repeat. Each character or group of characters can be formatted independently within the same cell.

What if the keyboard shortcut does not work on my Mac?

Try the Format Cells method instead: right-click the selected text, choose Format Cells, click the Font tab, and check Subscript. If that does not work, your version of Excel may have a different shortcut — check your Excel menu under Format or Tools to find the subscript option.

Does subscript formatting affect how Excel sorts or filters data?

No. Subscript is only formatting, so Excel sorts and filters based on the actual text or numbers in the cell, not on how they look. A cell containing "H2O" with the 2 subscripted will sort the same way as "H2O" without subscripting.

Can I subscript text in a formula bar or in a cell comment?

You cannot subscript text in the formula bar itself. You can only subscript text that is displayed in the cell. Cell comments do not support subscript formatting in most versions of Excel, though newer versions may have limited support — check your version's documentation.