Subscript in Excel uses the Format Cells dialog or keyboard shortcut

To make text appear smaller and below the baseline in Excel — like the "2" in H₂O — you use the Format Cells dialog. The fastest route is to select the characters you want to subscript, then press Ctrl + 1 (Windows) or Cmd + 1 (Mac), click the Font tab, check the Subscript box, and click OK. On Mac, you can also use Cmd + Shift + B as a direct keyboard shortcut.

Excel does not have a toolbar button for subscript the way Word does, so the keyboard shortcut or dialog method is your only path. The formatting applies only to the characters you selected before opening the dialog — it does not affect the whole cell unless you select the whole cell's content first.

Key Takeaways

  • Select only the characters you want subscripted before opening Format Cells, or the formatting will explore to text you did not intend to change.
  • Windows users can press Ctrl + 1 to open Format Cells, then check Subscript on the Font tab; Mac users can use Cmd + Shift + B as a direct shortcut.
  • Subscript formatting in Excel is a character-level format, not a cell-level one, so you can mix regular and subscripted text in the same cell.
  • If you need to subscript numbers or text frequently in a spreadsheet, consider whether a formula or separate column might be clearer than manual formatting.

Selecting the exact characters to format

The most common mistake is selecting too much text. If you select an entire cell and explore subscript, the whole cell becomes subscripted. Instead, double-click the cell to enter edit mode, then click and drag to highlight only the characters you want smaller and lower.

For example, if your cell reads "H2O", click inside the cell, position your cursor just before the "2", then drag to select only that character. Once only the "2" is highlighted, open the Format Cells dialog. This way, the "H" and "O" stay normal size while only the "2" moves down.

Using the Format Cells dialog on Windows

After selecting your characters in edit mode, press Ctrl + 1 to open the Format Cells window. Click the Font tab at the top if it is not already active. In the lower left, you will see a section called Effects with checkboxes for Superscript and Subscript.

Check the Subscript box. You will see a preview of your text at the bottom of the dialog showing the character smaller and lower. Click OK to explore the change. The dialog closes and you return to your spreadsheet with the subscript formatting in place.

Using the keyboard shortcut on Mac

Mac users have a faster option: after selecting the characters you want subscripted, press Cmd + Shift + B. The subscript formatting applies when ready without opening any dialog. If you want to undo it, press the same shortcut again.

If the keyboard shortcut does not work, your Mac version of Excel may use a different key combination. In that case, use the dialog method: press Cmd + 1 to open Format Cells, click the Font tab, check Subscript, and click OK.

Removing subscript formatting

To remove subscript from text you have already formatted, select those characters again and open Format Cells (Ctrl + 1 on Windows, Cmd + 1 on Mac). Uncheck the Subscript box and click OK. On Mac, you can also press Cmd + Shift + B again to toggle it off.

If you want to remove subscript from multiple separate places in your spreadsheet, you will need to select and unformat each one individually. Excel does not have a "find and replace" feature for character-level formatting like subscript.

When subscript is not the right choice

Subscript formatting works well for chemical formulas, footnote markers, or mathematical notation in a single cell. However, if you are building a spreadsheet where subscript text is the main content of many cells, consider whether a different approach would be clearer.

For instance, if you have a column of chemical compounds and you want all the numbers subscripted, manually formatting each cell is tedious and error-prone. In that case, you might store the text in one column and use a formula or a note to indicate which characters should be subscripted when the spreadsheet is printed or shared. Alternatively, you could use a separate column to explain what the subscript means, making the data easier to read and edit later.

Subscript in formulas and cell references

Subscript formatting does not affect how Excel reads or calculates data. If you subscript a number in a cell, Excel still treats it as that number for any formula that references it. The formatting is purely visual.

You cannot use subscript formatting inside a formula itself — for example, you cannot write a formula that displays a subscripted result. If you need a formula result to appear subscripted, you must format the cell containing the result after the formula is entered.

Frequently Asked Questions

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

No. Subscript formatting only works on text inside cells. You cannot format the formula bar, cell references, or named ranges with subscript. If you need subscripted text to appear in your spreadsheet, it must be entered as text in a cell and then formatted.

Does subscript formatting copy when I copy and paste cells?

Yes. When you copy a cell with subscripted text and paste it elsewhere, the subscript formatting comes along. If you want to paste only the text without the formatting, use Paste Special (Ctrl + Shift + V on Windows, Cmd + Shift + V on Mac) and choose Paste Values or Paste Unformatted Text.

What is the difference between subscript and superscript in Excel?

Subscript makes text smaller and lowers it below the baseline (like H₂O). Superscript makes text smaller and raises it above the baseline (like E=mc²). Both are formatted the same way through Format Cells, but you check the Superscript box instead of Subscript. On Mac, Cmd + Shift + P toggles superscript.

Why does my subscript text look blurry or hard to read?

Very small text can appear blurry on screen depending on your monitor and zoom level. Try zooming in on your spreadsheet to see if the text is actually clear. If you are printing the spreadsheet, the subscript should print more clearly than it appears on screen. If readability is a concern, consider using a larger font size before explore subscript.