Why does H₂O show up as H2O in your report? Why does your lab manager reject your spreadsheet with 'fix the subscripts'? Why does Excel ignore your font size tweaks when you try to fake it?
Because Excel doesn’t auto-format subscripts like Word does. You’re not missing a setting — you’re missing one precise step. And no, changing font size manually isn’t enough. It breaks alignment, prints inconsistently, and fails on shared workbooks.
The Setup
You’re preparing a materials safety data sheet for Acme Corp’s R&D team. The list includes chemical compounds, molecular weights, and CAS numbers. Your raw data lives in A1:D9:
| Compound | Formula | Molecular Weight (g/mol) | CAS Number |
|---|---|---|---|
| Sulfuric Acid | H2SO4 | 98.08 | 7664-93-9 |
| Sodium Hydroxide | NaOH | 40.00 | 1310-73-2 |
| Carbon Dioxide | CO2 | 44.01 | 124-38-9 |
| Calcium Carbonate | CaCO3 | 100.09 | 471-34-1 |
| Phosphoric Acid | H3PO4 | 98.00 | 7664-38-2 |
| Hydrochloric Acid | HCl | 36.46 | 7647-01-0 |
| Nitric Acid | HNO3 | 63.01 | 7697-37-2 |
| Acetic Acid | CH3COOH | 60.05 | 64-19-7 |
The Challenge
You need to turn H2SO4 into H2SO4, CO2 into CO2, and CaCO3 into CaCO3. Not just visually — but correctly formatted so it prints cleanly, survives copy-paste into PDFs, and stays intact when colleagues open it on Mac or older Excel versions.
Here’s what makes it tricky:
- Excel treats all text in a cell as one object — you can’t apply subscript to part of a cell without selecting characters first.
- Right-click > Format Cells doesn’t expose subscript unless you’re inside the formula bar with text selected.
- Using CHAR(8320) through CHAR(8329) only works for digits 0–9 — no support for letters like ‘a’ or ‘m’ in CO2.
- If you format the entire cell as subscript, everything shrinks — including the ‘H’ and ‘S’, which must stay normal size.
The biggest trap? Assuming Ctrl+Shift+= is the answer. It’s not. That’s superscript. Subscript is Alt+H, F, N — but only after character selection.
Walking Through It
We’ll fix B2 (H2SO4) first. Then replicate across the column. Do this — not that.
| Step | Action | Result | Shortcut |
|---|---|---|---|
| 1 | Click cell B2. Press F2 to edit in-cell. | Cursor appears inside 'H2SO4' in the cell. | F2 |
| 2 | Drag to select only the '2' after H. | Only the digit '2' is highlighted blue. | Mouse drag |
| 3 | Hold Alt, then press H → F → N. | The '2' drops down and shrinks slightly. | Alt+H,F,N |
| 4 | Still in edit mode, select the '4' at the end. | Only the final '4' is selected. | Mouse drag |
| 5 | Press Alt+H,F,N again. | Both '2' and '4' are now subscripted: H2SO4. | Alt+H,F,N |
| 6 | Press Enter to confirm. | Formatting locks in. No auto-reversion. | Enter |
Now do the same for B3: CO2 → CO2. Select only the ‘2’. Alt+H,F,N. Done.
For B4 (CaCO3), select the ‘3’ at the end. Same shortcut. One keystroke sequence — repeated per digit.
What about CH3COOH in B8? Yes — select the ‘3’ after H. Not the ‘O’s, not the ‘C’s. Just the digit. Subscript applies only to numerals — not letters — in standard Excel fonts.
Surprising tip: If you double-click a cell, Excel enters edit mode *and* places the cursor where you clicked. So click directly on the ‘2’ in ‘H2SO4’, then press Shift+Right Arrow once to select only that digit — faster than dragging.
The Result
After applying subscript to all numeric characters in Column B, your final table looks professional and technically accurate:
| Compound | Formula | Molecular Weight (g/mol) | CAS Number |
|---|---|---|---|
| Sulfuric Acid | H2SO4 | 98.08 | 7664-93-9 |
| Sodium Hydroxide | NaOH | 40.00 | 1310-73-2 |
| Carbon Dioxide | CO2 | 44.01 | 124-38-9 |
| Calcium Carbonate | CaCO3 | 100.09 | 471-34-1 |
| Phosphoric Acid | H3PO4 | 98.00 | 7664-38-2 |
| Hydrochloric Acid | HCl | 36.46 | 7647-01-0 |
| Nitric Acid | HNO3 | 63.01 | 7697-37-2 |
| Acetic Acid | CH3COOH | 60.05 | 64-19-7 |
What Could Go Wrong
These three mistakes happen every time — usually in the first 20 minutes of trying this for the first time.
Mistake #1: Formatting the whole cell instead of selecting digits
You right-click B2 > Format Cells > Font tab > check Subscript > OK. Now *all* of H2SO4 drops and shrinks. The ‘H’ and ‘S’ look tiny and misaligned. You’ve broken readability — and there’s no undo for formatting-only changes across multiple cells. Fix: Always select *only the digits* before applying Alt+H,F,N.
Mistake #2: Using Ctrl+Shift+= by muscle memory
You hit Ctrl+Shift+= expecting subscript — but get superscript instead (H²SO⁴). That’s the exact opposite of what you need. Worse: if you don’t notice, you’ll waste 10 minutes fixing each cell twice. Fix: Write “Alt+H,F,N” on a sticky note until it sticks. Superscript has no business here.
Mistake #3: Trying to subscript letters (like ‘a’ in H₂O)
You select the ‘a’ in ‘CaCO3’ and hit Alt+H,F,N. Nothing happens. Or worse — Excel applies subscript to the ‘C’ next to it because your selection slipped. Subscript only works on numerals in standard fonts. No workaround. If you need true chemical notation with italicized element symbols, use Word or LaTeX — not Excel.
Need to scale this beyond 10 rows? Use Find & Replace with wildcards — but only if your patterns are consistent. Example: replace all instances of ‘H2’ with ‘H’+CHAR(8322), then apply subscript formatting to the CHAR result. Not recommended for beginners — stick with manual selection until you’re fast.
Here’s your quick-reference cheat sheet:
| Task | How to Do It | Shortcut |
|---|---|---|
| Enter subscript for a single digit | Edit cell (F2), select digit, press Alt+H,F,N | Alt+H,F,N |
| Exit edit mode without saving changes | Press Esc | Esc |
| Select next character quickly | With cursor placed, press Shift+→ | Shift+→ |
| Apply to multiple non-adjacent digits | Hold Ctrl while clicking each digit, then Alt+H,F,N | Ctrl+click + Alt+H,F,N |
