The quickest way to subscript in Excel

To subscript text in Excel, select the characters you want to make smaller and lower, then press Ctrl + Shift + B on Windows or Cmd + Shift + B on Mac. The text will shrink and drop below the baseline when ready. 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.

Subscript is useful when you need to write chemical formulas (like H₂O), mathematical notation (like x₂), or footnote references in a cell. Excel treats subscripted text as formatting only — the actual characters stay the same, so formulas and sorting still work normally.

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, right-click, choose Format Cells, go to the Font tab, and check Subscript.
  • Subscript formatting does not change the actual text — formulas and cell references still work as written.
  • You can subscript individual characters within a cell, not just the whole cell contents.
  • Superscript uses the same method but with Ctrl + Shift + P (Windows) or Cmd + Shift + P (Mac) instead.

Step-by-step formatting with the Format Cells menu

If the keyboard shortcut does not respond, the menu method works in every version of Excel. First, click inside the cell where your text is. Then double-click the cell or press F2 to enter edit mode so you can select individual characters within it.

Highlight the characters you want to subscript by clicking and dragging across them. Right-click the selection and choose Format Cells from the menu. In the dialog box that opens, click the Font tab at the top. You will see a Subscript checkbox in the lower section — check it and click OK. The selected text will when ready drop and shrink.

Subscripting in different versions of Excel

The keyboard shortcut Ctrl + Shift + B works in Excel for Windows (2016 and newer) and Excel for Mac (2016 and newer). In older versions or in Excel Online, the keyboard shortcut may not work, so use the Format Cells menu instead.

Excel Online (the browser version) does support subscript through the Format Cells menu, but the process is slightly different. Select your text, then look for the Format option in the ribbon at the top. Choose Format Cells and follow the same Font tab steps. If you are using a very old version of Excel (2010 or earlier), the Format Cells menu is still your most reliable option.

Why subscript matters for certain documents

Subscript is not just for appearance — it changes the meaning of what you write. In chemistry, H₂O and H2O look similar but the subscript version is the correct notation. In mathematics, x₂ and x2 are different. If you are sharing a spreadsheet with others or printing it, using proper subscript formatting makes your data clearer and more professional.

Subscript also matters if you are exporting your spreadsheet to PDF or another format. When you use Excel's subscript formatting, the subscript usually carries over to the exported file. If you just type smaller numbers next to regular text, they will not stay positioned correctly when the file is converted.

Removing subscript formatting

To remove subscript from text, select the subscripted characters and press Ctrl + Shift + B again (Windows) or Cmd + Shift + B again (Mac). The text will return to normal size and position. Alternatively, select the text, right-click, choose Format Cells, go to the Font tab, and uncheck the Subscript box.

If you have subscripted text throughout your spreadsheet and want to remove it all at once, select the entire sheet with Ctrl + A, then toggle off subscript using either method. This will remove subscript formatting from every cell while leaving all other formatting (bold, color, font size) unchanged.

Subscript versus superscript

Superscript is the opposite of subscript — the text rises above the baseline instead of dropping below it. Use superscript for exponents (like 2³), trademark symbols, or footnote markers. The keyboard shortcut is Ctrl + Shift + P on Windows or Cmd + Shift + P on Mac. The Format Cells menu method is identical except you check the Superscript box instead of Subscript.

You cannot explore both subscript and superscript to the same character at the same time. If you need both in the same cell, format them separately — for example, subscript the "2" in H₂O and superscript the "+" in a different part of the cell.

When subscript does not work as expected

If you press Ctrl + Shift + B and nothing happens, your version of Excel may not support the keyboard shortcut. Try the Format Cells menu instead. If the Format Cells menu does not show a Subscript option, you are likely using a very limited version of Excel or a spreadsheet program that is not Excel (like Google Sheets, which handles subscript differently).

Another common issue: subscript formatting sometimes does not print correctly if your printer settings are set to draft mode or if you are using a very old printer driver. Test by printing a small section first, or export to PDF to see how it will look before printing the full document.

Frequently Asked Questions

Can I subscript text in Google Sheets the same way?

No. Google Sheets does not have a built-in subscript button or keyboard shortcut. You can use the Insert menu to add special characters, but this is slower. If subscript is important for your work, Excel or LibreOffice Calc are better choices.

Does subscript formatting affect how Excel sorts or filters data?

No. Subscript is purely visual formatting. Excel still sees the text as the original characters, so sorting, filtering, and formulas work exactly the same whether text is subscripted or not.

What if I need to subscript numbers in a formula?

You cannot subscript numbers inside a formula itself — the formula will not calculate correctly. Subscript only works on text that is displayed in a cell. If you need subscript notation for a result, format the cell contents after the formula calculates.

Will subscript formatting stay if I copy and paste the cell?

Yes, if you copy and paste normally, subscript formatting comes along. If you use Paste Special and choose "Values only", the formatting is removed and only the text remains.

Can I make subscript text a different color or font?

Yes. Select the subscripted text and use the font color, font name, or other formatting options in the ribbon. Subscript is just one formatting layer — you can combine it with bold, italic, color, or any other Excel text formatting.