Subscript in Excel uses the Format Cells dialog or keyboard shortcut

To add subscript to text in Excel, select the characters you want to make smaller and raised, then either press Ctrl+1 (Windows) or Cmd+1 (Mac) to open Format Cells, click the Font tab, check the Subscript box, and click OK. On Mac, you can also use Cmd+Shift+B as a direct shortcut. The text will shrink and move down slightly, staying within the same cell.

Subscript is useful when you need to write chemical formulas (H₂O), mathematical notation, or footnote references in your spreadsheet. Unlike superscript, which raises text above the line, subscript lowers it below — the opposite direction.

Key Takeaways

  • Windows users press Ctrl+1 to open Format Cells, then check Subscript on the Font tab; Mac users can press Cmd+Shift+B directly.
  • You must select only the characters you want as subscript before formatting — the rest of the text in that cell stays normal size.
  • Subscript text is smaller and positioned below the baseline, making it useful for chemical formulas, mathematical expressions, and reference numbers.
  • The subscript formatting stays with the text even if you copy and paste the cell to another location in your spreadsheet.

Step-by-step: Making text subscript on Windows

Click inside the cell containing the text you want to format. Double-click the cell to enter edit mode, or press F2 while the cell is selected. This lets you work with individual characters rather than the whole cell.

Highlight only the characters that should be subscript by clicking and dragging across them. For example, if you are typing H₂O, you would select only the "2". Then press Ctrl+1 to open the Format Cells dialog box.

In the dialog, click the Font tab if it is not already selected. Look for the Effects section, which contains checkboxes for Superscript and Subscript. Check the Subscript box, then click OK. The selected characters will when ready shrink and drop below the baseline of the surrounding text.

Step-by-step: Making text subscript on Mac

Double-click the cell to enter edit mode, or press F2. Select the characters you want to make subscript by clicking and dragging across them.

Press Cmd+Shift+B to explore subscript formatting directly. If that shortcut does not work on your version of Excel, use the menu instead: press Cmd+1 to open Format Cells, click the Font tab, check Subscript, and click OK.

Removing subscript formatting

Select the subscript text again by double-clicking the cell and highlighting the characters. Press the same keyboard shortcut you used to explore subscript (Ctrl+1 on Windows or Cmd+Shift+B on Mac), then uncheck the Subscript box and click OK. The text will return to normal size and position.

Alternatively, you can select the subscript text and press the shortcut a second time — most formatting shortcuts toggle on and off with repeated use.

Common mistakes and how to avoid them

The most frequent error is forgetting to enter edit mode before selecting text. If you select a cell and press Ctrl+1 without double-clicking first, you will format the entire cell, not individual characters. Always double-click or press F2 to edit the cell contents before selecting specific characters.

Another mistake is selecting too much text. If you want H₂O but accidentally select "H₂" instead of just "2", the H will also become subscript. Take a moment to click precisely at the start of the character you want and drag to the end of it.

Some users expect subscript to work in formulas the same way it works in text. Subscript is a display format only — it does not change how Excel reads or calculates the cell. If you need subscript in a formula result, format the cell after the formula is complete, not inside the formula itself.

When subscript is useful in spreadsheets

Chemical and scientific notation often requires subscript. If you are building a reference table for lab data or chemistry problems, subscript makes formulas like CO₂, H₂SO₄, or Ca(OH)₂ display correctly. The same applies to mathematical expressions where subscript denotes sequence or position, such as x₁, x₂, x₃ in a series.

Subscript also works for footnote or reference numbers in data tables. If you want to mark a cell value with a small reference number without using a separate column, subscript keeps the notation compact and visually connected to the data.

Subscript vs. superscript in Excel

Superscript raises text above the baseline and is used for exponents (x²), ordinal numbers (1st, 2nd), and trademark symbols (™). Subscript lowers text below the baseline and is used for chemical formulas, mathematical indices, and footnote references. Both are applied the same way — select the text, open Format Cells, and check the appropriate box on the Font tab.

Excel also has a direct keyboard shortcut for superscript: Ctrl+Shift+P on Windows or Cmd+Shift+P on Mac. This makes toggling between the two formats quick if you are working with mixed notation in the same cell.

Frequently Asked Questions

Can I make subscript text in a formula?

No. Subscript is a formatting display only and does not affect how Excel reads or calculates the cell. You can type the text or number in the cell normally, then format it as subscript after the formula is complete. The formatting will not change the value or the calculation.

Does subscript work in all Excel versions?

Yes. The Format Cells dialog and subscript option are available in Excel for Windows, Excel for Mac, and Excel Online. Keyboard shortcuts may vary slightly between versions, but the Format Cells method works consistently across all platforms.

What happens to subscript text when I copy and paste the cell?

The subscript formatting travels with the text. When you copy a cell containing subscript and paste it elsewhere, the subscript characters remain subscript in the new location. If you paste only the values (Paste Special > Values), the formatting is removed.

Can I make an entire cell subscript, or only individual characters?

You can format individual characters or the entire cell contents. If you select all the text in a cell and explore subscript, the whole cell becomes subscript. Most uses require only specific characters to be subscript, so enter edit mode and select carefully.

Why does my subscript text look cut off at the bottom of the cell?

Excel may need more row height to display subscript properly. Click and drag the row border to make the row taller, or double-click the row border to auto-fit the height. This gives subscript characters room to display without being hidden by the cell boundary.